1. Tables and Views for SCM
  2. CMR_XCC_PPM_TO_EXP_BURDEN_V

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'