CMR_XLA_TRANSACTIONS_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name

TRANSACTION_ID CMR_PO_DISTRIBUTION_ID CMR_RCV_TRANSACTION_ID TRANSACTION_TYPE RECEIPT_NUMBER FIRST_PTY_REG_ID THIRD_PTY_REG_ID SHIP_FROM_LOCATION_ID PRODUCT_FISC_CLASS_ID FINAL_DISCHARGE_LOCATION_ID DEFAULT_TAXATION_COUNTRY DOCUMENT_FISCAL_CLASSIFICATION TRX_BUSINESS_CATEGORY TAX_INVOICE_NUMBER TAX_INVOICE_DATE USER_DEFINED_FISC_CLASS TAX_CLASSIFICATION_CODE PRODUCT_TYPE PRODUCT_CATEGORY ASSESSABLE_VALUE INTENDED_USE COUNTRY_OF_ORIGIN_CODE

Query

SQL_Statement

SELECT TRANSACTION_ID ,cmr_po_distribution_id , cmr_rcv_transaction_id , transaction_type , receipt_number ,FIRST_PTY_REG_ID ,THIRD_PTY_REG_ID ,SHIP_FROM_LOCATION_ID ,PRODUCT_FISC_CLASS_ID ,FINAL_DISCHARGE_LOCATION_ID ,DEFAULT_TAXATION_COUNTRY ,DOCUMENT_FISCAL_CLASSIFICATION ,TRX_BUSINESS_CATEGORY ,TAX_INVOICE_NUMBER ,TAX_INVOICE_DATE ,USER_DEFINED_FISC_CLASS ,TAX_CLASSIFICATION_CODE ,PRODUCT_TYPE ,PRODUCT_CATEGORY ,ASSESSABLE_VALUE ,INTENDED_USE ,COUNTRY_OF_ORIGIN_CODE FROM cmr_transactions