View: CZFV_CONFIG_AUTOSELECT_RANGES

View Text

SELECT AU.RANGE_ID
, AU.FROM_RANGE
, AU.TO_RANGE
, AU.EFFECTIVITY_DATE
, AU.DISABLE_DATE
, '_LA:AU.AUTOSELECT_ON_BOOK:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:AU.PRICE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, AT.NAME
, CO.NAME
, '_KF:INV:MSTK:SYIT'
, PA.ORGANIZATION_CODE
, AL.NAME
, COLO.MEANING
, AU.OPT_ATTRIBUTE_CODE
, AU.ASSIGNMENT_ID
, '_DF:BOM:CZ_AUTOSELECTION_RANGES:AU'
, AU.CREATION_DATE
, AU.CREATED_BY
, AU.LAST_UPDATE_DATE
, AU.LAST_UPDATED_BY
FROM FND_COMMON_LOOKUPS COLO
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SYIT
, CZ_CONSTRAINTS_VL CO
, CZ_CONSTRAINT_ASSIGNMENTS COAS
, AK_ATTRIBUTES_VL AT
, CZ_AUTOSELECTION_RANGES AU
WHERE AU.OPT_ATTRIBUTE_CODE = AT.ATTRIBUTE_CODE(+)
AND AT.ATTRIBUTE_APPLICATION_ID(+) = 702
AND AU.ASSIGNMENT_ID = COAS.ASSIGNMENT_ID
AND COAS.CONSTRAINT_ID = CO.CONSTRAINT_ID
AND COAS.INVENTORY_ITEM_ID = SYIT.INVENTORY_ITEM_ID(+)
AND COAS.ORGANIZATION_ID = SYIT.ORGANIZATION_ID(+)
AND COAS.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND COAS.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND COAS.SYSTEM_TYPE_CODE = COLO.LOOKUP_CODE(+)
AND COLO.APPLICATION_ID(+) = 702
AND COLO.LOOKUP_TYPE(+) = 'CZ_SYSTEM_TYPES' WITH READ ONLY

Columns