CMR_XLA_INV_DISTRIBUTIONS_V

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 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 ENTERED_CURRENCY_CODE EXCHANGE_RATE_TYPE EXCHANGE_RATE EXCHANGE_DATE BUDGETARY_CONTROL_FLAG ENCUMBRANCE_ACCOUNTING_FLAG FUND_RESERVATION_STATUS BUDGETARY_CONTROL_DATA_SET_ID TRANSACTION_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 , DELIVER_TO_BUSINESS_UNIT_ID DELIVER_TO_BUSINESS_UNIT_ID , INVENTORY_ORG_ID INV_ORG_ID , DELIVER_TO_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, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE EXCHANGE_RATE , EXCHANGE_DATE EXCHANGE_DATE, 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, TRANSACTION_ID TRANSACTION_ID FROM CMR_RCV_EVENTS