PO_XCC_PJC_BURDEN_DIST_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name

SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 PJC_PROJECT_ID PJC_TASK_ID PJC_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10 PJC_CONTEXT_CATEGORY FUNDS_STATUS ORIGINAL_DISTRIBUTION_ID LIQUIDATION_AMOUNT LIQUIDATION_BASE_AMOUNT LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_2 RESERVATION_BACKOUT_FLAG PJC_BURDEN_ACTION_CODE

Query

SQL_Statement

SELECT to_char(bc.PO_HEADER_ID) SOURCE_HEADER_ID_1, to_char(bc.PO_VERSION_ID) SOURCE_HEADER_ID_2, to_char(bc.PO_LINE_ID) SOURCE_LINE_ID_1, to_char(bc.PO_LINE_LOCATION_ID) SOURCE_LINE_ID_2, to_char(bc.PO_DISTRIBUTION_ID) SOURCE_LINE_ID_3, to_char(decode(bc.BC_EVENT, 'FINALLY_CLOSE_PO', bc.DATA_SET_ID, 'CF_FINALLY_CLOSE_PO', bc.DATA_SET_ID, 'REOPEN_PO',bc.DATA_SET_ID,'CF_REOPEN_PO',bc.DATA_SET_ID,bc.PO_VERSION_ID) ) SOURCE_LINE_ID_4, to_char(decode(bc.RESERVATION_BACKOUT_FLAG,'N',' ',bc.RESERVATION_BACKOUT_FLAG)) SOURCE_LINE_ID_5, ' ' SOURCE_LINE_ID_6, PD.PJC_PROJECT_ID, PD.PJC_TASK_ID, TO_NUMBER(NULL) PJC_RESOURCE_ID, PD.PJC_CONTRACT_ID, PD.PJC_CONTRACT_LINE_ID, PD.PJC_FUNDING_ALLOCATION_ID, NVL(PD.PJC_BILLABLE_FLAG, 'N') as PJC_BILLABLE_FLAG, NVL(PD.PJC_CAPITALIZABLE_FLAG, 'N') as PJC_CAPITALIZABLE_FLAG, PD.PJC_EXPENDITURE_TYPE_ID, PD.PJC_EXPENDITURE_ITEM_DATE, PD.PJC_ORGANIZATION_ID, PD.PJC_WORK_TYPE_ID, PD.PJC_RESERVED_ATTRIBUTE1, PD.PJC_RESERVED_ATTRIBUTE2, PD.PJC_RESERVED_ATTRIBUTE3, PD.PJC_RESERVED_ATTRIBUTE4, PD.PJC_RESERVED_ATTRIBUTE5, PD.PJC_RESERVED_ATTRIBUTE6, PD.PJC_RESERVED_ATTRIBUTE7, PD.PJC_RESERVED_ATTRIBUTE8, PD.PJC_RESERVED_ATTRIBUTE9, PD.PJC_RESERVED_ATTRIBUTE10, PD.PJC_USER_DEF_ATTRIBUTE1, PD.PJC_USER_DEF_ATTRIBUTE2, PD.PJC_USER_DEF_ATTRIBUTE3, PD.PJC_USER_DEF_ATTRIBUTE4, PD.PJC_USER_DEF_ATTRIBUTE5, PD.PJC_USER_DEF_ATTRIBUTE6, PD.PJC_USER_DEF_ATTRIBUTE7, PD.PJC_USER_DEF_ATTRIBUTE8, PD.PJC_USER_DEF_ATTRIBUTE9, PD.PJC_USER_DEF_ATTRIBUTE10, PD.PJC_CONTEXT_CATEGORY, PD.FUNDS_STATUS, PD.ORIGINAL_DISTRIBUTION_ID, nvl(prd.distribution_currency_amount,prd.distribution_amount) + nvl(prd.nonrecoverable_tax,0) LIQUIDATION_AMOUNT, prd.distribution_amount + nvl(prd.nonrecoverable_tax,0) LIQUIDATION_BASE_AMOUNT, PRD.REQUISITION_LINE_ID LIQUIDATION_LINE_ID_1, PRD.DISTRIBUTION_ID LIQUIDATION_LINE_ID_2, bc.RESERVATION_BACKOUT_FLAG, bc.PJC_BURDEN_ACTION_CODE FROM PO_DISTRIBUTIONS_DRAFT_ALL PD, POR_REQ_DISTRIBUTIONS_ALL PRD, PO_BCEA_DATA bc WHERE PD.REQ_DISTRIBUTION_ID = PRD.DISTRIBUTION_ID (+) AND PD.PJC_PROJECT_ID is not null AND PD.PO_DISTRIBUTION_ID = bc.PO_DISTRIBUTION_ID and bc.creation_date = (select max(bc1.creation_date) from po_bcea_data bc1 where bc1.po_distribution_id = pd.po_distribution_id)