JDBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

StandardLookupsLOV

Provides a queryable list of standard lookup codes and their descriptions, supporting consistent reference data sharing.

Columns

Name Type SupportedFinders Description
LookupType [KEY] String PrimaryKey, LookupTypeFinder, LookupTypeAllRowsFinder The category or type of lookup associated with the value.
LookupCode [KEY] String LookupTypeAllRowsFinder, PrimaryKey, LookupTypeFinder A unique code representing a specific lookup value.
Meaning String The user-friendly meaning or label associated with the lookup code.
Description String A detailed description of the lookup value.
Tag String An optional tag used for classification or grouping of the lookup value.
ActiveDate Date LookupTypeFinder The date when the lookup value becomes active.
Bind_ParentLookupCode String LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder The parent lookup code to which this lookup value is related.
Bind_ParentSetidDetermType String LookupTypeCascadingAllRowsFinder, LookupTypeCascadingFinder Specifies the determination type for the parent set ID.
Bind_ParentSetidDetermValue String LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder The value used to determine the parent set ID.
Bind_RelationshipId Long LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder A unique identifier for the relationship between lookups.
BindActiveDate Date LookupTypeTagFinder, LookupTypeMultiCodesFinder, LookupTypeCascadingFinder The active date for the bound lookup relationship.
BindLookupCode String LookupTypeMultiCodesFinder, LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder, LookupTypeTagFinder, LookupTypeNotCodeFinder The lookup code to which this lookup value is bound.
BindLookupType String LookupTypeCascadingFinder, LookupTypeCascadingAllRowsFinder, LookupTypeTagFinder, LookupTypeNotCodeFinder, LookupTypeMultiCodesFinder The lookup type to which this lookup value is bound.
BindTag String LookupTypeTagFinder A tag associated with the bound lookup relationship.
Finder String A system-generated reference used to locate lookup values.
NewLookupCode1 String LookupTypeMultiCodesFinder A new or alternative lookup code that can be used as a reference.
NewLookupCode2 String LookupTypeMultiCodesFinder A second alternative lookup code that can be used as a reference.
NewLookupCode3 String LookupTypeMultiCodesFinder A third alternative lookup code that can be used as a reference.
NewLookupCode4 String LookupTypeMultiCodesFinder A fourth alternative lookup code that can be used as a reference.
NewLookupCode5 String LookupTypeMultiCodesFinder A fifth alternative lookup code that can be used as a reference.

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