View: PJMFV_PROJECT_MFG_ORGS

Product:	PJM - Project Manufacturing
Description:	Project Manufacturing Organization Setups
Implementation/DBA Data:	APPS.PJMFV_PROJECT_MFG_ORGS

View Text

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

Columns