Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTFV_COST_GROUPS |
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)
, XFI.NAME
, '_LA:CCG.COST_GROUP_TYPE:MFG_LOOKUPS:CST_COST_GROUP_TYPE:MEANING'
, '_DF:BOM:CST_COST_GROUPS:CCG'
, /* ID */ CCGA.MATERIAL_ACCOUNT
, '_KF:SQLGL:GL#:GCC1'
, CCGA.MATERIAL_OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GCC2'
, CCGA.RESOURCE_ACCOUNT
, '_KF:SQLGL:GL#:GCC3'
, CCGA.OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GCC4'
, CCGA.OUTSIDE_PROCESSING_ACCOUNT
, '_KF:SQLGL:GL#:GCC5'
, CCGA.AVERAGE_COST_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC6'
, CCGA.ENCUMBRANCE_ACCOUNT
, '_KF:SQLGL:GL#:GCC7'
, CCGA.PAYBACK_MAT_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC8'
, CCGA.PAYBACK_RES_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC9'
, CCGA.PAYBACK_OSP_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC10'
, CCGA.PAYBACK_MOH_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC11'
, CCGA.PAYBACK_OVH_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC12'
, CCG.LEGAL_ENTITY
, CCG.COST_GROUP_TYPE
, /* WHO */ CCG.CREATION_DATE
, CCG.CREATED_BY
, CCG.LAST_UPDATE_DATE
, CCG.LAST_UPDATED_BY
FROM GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, GL_CODE_COMBINATIONS GCC3
, GL_CODE_COMBINATIONS GCC4
, GL_CODE_COMBINATIONS GCC5
, GL_CODE_COMBINATIONS GCC6
, GL_CODE_COMBINATIONS GCC7
, GL_CODE_COMBINATIONS GCC8
, GL_CODE_COMBINATIONS GCC9
, GL_CODE_COMBINATIONS GCC10
, GL_CODE_COMBINATIONS GCC11
, GL_CODE_COMBINATIONS GCC12
, HR_ALL_ORGANIZATION_UNITS HAOU
, HR_ALL_ORGANIZATION_UNITS HAOU1
, XLE_FIRSTPARTY_INFORMATION_V XFI
, 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 XFI.LEGAL_ENTITY_ID(+) = CCG.LEGAL_ENTITY
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
AND CCGA.MATERIAL_ACCOUNT = GCC1.CODE_COMBINATION_ID (+)
AND CCGA.MATERIAL_OVERHEAD_ACCOUNT = GCC2.CODE_COMBINATION_ID (+)
AND CCGA.RESOURCE_ACCOUNT = GCC3.CODE_COMBINATION_ID (+)
AND CCGA.OVERHEAD_ACCOUNT = GCC4.CODE_COMBINATION_ID (+)
AND CCGA.OUTSIDE_PROCESSING_ACCOUNT = GCC5.CODE_COMBINATION_ID (+)
AND CCGA.AVERAGE_COST_VAR_ACCOUNT = GCC6.CODE_COMBINATION_ID (+)
AND CCGA.ENCUMBRANCE_ACCOUNT = GCC7.CODE_COMBINATION_ID (+)
AND CCGA.PAYBACK_MAT_VAR_ACCOUNT = GCC8.CODE_COMBINATION_ID (+)
AND CCGA.PAYBACK_RES_VAR_ACCOUNT = GCC9.CODE_COMBINATION_ID (+)
AND CCGA.PAYBACK_OSP_VAR_ACCOUNT = GCC10.CODE_COMBINATION_ID (+)
AND CCGA.PAYBACK_MOH_VAR_ACCOUNT = GCC11.CODE_COMBINATION_ID (+)
AND CCGA.PAYBACK_OVH_VAR_ACCOUNT = GCC12.CODE_COMBINATION_ID (+)