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: CSTBV_COST_GROUP_ASSIGNMENTS

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

View Text

SELECT CCCGA.COST_GROUP_ID
, CCCGA.ORGANIZATION_ID
, CCG.COST_GROUP
, MP.ORGANIZATION_CODE
, HAOU.NAME
, CCCGA.CREATION_DATE
, CCCGA.CREATED_BY
, CCCGA.LAST_UPDATE_DATE
, CCCGA.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, CST_COST_GROUPS CCG
, CST_COST_GROUP_ASSIGNMENTS CCCGA
WHERE CCCGA.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = CCCGA.ORGANIZATION_ID
AND CCCGA.COST_GROUP_ID = CCG.COST_GROUP_ID
AND '_SEC:CCCGA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
COST_GROUP_ID
ORGANIZATION_ID
COST_GROUP_NAME
ORGANIZATION_CODE
ORGANIZATION_NAME
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
UPDATED_BY