VIEW: APPS.PJMFV_PROJECT_MFG_ORGS

Source

View Text - Preformatted

SELECT POP.ORGANIZATION_ID , MP.ORGANIZATION_CODE , HOU.NAME , '_DF:PJM:PJM_ORG_PARAMETERS:POP' , POP.PROJECT_CONTROL_LEVEL , '_LA:POP.ALLOW_CROSS_PROJ_ISSUES:FND_COMMON_LOOKUPS:YES_NO:MEANING' , POP.COMMON_PROJECT_ID , PROJ.SEGMENT1 , PROJ.NAME , '_LA:POP.TRANSFER_IPV:FND_COMMON_LOOKUPS:YES_NO:MEANING' , POP.IPV_EXPENDITURE_TYPE , '_LA:POP.TRANSFER_ERV:FND_COMMON_LOOKUPS:YES_NO:MEANING' , POP.ERV_EXPENDITURE_TYPE , '_LA:POP.TRANSFER_FREIGHT:FND_COMMON_LOOKUPS:YES_NO:MEANING' , POP.FREIGHT_EXPENDITURE_TYPE , '_LA:POP.TRANSFER_TAX:FND_COMMON_LOOKUPS:YES_NO:MEANING' , POP.TAX_EXPENDITURE_TYPE , '_LA:POP.TRANSFER_MISC:FND_COMMON_LOOKUPS:YES_NO:MEANING' , POP.MISC_EXPENDITURE_TYPE , POP.PAYBACK_MAT_VAR_ACCOUNT , '_KF:SQLGL:GL#:GCC1' , POP.PAYBACK_MOH_VAR_ACCOUNT , '_KF:SQLGL:GL#:GCC2' , POP.PAYBACK_RES_VAR_ACCOUNT , '_KF:SQLGL:GL#:GCC3' , POP.PAYBACK_OSP_VAR_ACCOUNT , '_KF:SQLGL:GL#:GCC4' , POP.PAYBACK_OVH_VAR_ACCOUNT , '_KF:SQLGL:GL#:GCC5' , POP.CREATION_DATE , POP.CREATED_BY , POP.LAST_UPDATE_DATE , POP.LAST_UPDATED_BY FROM PJM_ORG_PARAMETERS POP , MTL_PARAMETERS MP , HR_ALL_ORGANIZATION_UNITS HOU , PA_PROJECTS_ALL PROJ , GL_CODE_COMBINATIONS GCC1 , GL_CODE_COMBINATIONS GCC2 , GL_CODE_COMBINATIONS GCC3 , GL_CODE_COMBINATIONS GCC4 , GL_CODE_COMBINATIONS GCC5 WHERE MP.ORGANIZATION_ID = POP.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = POP.ORGANIZATION_ID AND PROJ.PROJECT_ID (+) = POP.COMMON_PROJECT_ID AND GCC1.CODE_COMBINATION_ID (+) = POP.PAYBACK_MAT_VAR_ACCOUNT AND GCC2.CODE_COMBINATION_ID (+) = POP.PAYBACK_MOH_VAR_ACCOUNT AND GCC3.CODE_COMBINATION_ID (+) = POP.PAYBACK_RES_VAR_ACCOUNT AND GCC4.CODE_COMBINATION_ID (+) = POP.PAYBACK_OSP_VAR_ACCOUNT AND GCC5.CODE_COMBINATION_ID (+) = POP.PAYBACK_OVH_VAR_ACCOUNT WITH READ ONLY

View Text - HTML Formatted

SELECT POP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, '_DF:PJM:PJM_ORG_PARAMETERS:POP'
, POP.PROJECT_CONTROL_LEVEL
, '_LA:POP.ALLOW_CROSS_PROJ_ISSUES:FND_COMMON_LOOKUPS:YES_NO:MEANING'
, POP.COMMON_PROJECT_ID
, PROJ.SEGMENT1
, PROJ.NAME
, '_LA:POP.TRANSFER_IPV:FND_COMMON_LOOKUPS:YES_NO:MEANING'
, POP.IPV_EXPENDITURE_TYPE
, '_LA:POP.TRANSFER_ERV:FND_COMMON_LOOKUPS:YES_NO:MEANING'
, POP.ERV_EXPENDITURE_TYPE
, '_LA:POP.TRANSFER_FREIGHT:FND_COMMON_LOOKUPS:YES_NO:MEANING'
, POP.FREIGHT_EXPENDITURE_TYPE
, '_LA:POP.TRANSFER_TAX:FND_COMMON_LOOKUPS:YES_NO:MEANING'
, POP.TAX_EXPENDITURE_TYPE
, '_LA:POP.TRANSFER_MISC:FND_COMMON_LOOKUPS:YES_NO:MEANING'
, POP.MISC_EXPENDITURE_TYPE
, POP.PAYBACK_MAT_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC1'
, POP.PAYBACK_MOH_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC2'
, POP.PAYBACK_RES_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC3'
, POP.PAYBACK_OSP_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC4'
, POP.PAYBACK_OVH_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC5'
, POP.CREATION_DATE
, POP.CREATED_BY
, POP.LAST_UPDATE_DATE
, POP.LAST_UPDATED_BY
FROM PJM_ORG_PARAMETERS POP
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_PROJECTS_ALL PROJ
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, GL_CODE_COMBINATIONS GCC3
, GL_CODE_COMBINATIONS GCC4
, GL_CODE_COMBINATIONS GCC5
WHERE MP.ORGANIZATION_ID = POP.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = POP.ORGANIZATION_ID
AND PROJ.PROJECT_ID (+) = POP.COMMON_PROJECT_ID
AND GCC1.CODE_COMBINATION_ID (+) = POP.PAYBACK_MAT_VAR_ACCOUNT
AND GCC2.CODE_COMBINATION_ID (+) = POP.PAYBACK_MOH_VAR_ACCOUNT
AND GCC3.CODE_COMBINATION_ID (+) = POP.PAYBACK_RES_VAR_ACCOUNT
AND GCC4.CODE_COMBINATION_ID (+) = POP.PAYBACK_OSP_VAR_ACCOUNT
AND GCC5.CODE_COMBINATION_ID (+) = POP.PAYBACK_OVH_VAR_ACCOUNT WITH READ ONLY