AP_XLA_PROJECT_SOURCES_REF_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name

PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ITEM_DATE EXPENDITURE_ORGANIZATION_ID WORK_TYPE_ID BILLABLE_FLAG CAPITALIZABLE_FLAG 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 INVOICE_DISTRIBUTION_ID EXPENDITURE_BU_ID EXPENDITURE_BU_NAME WORK_TYPE_NAME CONTRACT_ID CONTRACT_LINE_ID FUNDING_ALLOCATION_ID FUNDING_SOURCE_ID FUNDING_SOURCE_NAME FUNDING_SOURCE_NUMBER

Query

SQL_Statement

SELECT NVL(TD.PJC_PROJECT_ID, AID.PJC_PROJECT_ID) PROJECT_ID , NVL(TD.PJC_TASK_ID, AID.PJC_TASK_ID) TASK_ID , NVL(TD.PJC_EXPENDITURE_TYPE_ID, AID.PJC_EXPENDITURE_TYPE_ID) EXPENDITURE_TYPE_ID , AID.PJC_EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , NVL(TD.PJC_ORGANIZATION_ID, AID.PJC_ORGANIZATION_ID) AS EXPENDITURE_ORGANIZATION_ID ,AID.PJC_WORK_TYPE_ID WORK_TYPE_ID ,AID.PJC_BILLABLE_FLAG BILLABLE_FLAG ,AID.PJC_CAPITALIZABLE_FLAG CAPITALIZABLE_FLAG ,AID.PJC_CONTEXT_CATEGORY CONTEXT_CATEGORY ,AID.PJC_USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE1 ,AID.PJC_USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE2 ,AID.PJC_USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE3 ,AID.PJC_USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE4 ,AID.PJC_USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE5 ,AID.PJC_USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE6 ,AID.PJC_USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE7 ,AID.PJC_USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE8 ,AID.PJC_USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE9 ,AID.PJC_USER_DEF_ATTRIBUTE10 USER_DEF_ATTRIBUTE10 ,AID.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID ,AID.ORG_ID EXPENDITURE_BU_ID ,AID.ORG_ID EXPENDITURE_BU_NAME ,AID.PJC_WORK_TYPE_ID WORK_TYPE_NAME ,AID.PJC_CONTRACT_ID CONTRACT_ID ,AID.PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID ,AID.PJC_FUNDING_ALLOCATION_ID FUNDING_ALLOCATION_ID ,AID.PJC_RESERVED_ATTRIBUTE1 FUNDING_SOURCE_ID ,TO_NUMBER(AID.PJC_RESERVED_ATTRIBUTE1) FUNDING_SOURCE_NAME ,TO_NUMBER(AID.PJC_RESERVED_ATTRIBUTE1) FUNDING_SOURCE_NUMBER FROM AP_INVOICE_DISTRIBUTIONS_ALL AID, AP_INVOICE_DISTRIBUTIONS_ALL TD ,AP_INVOICE_DISTRIBUTIONS_ALL AWT_REL WHERE DECODE(AID.LINE_TYPE_LOOKUP_CODE, 'REC_TAX', AID.CHARGE_APPLICABLE_TO_DIST_ID, 'AWT', DECODE(AWT_REL.LINE_TYPE_LOOKUP_CODE, 'REC_TAX', AWT_REL.CHARGE_APPLICABLE_TO_DIST_ID, AWT_REL.INVOICE_DISTRIBUTION_ID), NULL) = TD.INVOICE_DISTRIBUTION_ID (+) AND DECODE(AID.LINE_TYPE_LOOKUP_CODE, 'AWT', AID.AWT_RELATED_ID, NULL) = AWT_REL.INVOICE_DISTRIBUTION_ID (+) UNION ALL SELECT NVL(TS.PJC_PROJECT_ID, AST.PJC_PROJECT_ID) PROJECT_ID , NVL(TS.PJC_TASK_ID, AST.PJC_TASK_ID) TASK_ID , NVL(TS.PJC_EXPENDITURE_TYPE_ID, AST.PJC_EXPENDITURE_TYPE_ID) EXPENDITURE_TYPE_ID , AST.PJC_EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , NVL(TS.PJC_ORGANIZATION_ID, AST.PJC_ORGANIZATION_ID) AS EXPENDITURE_ORGANIZATION_ID ,AST.PJC_WORK_TYPE_ID WORK_TYPE_ID ,AST.PJC_BILLABLE_FLAG BILLABLE_FLAG ,AST.PJC_CAPITALIZABLE_FLAG CAPITALIZABLE_FLAG ,AST.PJC_CONTEXT_CATEGORY CONTEXT_CATEGORY ,AST.PJC_USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE1 ,AST.PJC_USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE2 ,AST.PJC_USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE3 ,AST.PJC_USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE4 ,AST.PJC_USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE5 ,AST.PJC_USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE6 ,AST.PJC_USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE7 ,AST.PJC_USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE8 ,AST.PJC_USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE9 ,AST.PJC_USER_DEF_ATTRIBUTE10 USER_DEF_ATTRIBUTE10 ,AST.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID ,AST.ORG_ID EXPENDITURE_BU_ID ,AST.ORG_ID EXPENDITURE_BU_NAME ,AST.PJC_WORK_TYPE_ID WORK_TYPE_NAME ,AST.PJC_CONTRACT_ID CONTRACT_ID ,AST.PJC_CONTRACT_LINE_ID CONTRACT_LINE_ID ,AST.PJC_FUNDING_ALLOCATION_ID FUNDING_ALLOCATION_ID ,AST.PJC_RESERVED_ATTRIBUTE1 FUNDING_SOURCE_ID ,TO_NUMBER(AST.PJC_RESERVED_ATTRIBUTE1) FUNDING_SOURCE_NAME ,TO_NUMBER(AST.PJC_RESERVED_ATTRIBUTE1) FUNDING_SOURCE_NUMBER FROM AP_SELF_ASSESSED_TAX_DIST_ALL AST, AP_INVOICE_DISTRIBUTIONS_ALL TS WHERE DECODE(AST.LINE_TYPE_LOOKUP_CODE, 'REC_TAX', AST.CHARGE_APPLICABLE_TO_DIST_ID, null) = TS.INVOICE_DISTRIBUTION_ID(+)