VIEW: APPS.PJM_ORG_PARAMETERS_V

Source

View Text - Preformatted

SELECT POP.ROWID , POP.ORGANIZATION_ID , POP.CREATION_DATE , POP.CREATED_BY , POP.LAST_UPDATE_DATE , POP.LAST_UPDATED_BY , POP.LAST_UPDATE_LOGIN , POP.PROJECT_REFERENCE_ENABLED , POP.PROJECT_CONTROL_LEVEL , POP.COMMON_PROJECT_ID , P.SEGMENT1 , POP.ALLOW_CROSS_PROJ_ISSUES , POP.ALLOW_CROSS_UNITNUM_ISSUES , POP.PA_POSTING_FLAG , POP.PA_AUTOACCOUNTING_FLAG , POP.WIP_AS_STRAIGHT_TIME_FLAG , POP.PJM_CLEARING_ACCOUNT , POP.TRANSFER_IPV , POP.IPV_EXPENDITURE_TYPE , POP.TRANSFER_ERV , POP.ERV_EXPENDITURE_TYPE , POP.TRANSFER_FREIGHT , POP.FREIGHT_EXPENDITURE_TYPE , POP.TRANSFER_TAX , POP.TAX_EXPENDITURE_TYPE , POP.TRANSFER_MISC , POP.MISC_EXPENDITURE_TYPE , POP.PPV_EXPENDITURE_TYPE , POP.DIR_ITEM_EXPENDITURE_TYPE , POP.MAT_VAR_EXPENDITURE_TYPE , POP.MOH_VAR_EXPENDITURE_TYPE , POP.RES_VAR_EXPENDITURE_TYPE , POP.OSP_VAR_EXPENDITURE_TYPE , POP.OVH_VAR_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.ATTRIBUTE_CATEGORY , POP.ATTRIBUTE1 , POP.ATTRIBUTE2 , POP.ATTRIBUTE3 , POP.ATTRIBUTE4 , POP.ATTRIBUTE5 , POP.ATTRIBUTE6 , POP.ATTRIBUTE7 , POP.ATTRIBUTE8 , POP.ATTRIBUTE9 , POP.ATTRIBUTE10 , POP.ATTRIBUTE11 , POP.ATTRIBUTE12 , POP.ATTRIBUTE13 , POP.ATTRIBUTE14 , POP.ATTRIBUTE15 FROM PJM_ORG_PARAMETERS POP , PA_PROJECTS_ALL P WHERE P.PROJECT_ID (+) = POP.COMMON_PROJECT_ID

View Text - HTML Formatted

SELECT POP.ROWID
, POP.ORGANIZATION_ID
, POP.CREATION_DATE
, POP.CREATED_BY
, POP.LAST_UPDATE_DATE
, POP.LAST_UPDATED_BY
, POP.LAST_UPDATE_LOGIN
, POP.PROJECT_REFERENCE_ENABLED
, POP.PROJECT_CONTROL_LEVEL
, POP.COMMON_PROJECT_ID
, P.SEGMENT1
, POP.ALLOW_CROSS_PROJ_ISSUES
, POP.ALLOW_CROSS_UNITNUM_ISSUES
, POP.PA_POSTING_FLAG
, POP.PA_AUTOACCOUNTING_FLAG
, POP.WIP_AS_STRAIGHT_TIME_FLAG
, POP.PJM_CLEARING_ACCOUNT
, POP.TRANSFER_IPV
, POP.IPV_EXPENDITURE_TYPE
, POP.TRANSFER_ERV
, POP.ERV_EXPENDITURE_TYPE
, POP.TRANSFER_FREIGHT
, POP.FREIGHT_EXPENDITURE_TYPE
, POP.TRANSFER_TAX
, POP.TAX_EXPENDITURE_TYPE
, POP.TRANSFER_MISC
, POP.MISC_EXPENDITURE_TYPE
, POP.PPV_EXPENDITURE_TYPE
, POP.DIR_ITEM_EXPENDITURE_TYPE
, POP.MAT_VAR_EXPENDITURE_TYPE
, POP.MOH_VAR_EXPENDITURE_TYPE
, POP.RES_VAR_EXPENDITURE_TYPE
, POP.OSP_VAR_EXPENDITURE_TYPE
, POP.OVH_VAR_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.ATTRIBUTE_CATEGORY
, POP.ATTRIBUTE1
, POP.ATTRIBUTE2
, POP.ATTRIBUTE3
, POP.ATTRIBUTE4
, POP.ATTRIBUTE5
, POP.ATTRIBUTE6
, POP.ATTRIBUTE7
, POP.ATTRIBUTE8
, POP.ATTRIBUTE9
, POP.ATTRIBUTE10
, POP.ATTRIBUTE11
, POP.ATTRIBUTE12
, POP.ATTRIBUTE13
, POP.ATTRIBUTE14
, POP.ATTRIBUTE15
FROM PJM_ORG_PARAMETERS POP
, PA_PROJECTS_ALL P
WHERE P.PROJECT_ID (+) = POP.COMMON_PROJECT_ID