POR_REQ_XLA_PROJ_SOURCES_REF_V

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name

DISTRIBUTION_ID EXPENDITURE_BU_ID EXPENDITURE_BU_NAME PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ITEM_DATE EXPENDITURE_ORGANIZATION_ID WORK_TYPE_ID WORK_TYPE_NAME BILLABLE_FLAG CAPITALIZABLE_FLAG CONTRACT_ID CONTRACT_LINE_ID FUNDING_ALLOCATION_ID FUNDING_SOURCE_ID FUNDING_SOURCE_NAME CONTEXT_CATEGORY USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE10

Query

SQL_Statement

SELECT DISTRIBUTION_ID, REQ_BU_ID EXPENDITURE_BU_ID, REQ_BU_ID EXPENDITURE_BU_NAME, PJC_PROJECT_ID PROJECT_ID, PJC_TASK_ID TASK_ID, PJC_EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, PJC_EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, PJC_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PJC_WORK_TYPE_ID WORK_TYPE_ID, PJC_WORK_TYPE_ID WORK_TYPE_NAME, PJC_BILLABLE_FLAG BILLABLE_FLAG, PJC_CAPITALIZABLE_FLAG CAPITALIZABLE_FLAG, PJC_CONTRACT_ID CONTRACT_ID, PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID, PJC_FUNDING_ALLOCATION_ID FUNDING_ALLOCATION_ID, to_number(PJC_RESERVED_ATTRIBUTE1) FUNDING_SOURCE_ID, PJC_RESERVED_ATTRIBUTE1 FUNDING_SOURCE_NAME, PJC_CONTEXT_CATEGORY CONTEXT_CATEGORY, PJC_USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE1, PJC_USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE2, PJC_USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE3, PJC_USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE4, PJC_USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE5, PJC_USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE6, PJC_USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE7, PJC_USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE8, PJC_USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE9, PJC_USER_DEF_ATTRIBUTE10 USER_DEF_ATTRIBUTE10 FROM POR_REQ_DISTRIBUTIONS_ALL