[Home] [Help]
View: CSTBV_MFG_DEPARTMENT_OVERHEADS
View Text
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
, /* 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
, BOM_RESOURCES BR
, 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 '_SEC:CDO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| COST_TYPE_ID |
| DEPARTMENT_ID |
| OVERHEAD_ID |
| "_LA:UNIT_BASIS" |
| RATE_OR_AMOUNT |
| COST_TYPE_NAME |
| DEPARTMENT_NAME |
| OVERHEAD_NAME |
| ORGANIZATION_ID |
| ACTIVITY_ID |
| CREATED_DATE |
| CREATED_BY |
| UPDATED_DATE |
| UPDATED_BY |
APPS.CSTBV_MFG_DEPARTMENT_OVERHEADS