DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on OE_ORDER_LINES_ALL

Line 1073: -- Only line_id it self is primary key for oe_order_lines_all so only line_id will do the job

1069:
1070: lr_trx_repo_extract := null;
1071: if r_docs.transaction_source = 'ORDER MANAGEMENT' then
1072:
1073: -- Only line_id it self is primary key for oe_order_lines_all so only line_id will do the job
1074: jai_trx_repo_extract_pkg.get_document_details
1075: ( p_document_id => ''
1076: , p_document_line_id => r_docs.document_line_id
1077: , p_document_source => r_docs.transaction_source

Line 1516: ,oe_order_lines_all oel

1512: , oel.ship_from_org_id organization_id
1513: , oel.line_category_code line_category_code
1514: from
1515: oe_order_headers_all oeh
1516: ,oe_order_lines_all oel
1517: ,hz_parties hzp
1518: ,hz_cust_accounts hzca
1519: ,mtl_system_items msi
1520: where (p_document_id is null or p_document_id = '' or oeh.header_id = p_document_id)