Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT AU.AUTOSELECTION_ID
, '_KF:INV:MSTK:SY1'
, PA.ORGANIZATION_CODE
, AL.NAME
, AU.QUANTITY
, '_LA:AU.AUTOSELECT_ON_BOOK:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:AU.PRICE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, AU.EFFECTIVITY_DATE
, AU.DISABLE_DATE
, AURA.FROM_RANGE
, AURA.TO_RANGE
, AT.NAME
, AURA.EFFECTIVITY_DATE
, AURA.DISABLE_DATE
, CO.NAME
, '_KF:INV:MSTK:SY2'
, COLO.MEANING
, AU.RANGE_ID
, AU.ASSIGNMENT_ID
, AU.INVENTORY_ITEM_ID
, AU.ORGANIZATION_ID
, '_DF:BOM:CZ_AUTOSELECTION_ITEMS:AU'
, AU.CREATION_DATE
, AU.CREATED_BY
, AU.LAST_UPDATE_DATE
, AU.LAST_UPDATED_BY
FROM FND_COMMON_LOOKUPS COLO
, AK_ATTRIBUTES_VL AT
, CZ_AUTOSELECTION_RANGES AURA
, MTL_SYSTEM_ITEMS SY2
, CZ_CONSTRAINTS CO
, CZ_CONSTRAINT_ASSIGNMENTS COAS
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY1
, CZ_AUTOSELECTION_ITEMS AU
WHERE AU.INVENTORY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND AU.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND AU.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND AU.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND AU.RANGE_ID = AURA.RANGE_ID(+)
AND AURA.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 = SY2.INVENTORY_ITEM_ID(+)
AND COAS.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND COAS.SYSTEM_TYPE_CODE = COLO.LOOKUP_CODE(+)
AND COLO.APPLICATION_ID(+) = 702
AND COLO.LOOKUP_TYPE(+) = 'CZ_SYSTEM_TYPES'
AND '_SEC:AU.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY