CMR_XLA_AP_INVOICE_DTLS_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
CMR_AP_INVOICE_DIST_ID INVOICE_NUMBER BUSINESS_UNIT_ID INVOICE_LINE_NUMBER INVOICE_TYPE UNIT_OF_MEASURE DISTRIBUTION_MATCH_TYPE INVOICE_DISTRIBUTION_TYPE CMR_PO_DISTRIBUTION_ID CMR_RCV_TRANSACTION_ID FINAL_MATCH_FLAG INVOICE_SOURCE REVERSAL_FLAG

Query

SQL_Statement

SELECT cmr_ap_invoice_dist_id cmr_ap_invoice_dist_id , invoice_number invoice_number , invoicing_business_unit_id business_unit_id , invoice_line_number invoice_line_number , invoice_type invoice_type , unit_of_measure unit_of_measure , distribution_match_type distribution_match_type , invoice_distribution_type invoice_distribution_type , cmr_po_distribution_id cmr_po_distribution_id , cmr_rcv_transaction_id cmr_rcv_transaction_id , final_match_flag final_match_flag , invoice_source invoice_source , reversal_flag reversal_flag FROM cmr_ap_invoice_dtls