VIEW: APPS.CSTFV_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) , 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 (+)

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)
, 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 (+)