eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PJMBV_PROJECT_MFG_ORGS

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

View Text

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

Columns

Name
ORGANIZATION_ID
"_DF"
PROJECT_CONTROL_LEVEL
"_LA:ALLOW_CROSS_PROJ_ISSUES"
COMMON_PROJECT_ID
"_LA:TRANSFER_IPV"
IPV_EXPENDITURE_TYPE
"_LA:TRANSFER_ERV"
ERV_EXPENDITURE_TYPE
"_LA:TRANSFER_FREIGHT"
FREIGHT_EXPENDITURE_TYPE
"_LA:TRANSFER_TAX"
TAX_EXPENDITURE_TYPE
"_LA:TRANSFER_MISC"
MISC_EXPENDITURE_TYPE
PAYBACK_MAT_VAR_ACCOUNT
PAYBACK_MOH_VAR_ACCOUNT
PAYBACK_RES_VAR_ACCOUNT
PAYBACK_OSP_VAR_ACCOUNT
PAYBACK_OVH_VAR_ACCOUNT
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY