CMR_XLA_DISTRIBUTIONS

Details

Schema: FUSION
Object owner: CMR
Object type: VIEW

Columns

Name
ACCOUNTING_EVENT_ID CMR_PO_DISTRIBUTION_ID EVENT_TYPE_CODE EVENT_CLASS_CODE ENTITY_CODE CMR_RCV_TRANSACTION_ID SOURCE_DOCUMENT_TYPE EVENT_SOURCE_ID LEDGER_ID LEGAL_ENTITY_ID BUSINESS_UNIT_ID DELIVER_TO_BUSINESS_UNIT_ID INV_ORG_ID ITEM_VALIDATION_ORG_ID DELIVER_TO_INV_ORG_ID INVENTORY_ITEM_ID TRANSACTION_DATE GL_DATE TRANSFER_PRICE PO_UNIT_PRICE TRANSACTION_AMT NONRECOVERABLE_TAX SOURCE_DOC_QTY TRANSACTION_QTY PRIMARY_QTY SOURCE_DOC_UOM_CODE TRANSACTION_UOM_CODE PRIMARY_UOM_CODE PROCESSING_GROUP_ID EVENT_ID ACCOUNTED_FLAG TRADE_EVENT_ID BILL_TO_BUSINESS_UNIT_ID ENCUMBRANCE_REVERSAL_ENTR_AMT ENCUMBRANCE_REVERSAL_ACCT_AMT BUDGETARY_CONTROL_FLAG ENCUMBRANCE_ACCOUNTING_FLAG FUND_RESERVATION_STATUS BUDGETARY_CONTROL_DATA_SET_ID FISCAL_DOCUMENT_DETAIL_ID TRANSACTION_ID TO_LINE_ID

Name

ACCOUNTING_EVENT_ID

CMR_PO_DISTRIBUTION_ID

EVENT_TYPE_CODE

EVENT_CLASS_CODE

ENTITY_CODE

CMR_RCV_TRANSACTION_ID

SOURCE_DOCUMENT_TYPE

EVENT_SOURCE_ID

LEDGER_ID

LEGAL_ENTITY_ID

BUSINESS_UNIT_ID

DELIVER_TO_BUSINESS_UNIT_ID

INV_ORG_ID

ITEM_VALIDATION_ORG_ID

DELIVER_TO_INV_ORG_ID

INVENTORY_ITEM_ID

TRANSACTION_DATE

GL_DATE

TRANSFER_PRICE

PO_UNIT_PRICE

TRANSACTION_AMT

NONRECOVERABLE_TAX

SOURCE_DOC_QTY

TRANSACTION_QTY

PRIMARY_QTY

SOURCE_DOC_UOM_CODE

TRANSACTION_UOM_CODE

PRIMARY_UOM_CODE

PROCESSING_GROUP_ID

EVENT_ID

ACCOUNTED_FLAG

TRADE_EVENT_ID

BILL_TO_BUSINESS_UNIT_ID

ENCUMBRANCE_REVERSAL_ENTR_AMT

ENCUMBRANCE_REVERSAL_ACCT_AMT

BUDGETARY_CONTROL_FLAG

ENCUMBRANCE_ACCOUNTING_FLAG

FUND_RESERVATION_STATUS

BUDGETARY_CONTROL_DATA_SET_ID

FISCAL_DOCUMENT_DETAIL_ID

TRANSACTION_ID

TO_LINE_ID

Query

SQL_Statement
SELECT ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID , CMR_PO_DISTRIBUTION_ID CMR_PO_DISTRIBUTION_ID , EVENT_TYPE_CODE EVENT_TYPE_CODE , EVENT_CLASS_CODE EVENT_CLASS_CODE , ENTITY_CODE ENTITY_CODE , CMR_RCV_TRANSACTION_ID CMR_RCV_TRANSACTION_ID , EVENT_SOURCE source_document_type , EVENT_SOURCE_ID EVENT_SOURCE_ID , LEDGER_ID LEDGER_ID , LEGAL_ENTITY_ID LEGAL_ENTITY_ID , BUSINESS_UNIT_ID BUSINESS_UNIT_ID , NVL(DELIVER_TO_BUSINESS_UNIT_ID,BUSINESS_UNIT_ID) DELIVER_TO_BUSINESS_UNIT_ID , INVENTORY_ORG_ID INV_ORG_ID , case when event_class_code in ( 'TRADE_ACCRUALS','CS_TRADE_ACCRUAL') and PROCUREMENT_ORG_FLAG <> 'X' then (select iop.master_organization_id from inv_org_parameters iop where iop.organization_id = cre.inventory_org_id) when event_class_code in ('INVOICE_PRICE_ADJUSTMENT','RETRO_PRICE_ADJUSTMENT') and PROCUREMENT_ORG_FLAG = 'Y' then (select iop.master_organization_id from inv_org_parameters iop where iop.organization_id = cre.inventory_org_id) else cre.inventory_org_id end Item_validation_Org_Id, NVL(DELIVER_TO_INVENTORY_ORG_ID, inventory_org_id) DELIVER_TO_INV_ORG_ID , INVENTORY_ITEM_ID INVENTORY_ITEM_ID , TRANSACTION_DATE TRANSACTION_DATE , GL_DATE GL_DATE , TRANSFER_PRICE TRANSFER_PRICE , PO_UNIT_PRICE PO_UNIT_PRICE , TRANSACTION_AMT TRANSACTION_AMT , NONRECOVERABLE_TAX NONRECOVERABLE_TAX , SOURCE_DOC_QTY SOURCE_DOC_QTY , TRANSACTION_QTY TRANSACTION_QTY , PRIMARY_QTY PRIMARY_QTY , SOURCE_DOC_UOM_CODE SOURCE_DOC_UOM_CODE , TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE , PRIMARY_UOM_CODE PRIMARY_UOM_CODE , PROCESSING_GROUP_ID PROCESSING_GROUP_ID , EVENT_ID EVENT_ID , ACCOUNTED_FLAG ACCOUNTED_FLAG, TRADE_EVENT_ID TRADE_EVENT_ID, BILL_TO_BUSINESS_UNIT_ID BILL_TO_BUSINESS_UNIT_ID, ENCUMBRANCE_REVERSAL_ENTR_AMT ENCUMBRANCE_REVERSAL_ENTR_AMT, ENCUMBRANCE_REVERSAL_ACCT_AMT ENCUMBRANCE_REVERSAL_ACCT_AMT, BUDGETARY_CONTROL_FLAG BUDGETARY_CONTROL_FLAG, ENCUMBRANCE_ACCOUNTING_FLAG ENCUMBRANCE_ACCOUNTING_FLAG, FUND_RESERVATION_STATUS FUND_RESERVATION_STATUS, XCC_DATA_SET_ID BUDGETARY_CONTROL_DATA_SET_ID, FISCAL_DOCUMENT_DETAIL_ID FISCAL_DOCUMENT_DETAIL_ID, TRANSACTION_ID TRANSACTION_ID, TRANSFER_ORDER_LINE_ID TO_LINE_ID FROM CMR_RCV_EVENTS CRE

SQL_Statement

SELECT ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID ,

CMR_PO_DISTRIBUTION_ID CMR_PO_DISTRIBUTION_ID ,

EVENT_TYPE_CODE EVENT_TYPE_CODE ,

EVENT_CLASS_CODE EVENT_CLASS_CODE ,

ENTITY_CODE ENTITY_CODE ,

CMR_RCV_TRANSACTION_ID CMR_RCV_TRANSACTION_ID ,

EVENT_SOURCE source_document_type ,

EVENT_SOURCE_ID EVENT_SOURCE_ID ,

LEDGER_ID LEDGER_ID ,

LEGAL_ENTITY_ID LEGAL_ENTITY_ID ,

BUSINESS_UNIT_ID BUSINESS_UNIT_ID ,

NVL(DELIVER_TO_BUSINESS_UNIT_ID,BUSINESS_UNIT_ID) DELIVER_TO_BUSINESS_UNIT_ID ,

INVENTORY_ORG_ID INV_ORG_ID ,

case when event_class_code in ( 'TRADE_ACCRUALS','CS_TRADE_ACCRUAL') and PROCUREMENT_ORG_FLAG <> 'X' then

(select iop.master_organization_id from inv_org_parameters iop where iop.organization_id = cre.inventory_org_id)

when event_class_code in ('INVOICE_PRICE_ADJUSTMENT','RETRO_PRICE_ADJUSTMENT') and PROCUREMENT_ORG_FLAG = 'Y' then

(select iop.master_organization_id from inv_org_parameters iop where iop.organization_id = cre.inventory_org_id)

else cre.inventory_org_id

end Item_validation_Org_Id,

NVL(DELIVER_TO_INVENTORY_ORG_ID, inventory_org_id) DELIVER_TO_INV_ORG_ID ,

INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,

TRANSACTION_DATE TRANSACTION_DATE ,

GL_DATE GL_DATE ,

TRANSFER_PRICE TRANSFER_PRICE ,

PO_UNIT_PRICE PO_UNIT_PRICE ,

TRANSACTION_AMT TRANSACTION_AMT ,

NONRECOVERABLE_TAX NONRECOVERABLE_TAX ,

SOURCE_DOC_QTY SOURCE_DOC_QTY ,

TRANSACTION_QTY TRANSACTION_QTY ,

PRIMARY_QTY PRIMARY_QTY ,

SOURCE_DOC_UOM_CODE SOURCE_DOC_UOM_CODE ,

TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE ,

PRIMARY_UOM_CODE PRIMARY_UOM_CODE ,

PROCESSING_GROUP_ID PROCESSING_GROUP_ID ,

EVENT_ID EVENT_ID ,

ACCOUNTED_FLAG ACCOUNTED_FLAG,

TRADE_EVENT_ID TRADE_EVENT_ID,

BILL_TO_BUSINESS_UNIT_ID BILL_TO_BUSINESS_UNIT_ID,

ENCUMBRANCE_REVERSAL_ENTR_AMT ENCUMBRANCE_REVERSAL_ENTR_AMT,

ENCUMBRANCE_REVERSAL_ACCT_AMT ENCUMBRANCE_REVERSAL_ACCT_AMT,

BUDGETARY_CONTROL_FLAG BUDGETARY_CONTROL_FLAG,

ENCUMBRANCE_ACCOUNTING_FLAG ENCUMBRANCE_ACCOUNTING_FLAG,

FUND_RESERVATION_STATUS FUND_RESERVATION_STATUS,

XCC_DATA_SET_ID BUDGETARY_CONTROL_DATA_SET_ID,

FISCAL_DOCUMENT_DETAIL_ID FISCAL_DOCUMENT_DETAIL_ID,

TRANSACTION_ID TRANSACTION_ID,

TRANSFER_ORDER_LINE_ID TO_LINE_ID

FROM CMR_RCV_EVENTS CRE