VIEW: APPS.PJMBV_PROJECT_MFG_ORGS

Source

View Text - Preformatted

SELECT POP.ORGANIZATION_ID , '_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 , '_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 , POP.PAYBACK_MOH_VAR_ACCOUNT , POP.PAYBACK_RES_VAR_ACCOUNT , POP.PAYBACK_OSP_VAR_ACCOUNT , POP.PAYBACK_OVH_VAR_ACCOUNT , POP.CREATION_DATE , POP.CREATED_BY , POP.LAST_UPDATE_DATE , POP.LAST_UPDATED_BY FROM PJM_ORG_PARAMETERS POP WITH READ ONLY

View Text - HTML Formatted

SELECT POP.ORGANIZATION_ID
, '_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
, '_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
, POP.PAYBACK_MOH_VAR_ACCOUNT
, POP.PAYBACK_RES_VAR_ACCOUNT
, POP.PAYBACK_OSP_VAR_ACCOUNT
, POP.PAYBACK_OVH_VAR_ACCOUNT
, POP.CREATION_DATE
, POP.CREATED_BY
, POP.LAST_UPDATE_DATE
, POP.LAST_UPDATED_BY
FROM PJM_ORG_PARAMETERS POP WITH READ ONLY