VIEW: APPS.CSTBV_COST_GROUPS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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