VIEW: APPS.CSTFV_MATL_COST_SUB_ELEMENT

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTE */ BR.RESOURCE_ID , BR.RESOURCE_CODE , BR.DESCRIPTION , BR.DISABLE_DATE , BR.EXPENDITURE_TYPE , '_LA:br.default_basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , '_LA:br.cost_code_type:MFG_LOOKUPS:CST_COST_CODE_TYPE:MEANING' , /* ID */ MP.ORGANIZATION_CODE , HAOU.NAME , BR.ORGANIZATION_ID , CA.ACTIVITY , BR.DEFAULT_ACTIVITY_ID , '_DF:BOM:BOM_RESOURCES:br' , /* WHO */ BR.CREATION_DATE , BR.CREATED_BY , BR.LAST_UPDATE_DATE , BR.LAST_UPDATED_BY FROM CST_ACTIVITIES CA, HR_ALL_ORGANIZATION_UNITS HAOU, MTL_PARAMETERS MP, BOM_RESOURCES BR WHERE BR.COST_ELEMENT_ID = 1 AND BR.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HAOU.ORGANIZATION_ID = BR.ORGANIZATION_ID AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+) AND '_SEC:BR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTE */ BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, BR.DISABLE_DATE
, BR.EXPENDITURE_TYPE
, '_LA:BR.DEFAULT_BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, '_LA:BR.COST_CODE_TYPE:MFG_LOOKUPS:CST_COST_CODE_TYPE:MEANING'
, /* ID */ MP.ORGANIZATION_CODE
, HAOU.NAME
, BR.ORGANIZATION_ID
, CA.ACTIVITY
, BR.DEFAULT_ACTIVITY_ID
, '_DF:BOM:BOM_RESOURCES:BR'
, /* WHO */ BR.CREATION_DATE
, BR.CREATED_BY
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
FROM CST_ACTIVITIES CA
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, BOM_RESOURCES BR
WHERE BR.COST_ELEMENT_ID = 1
AND BR.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = BR.ORGANIZATION_ID
AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+)
AND '_SEC:BR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY