ODBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

StandardLookupsLOV

Enables querying and retrieval of standard lookup values, including codes and their translated meanings for reference data sharing.

Columns

Name Type SupportedFinders Description
LookupType [KEY] String PrimaryKey, LookupTypeFinder, LookupTypeAllRowsFinder Type of lookup used to categorize different sets of codes.
LookupCode [KEY] String LookupTypeAllRowsFinder, PrimaryKey, LookupTypeFinder Unique identifier for the specific lookup entry within the lookup type.
Meaning String User-friendly label or meaning assigned to the lookup code.
Description String Detailed description providing context for the lookup code.
Tag String Tag associated with the lookup code for additional classification or grouping.
ActiveDate Date LookupTypeFinder Date when the lookup code becomes active and available for use.
Bind_ParentLookupCode String LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder Parent lookup code that establishes a hierarchical relationship between lookups.
Bind_ParentSetidDetermType String LookupTypeCascadingAllRowsFinder, LookupTypeCascadingFinder Determination type for parent lookup set ID, used for context-based filtering.
Bind_ParentSetidDetermValue String LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder Determination value that links the lookup to a specific parent set.
Bind_RelationshipId Long LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder Unique identifier for the relationship between lookup entries.
BindActiveDate Date LookupTypeTagFinder, LookupTypeMultiCodesFinder, LookupTypeCascadingFinder Date when the bound lookup relationship becomes active.
BindLookupCode String LookupTypeMultiCodesFinder, LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder, LookupTypeTagFinder, LookupTypeNotCodeFinder Lookup code that is bound to another lookup entry for reference.
BindLookupType String LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder, LookupTypeTagFinder, LookupTypeNotCodeFinder, LookupTypeMultiCodesFinder Lookup type that is bound to another lookup entry.
BindTag String LookupTypeTagFinder Tag associated with the bound lookup entry.
Finder String Searchable reference field used to locate specific lookup values.
NewLookupCode1 String LookupTypeMultiCodesFinder Additional lookup code field for storing a new or alternate value.
NewLookupCode2 String LookupTypeMultiCodesFinder Additional lookup code field for storing a second new or alternate value.
NewLookupCode3 String LookupTypeMultiCodesFinder Additional lookup code field for storing a third new or alternate value.
NewLookupCode4 String LookupTypeMultiCodesFinder Additional lookup code field for storing a fourth new or alternate value.
NewLookupCode5 String LookupTypeMultiCodesFinder Additional lookup code field for storing a fifth new or alternate value.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770