Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTFV_COST_TYPES |
SELECT CO.COST_TYPE_ID
, CO.ORGANIZATION_ID
, CO.ALTERNATE_BOM_DESIGNATOR
, CO.COST_TYPE
, CO1.COST_TYPE
, '_LA:CO.BOM_SNAPSHOT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.PL_ELEMENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.PL_RESOURCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.PL_OPERATION_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.PL_ACTIVITY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.COMPONENT_YIELD_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, CO.DESCRIPTION
, '_LA:CO.ALLOW_UPDATES_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, CO.DISABLE_DATE
, '_LA:CO.AVAILABLE_TO_ENG_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, DECODE(CO.ORGANIZATION_ID
, NULL
, 1
, 0)
, PA.ORGANIZATION_CODE
, AL1.NAME
, AL.ALTERNATE_DESIGNATOR_CODE
, CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
FROM BOM_ALTERNATE_DESIGNATORS AL
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA
, CST_COST_TYPES CO
, CST_COST_TYPES CO1
WHERE CO1.COST_TYPE_ID = CO.DEFAULT_COST_TYPE_ID
AND CO.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND CO.ORGANIZATION_ID = AL1.ORGANIZATION_ID(+)
AND CO.ALTERNATE_BOM_DESIGNATOR = AL.ALTERNATE_DESIGNATOR_CODE(+)
AND '_SEC:CO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY