eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CSTFV_MFG_RESOURCE_OVERHEADS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_MFG_RESOURCE_OVERHEADS

View Text

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

Columns

Name
COST_TYPE_ID
RESOURCE_ID
OVERHEAD_ID
COST_TYPE_NAME
RESOURCE_NAME
OVERHEAD_NAME
ORGANIZATION_CODE
ORGANIZATION_NAME
"_DF"
ORGANIZATION_ID
CREATED_DATE
CREATED_BY
UPDATED_DATE
UPDATED_BY