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 |