CJM_XLA_CR_TRX_V

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
DOCUMENT_HEADER_ID CUST_SPA_TRX_BILL_TO_CUST_ID DOCUMENT_LINE_ID CUST_SPA_TRX_SHIP_TO_CUST_ID

Query

SQL_Statement
SELECT cdh.document_header_id document_header_id, cdh.bill_to_customer_id cust_spa_trx_bill_to_cust_id, cdl.document_line_id document_line_id, cdl.ship_to_customer_id cust_spa_trx_ship_to_cust_id FROM cjm_document_headers_all cdh, cjm_document_lines_all cdl WHERE cdh.document_header_id = cdl.document_header_id