View: CSTBV_COST_GROUPS

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

View Text

SELECT /* REGULAR ATTRIBUTE */ CCG.COST_GROUP_ID
, NVL(CCG.ORGANIZATION_ID
, CCGA.ORGANIZATION_ID)
, CCG.COST_GROUP
, CCG.DESCRIPTION
, CCG.DISABLE_DATE
, /* FOREIGN KEYS RESOLVED */ NVL(MP.ORGANIZATION_CODE
, MP1.ORGANIZATION_CODE)
, NVL(HAOU.NAME
, HAOU1.NAME)
, /* ID */ CCGA.MATERIAL_ACCOUNT
, CCGA.MATERIAL_OVERHEAD_ACCOUNT
, CCGA.RESOURCE_ACCOUNT
, CCGA.OVERHEAD_ACCOUNT
, CCGA.OUTSIDE_PROCESSING_ACCOUNT
, CCGA.AVERAGE_COST_VAR_ACCOUNT
, CCGA.ENCUMBRANCE_ACCOUNT
, CCGA.PAYBACK_MAT_VAR_ACCOUNT
, CCGA.PAYBACK_RES_VAR_ACCOUNT
, CCGA.PAYBACK_OSP_VAR_ACCOUNT
, CCGA.PAYBACK_MOH_VAR_ACCOUNT
, CCGA.PAYBACK_OVH_VAR_ACCOUNT
, CCG.LEGAL_ENTITY
, CCG.COST_GROUP_TYPE
, /* WHO */ CCG.CREATION_DATE
, CCG.CREATED_BY
, CCG.LAST_UPDATE_DATE
, CCG.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, HR_ALL_ORGANIZATION_UNITS HAOU1
, MTL_PARAMETERS MP
, MTL_PARAMETERS MP1
, CST_COST_GROUPS CCG
, CST_COST_GROUP_ACCOUNTS CCGA
WHERE CCG.COST_GROUP_ID = CCGA.COST_GROUP_ID (+)
AND CCG.ORGANIZATION_ID = MP1.ORGANIZATION_ID (+)
AND CCGA.ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND HAOU1.ORGANIZATION_ID (+) = CCG.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID (+) = CCGA.ORGANIZATION_ID

Columns