[Home] [Help]
| Product: | BOM - Bills of Material |
|---|---|
| Description: | - Retrofitted |
| Implementation/DBA Data: | Not implemented in this database |
SELECT COAS.ASSIGNMENT_ID
, CO.NAME
, '_KF:INV:MSTK:SY'
, PA.ORGANIZATION_CODE
, AL.NAME
, FCL3.MEANING
, FCL1.MEANING
, FCL2.MEANING
, COAS.SEQUENCE_NUMBER
, CZDVCONS.ASSIGNMENT_RENAME_EXPRESSION(COAS.OPTIMIZE_EXPRESSION)
, COAS.EFFECTIVITY_DATE
, COAS.DISABLE_DATE
, COAS.ECN_CODE
, '_LA:COAS.EVALUATE_ON_TRUE:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COAS.OPTIMIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COAS.REVENUE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COAS.AUTOSELECT_ON_BOOK:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COAS.PRICE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, COAS.CONSTRAINT_ID
, COAS.INVENTORY_ITEM_ID
, COAS.ORGANIZATION_ID
, COAS.SYSTEM_TYPE_CODE
, COAS.CONSTRAINT_GROUP
, COAS.AUTOSELECTION_TYPE
, COAS.OPTIMIZE_EXPRESSION
, '_DF:BOM:CZ_CONSTRAINT_ASSIGNMENTS:COAS'
, COAS.CREATION_DATE
, COAS.CREATED_BY
, COAS.LAST_UPDATE_DATE
, COAS.LAST_UPDATED_BY
FROM FND_COMMON_LOOKUPS FCL3
, FND_COMMON_LOOKUPS FCL2
, FND_COMMON_LOOKUPS FCL1
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY
, CZ_CONSTRAINTS CO
, CZ_CONSTRAINT_ASSIGNMENTS COAS
WHERE COAS.CONSTRAINT_ID = CO.CONSTRAINT_ID
AND COAS.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID(+)
AND COAS.ORGANIZATION_ID = SY.ORGANIZATION_ID(+)
AND COAS.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND COAS.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND COAS.CONSTRAINT_GROUP = FCL1.LOOKUP_CODE
AND FCL1.LOOKUP_TYPE = 'CZ_CONSTRAINT_GROUPS'
AND FCL1.APPLICATION_ID = 702
AND COAS.AUTOSELECTION_TYPE = FCL2.LOOKUP_CODE(+)
AND FCL2.LOOKUP_TYPE(+) = 'CZ_AUTOSELECTION_TYPES'
AND FCL2.APPLICATION_ID(+) = 702
AND COAS.SYSTEM_TYPE_CODE = FCL3.LOOKUP_CODE(+)
AND FCL3.LOOKUP_TYPE(+) = 'CZ_SYSTEM_TYPES'
AND FCL3.APPLICATION_ID(+) = 702
AND '_SEC:COAS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY