CJM_XLA_DOCUMENT_DTLS_V

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
DOCUMENT_HEADER_ID DOCUMENT_LINE_ID ITEM_WAREHOUSE_ID CUST_DOCUMENT_TYPE_CODE CUST_DOCUMENT_ID CUST_DOCUMENT_NUMBER CUST_DOCUMENT_DATE CUST_DOCUMENT_LINE_ID CUST_DOCUMENT_LINE_NUMBER CUST_DOC_DOO_LINE_ID CUST_DOC_FULFIL_LINE_ID CUST_DOC_SALES_INV_ID CUST_DOC_SALES_INV_NUM CUST_DOC_SALES_INV_LN_ID CUST_DOC_SALES_INV_LNUM

Query

SQL_Statement

SELECT cdl.document_header_id document_header_id, cdl.document_line_id document_line_id, cdl.warehouse_id item_warehouse_id, cdh.document_type_code cust_document_type_code, cdh.document_id cust_document_id, cdh.document_number cust_document_number, cdh.document_date cust_document_date, cdl.document_line_id cust_document_line_id, cdl.document_line_number cust_document_line_number, cdl.doo_line_id cust_doc_doo_line_id, cdl.doo_fulfill_line_id cust_doc_fulfil_line_id, cdl.sales_invoice_id cust_doc_sales_inv_id, cdl.sales_invoice_number cust_doc_sales_inv_num, cdl.sales_invoice_line_id cust_doc_sales_inv_ln_id, cdl.sales_invoice_line_number cust_doc_sales_inv_lnum FROM cjm_document_lines_all cdl, cjm_document_headers_all cdh WHERE cdl.document_header_id = cdh.document_header_id