VIEW: APPS.CSTFV_MFG_RESOURCE_OVERHEADS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTE */ CRO.COST_TYPE_ID , CRO.RESOURCE_ID , CRO.OVERHEAD_ID , CCT.COST_TYPE , BR.RESOURCE_CODE , BR1.RESOURCE_CODE , MP.ORGANIZATION_CODE , HAOU.NAME , '_DF:BOM:CST_RESOURCE_OVERHEADS:cro' , /* ID */ CRO.ORGANIZATION_ID , /* WHO */ CRO.CREATION_DATE , CRO.CREATED_BY , CRO.LAST_UPDATE_DATE , CRO.LAST_UPDATED_BY FROM CST_COST_TYPES CCT, HR_ALL_ORGANIZATION_UNITS HAOU, MTL_PARAMETERS MP, BOM_RESOURCES BR, BOM_RESOURCES BR1, CST_RESOURCE_OVERHEADS CRO WHERE CRO.COST_TYPE_ID = CCT.COST_TYPE_ID AND CRO.RESOURCE_ID = BR.RESOURCE_ID AND CRO.RESOURCE_ID = BR1.RESOURCE_ID AND CRO.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HAOU.ORGANIZATION_ID = CRO.ORGANIZATION_ID AND '_SEC:cro.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTE */ CRO.COST_TYPE_ID
, CRO.RESOURCE_ID
, CRO.OVERHEAD_ID
, CCT.COST_TYPE
, BR.RESOURCE_CODE
, BR1.RESOURCE_CODE
, MP.ORGANIZATION_CODE
, HAOU.NAME
, '_DF:BOM:CST_RESOURCE_OVERHEADS:CRO'
, /* ID */ CRO.ORGANIZATION_ID
, /* WHO */ CRO.CREATION_DATE
, CRO.CREATED_BY
, CRO.LAST_UPDATE_DATE
, CRO.LAST_UPDATED_BY
FROM CST_COST_TYPES CCT
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, BOM_RESOURCES BR
, BOM_RESOURCES BR1
, CST_RESOURCE_OVERHEADS CRO
WHERE CRO.COST_TYPE_ID = CCT.COST_TYPE_ID
AND CRO.RESOURCE_ID = BR.RESOURCE_ID
AND CRO.RESOURCE_ID = BR1.RESOURCE_ID
AND CRO.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = CRO.ORGANIZATION_ID
AND '_SEC:CRO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY