PO_XLA_PROJECT_SOURCES_REF_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name

PO_DISTRIBUTION_ID LINE_LOCATION_ID PO_LINE_ID PO_HEADER_ID PROJECT_ID TASK_ID EXPENDITURE_BU_ID EXPENDITURE_BU_NAME EXPENDITURE_ITEM_DATE EXPENDITURE_ORGANIZATION_ID EXPENDITURE_TYPE_ID CONTEXT_CATEGORY BILLABLE_FLAG 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 CONTRACT_ID WORK_TYPE_ID WORK_TYPE_NAME CAPITALIZABLE_FLAG FUNDING_SOURCE_ID FUNDING_SOURCE_NAME FUNDING_ALLOCATION_ID CONTRACT_LINE_ID

Query

SQL_Statement

SELECT PO_DISTRIBUTION_ID , LINE_LOCATION_ID , PO_LINE_ID , PO_HEADER_ID , PJC_PROJECT_ID PROJECT_ID , PJC_TASK_ID TASK_ID , PRC_BU_ID EXPENDITURE_BU_ID , PRC_BU_ID EXPENDITURE_BU_NAME , PJC_EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , PJC_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID , PJC_EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID , PJC_CONTEXT_CATEGORY CONTEXT_CATEGORY , PJC_BILLABLE_FLAG BILLABLE_FLAG , 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 , PJC_CONTRACT_ID CONTRACT_ID , PJC_WORK_TYPE_ID WORK_TYPE_ID , PJC_WORK_TYPE_ID WORK_TYPE_NAME , PJC_CAPITALIZABLE_FLAG CAPITALIZABLE_FLAG , to_number(PJC_RESERVED_ATTRIBUTE1) FUNDING_SOURCE_ID , PJC_RESERVED_ATTRIBUTE1 FUNDING_SOURCE_NAME , PJC_FUNDING_ALLOCATION_ID FUNDING_ALLOCATION_ID , PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID FROM PO_DISTRIBUTIONS_ALL