[Home] [Help]
View: CSTFV_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 |