[Home] [Help]
View: CSTFV_MFG_RESOURCE_COSTS
View Text
SELECT /* REGULAR ATTRIBUTE */ CRC.COST_TYPE_ID
, CRC.RESOURCE_ID
, CRC.RESOURCE_RATE
, CCT.COST_TYPE
, BR.RESOURCE_CODE
, MP.ORGANIZATION_CODE
, HAOU.NAME
, '_DF:BOM:CST_RESOURCE_COSTS:CRC'
, /* ID */ CRC.ORGANIZATION_ID
, /* WHO */ CRC.CREATION_DATE
, CRC.CREATED_BY
, CRC.LAST_UPDATE_DATE
, CRC.LAST_UPDATED_BY
FROM CST_COST_TYPES CCT
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, BOM_RESOURCES BR
, CST_RESOURCE_COSTS CRC
WHERE CRC.COST_TYPE_ID = CCT.COST_TYPE_ID
AND CRC.RESOURCE_ID = BR.RESOURCE_ID
AND CRC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CRC.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND '_SEC:CRC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| COST_TYPE_ID |
| RESOURCE_ID |
| RESOURCE_RATE |
| COST_TYPE_NAME |
| RESOURCE_NAME |
| ORGANIZATION_CODE |
| ORGANIZATION_NAME |
| "_DF" |
| ORGANIZATION_ID |
| CREATED_DATE |
| CREATED_BY |
| UPDATED_DATE |
| UPDATED_BY |
APPS.CSTFV_MFG_RESOURCE_COSTS