VIEW: APPS.CSTFV_MFG_DEPARTMENT_OVERHEADS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTE */ CDO.COST_TYPE_ID , CDO.DEPARTMENT_ID , CDO.OVERHEAD_ID , '_LA:cdo.basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , CDO.RATE_OR_AMOUNT , CCT.COST_TYPE , BD.DEPARTMENT_CODE , BR.RESOURCE_CODE , MP.ORGANIZATION_CODE , HAOU.NAME , CA.ACTIVITY , '_DF:BOM:CST_DEPARTMENT_OVERHEADS:cdo' , /* ID */ CDO.ORGANIZATION_ID , CDO.ACTIVITY_ID , /* WHO */ CDO.CREATION_DATE , CDO.CREATED_BY , CDO.LAST_UPDATE_DATE , CDO.LAST_UPDATED_BY FROM CST_COST_TYPES CCT, BOM_DEPARTMENTS BD, CST_ACTIVITIES CA, BOM_RESOURCES BR, HR_ALL_ORGANIZATION_UNITS HAOU, MTL_PARAMETERS MP, CST_DEPARTMENT_OVERHEADS CDO WHERE CDO.COST_TYPE_ID = CCT.COST_TYPE_ID AND CDO.DEPARTMENT_ID = BD.DEPARTMENT_ID AND CDO.OVERHEAD_ID = BR.RESOURCE_ID AND CDO.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HAOU.ORGANIZATION_ID = CDO.ORGANIZATION_ID AND CDO.ACTIVITY_ID = CA.ACTIVITY_ID (+) AND '_SEC:cdo.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTE */ CDO.COST_TYPE_ID
, CDO.DEPARTMENT_ID
, CDO.OVERHEAD_ID
, '_LA:CDO.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, CDO.RATE_OR_AMOUNT
, CCT.COST_TYPE
, BD.DEPARTMENT_CODE
, BR.RESOURCE_CODE
, MP.ORGANIZATION_CODE
, HAOU.NAME
, CA.ACTIVITY
, '_DF:BOM:CST_DEPARTMENT_OVERHEADS:CDO'
, /* ID */ CDO.ORGANIZATION_ID
, CDO.ACTIVITY_ID
, /* WHO */ CDO.CREATION_DATE
, CDO.CREATED_BY
, CDO.LAST_UPDATE_DATE
, CDO.LAST_UPDATED_BY
FROM CST_COST_TYPES CCT
, BOM_DEPARTMENTS BD
, CST_ACTIVITIES CA
, BOM_RESOURCES BR
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, CST_DEPARTMENT_OVERHEADS CDO
WHERE CDO.COST_TYPE_ID = CCT.COST_TYPE_ID
AND CDO.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND CDO.OVERHEAD_ID = BR.RESOURCE_ID
AND CDO.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = CDO.ORGANIZATION_ID
AND CDO.ACTIVITY_ID = CA.ACTIVITY_ID (+)
AND '_SEC:CDO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY