VIEW: APPS.CST_XLA_PJM_ORG_PARAMS_REF_V

Source

View Text - Preformatted

SELECT Organization_id PJM_ORGANIZATION_ID, NVL(allow_cross_proj_issues ,'N') ALLOW_CROSS_PROJECT_ISSUES, NVL(pa_posting_flag,'N') PA_POSTING_FLAG, NVL(pa_autoaccounting_flag,'N') PA_AUTO_ACCOUNTING_FLAG, NVL(WIP_AS_STRAIGHT_TIME_FLAG,'N') WIP_AS_STRAIGHT_TIME_FLAG, ATTRIBUTE_CATEGORY ORG_PJM_ATTRIBUTE_CATEGORY, ATTRIBUTE1 ORG_PJM_ATTRIBUTE1, ATTRIBUTE2 ORG_PJM_ATTRIBUTE2, ATTRIBUTE3 ORG_PJM_ATTRIBUTE3, ATTRIBUTE4 ORG_PJM_ATTRIBUTE4, ATTRIBUTE5 ORG_PJM_ATTRIBUTE5, ATTRIBUTE6 ORG_PJM_ATTRIBUTE6, ATTRIBUTE7 ORG_PJM_ATTRIBUTE7, ATTRIBUTE8 ORG_PJM_ATTRIBUTE8, ATTRIBUTE9 ORG_PJM_ATTRIBUTE9, ATTRIBUTE10 ORG_PJM_ATTRIBUTE10, ATTRIBUTE11 ORG_PJM_ATTRIBUTE11, ATTRIBUTE12 ORG_PJM_ATTRIBUTE12, ATTRIBUTE13 ORG_PJM_ATTRIBUTE13, ATTRIBUTE14 ORG_PJM_ATTRIBUTE14, ATTRIBUTE15 ORG_PJM_ATTRIBUTE15 FROM PJM_ORG_PARAMETERS

View Text - HTML Formatted

SELECT ORGANIZATION_ID PJM_ORGANIZATION_ID
, NVL(ALLOW_CROSS_PROJ_ISSUES
, 'N') ALLOW_CROSS_PROJECT_ISSUES
, NVL(PA_POSTING_FLAG
, 'N') PA_POSTING_FLAG
, NVL(PA_AUTOACCOUNTING_FLAG
, 'N') PA_AUTO_ACCOUNTING_FLAG
, NVL(WIP_AS_STRAIGHT_TIME_FLAG
, 'N') WIP_AS_STRAIGHT_TIME_FLAG
, ATTRIBUTE_CATEGORY ORG_PJM_ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ORG_PJM_ATTRIBUTE1
, ATTRIBUTE2 ORG_PJM_ATTRIBUTE2
, ATTRIBUTE3 ORG_PJM_ATTRIBUTE3
, ATTRIBUTE4 ORG_PJM_ATTRIBUTE4
, ATTRIBUTE5 ORG_PJM_ATTRIBUTE5
, ATTRIBUTE6 ORG_PJM_ATTRIBUTE6
, ATTRIBUTE7 ORG_PJM_ATTRIBUTE7
, ATTRIBUTE8 ORG_PJM_ATTRIBUTE8
, ATTRIBUTE9 ORG_PJM_ATTRIBUTE9
, ATTRIBUTE10 ORG_PJM_ATTRIBUTE10
, ATTRIBUTE11 ORG_PJM_ATTRIBUTE11
, ATTRIBUTE12 ORG_PJM_ATTRIBUTE12
, ATTRIBUTE13 ORG_PJM_ATTRIBUTE13
, ATTRIBUTE14 ORG_PJM_ATTRIBUTE14
, ATTRIBUTE15 ORG_PJM_ATTRIBUTE15
FROM PJM_ORG_PARAMETERS