CMR_XCC_PPM_TO_EXP_BURDEN_V
Details
-
Schema: FUSION
-
Object owner: CMR
-
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 TRANSACTION_TYPE_CODE RECEIPT_NUMBER PJC_PROJECT_ID PJC_TASK_ID PJC_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID AS PJC_BILLABLE_FLAG AS PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID AS 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_CONTEXT_CATEGORY 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 FUND_RESERVATION_STATUS LIQUIDATION_AMOUNT LIQUIDATION_BASE_AMOUNT CMR_TRANSACTION_ID |
Query
SQL_Statement |
---|
SELECT TO_CHAR(cre.ACCOUNTING_EVENT_ID) SOURCE_HEADER_ID_1, ' ' SOURCE_HEADER_ID_2, TO_CHAR(crec.EVENT_COST_ID) SOURCE_LINE_ID_1, ' ' SOURCE_LINE_ID_2, ' ' SOURCE_LINE_ID_3, ' ' SOURCE_LINE_ID_4, ' ' SOURCE_LINE_ID_5, ' ' SOURCE_LINE_ID_6, cttb.xcc_transaction_type TRANSACTION_TYPE_CODE, cre.sla_transaction_number RECEIPT_NUMBER, CTOD.PJC_PROJECT_ID, CTOD.PJC_TASK_ID, TO_NUMBER(NULL) PJC_RESOURCE_ID, CTOD.PJC_CONTRACT_ID, CTOD.PJC_CONTRACT_LINE_ID, CTOD.PJC_FUNDING_ALLOCATION_ID, NVL(CTOD.PJC_BILLABLE_FLAG, 'N') AS PJC_BILLABLE_FLAG, NVL(CTOD.PJC_CAPITALIZABLE_FLAG, 'N') AS PJC_CAPITALIZABLE_FLAG, CTOD.PJC_EXPENDITURE_TYPE_ID, NVL(cre.PJC_EXPENDITURE_ITEM_DATE,ctod.PJC_EXPENDITURE_ITEM_DATE) AS PJC_EXPENDITURE_ITEM_DATE, CTOD.PJC_ORGANIZATION_ID, CTOD.PJC_WORK_TYPE_ID, CTOD.PJC_RESERVED_ATTRIBUTE1, CTOD.PJC_RESERVED_ATTRIBUTE2, CTOD.PJC_RESERVED_ATTRIBUTE3, CTOD.PJC_RESERVED_ATTRIBUTE4, CTOD.PJC_RESERVED_ATTRIBUTE5, CTOD.PJC_RESERVED_ATTRIBUTE6, CTOD.PJC_RESERVED_ATTRIBUTE7, CTOD.PJC_RESERVED_ATTRIBUTE8, CTOD.PJC_RESERVED_ATTRIBUTE9, CTOD.PJC_RESERVED_ATTRIBUTE10, CTOD.PJC_CONTEXT_CATEGORY, CTOD.PJC_USER_DEF_ATTRIBUTE1, CTOD.PJC_USER_DEF_ATTRIBUTE2, CTOD.PJC_USER_DEF_ATTRIBUTE3, CTOD.PJC_USER_DEF_ATTRIBUTE4, CTOD.PJC_USER_DEF_ATTRIBUTE5, CTOD.PJC_USER_DEF_ATTRIBUTE6, CTOD.PJC_USER_DEF_ATTRIBUTE7, CTOD.PJC_USER_DEF_ATTRIBUTE8, CTOD.PJC_USER_DEF_ATTRIBUTE9, CTOD.PJC_USER_DEF_ATTRIBUTE10, cre.FUND_RESERVATION_STATUS, cre.ENCUMBRANCE_REVERSAL_ACCT_AMT LIQUIDATION_AMOUNT, cre.ENCUMBRANCE_REVERSAL_ENTR_AMT LIQUIDATION_BASE_AMOUNT, cre.TRANSACTION_ID CMR_TRANSACTION_ID /* Covers logical and physical txns - CMR_TRANSACTIONS */ FROM cmr_rcv_events cre, cst_transfer_order_dists ctod, cmr_rcv_event_costs crec, cmr_transaction_types_b cttb WHERE cre.ACCOUNTING_EVENT_ID = crec.ACCOUNTING_EVENT_ID AND cre.transfer_order_dist_id = ctod.distribution_id AND TO_CHAR(cre.transfer_order_line_id) = ctod.external_system_ref_id and ctod.external_system_reference = 'FUSION' AND cre.event_class_code IN ('TRO_RECEIPTS') AND cttb.transaction_type_code = cre.transaction_type_code AND cttb.xcc_transaction_type IS NOT NULL AND cre.BUDGETARY_CONTROL_FLAG = 'Y' |