VIEW: APPS.CSTFV_COST_TYPES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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