DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on OE_ORDER_LINES_ALL

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

504: lr_trx_repo_extract := null;
505:
506: if r_docs.transaction_source = 'ORDER MANAGEMENT' then
507:
508: -- Only line_id it self is primary key for oe_order_lines_all so only line_id will do the job
509: jai_trx_repo_extract_pkg.get_document_details
510: ( p_document_id => ''
511: , p_document_line_id => r_docs.document_line_id
512: , p_document_source => r_docs.transaction_source

Line 824: ,oe_order_lines_all oel

820: , oel.ship_from_org_id organization_id
821: , oel.line_category_code line_category_code
822: from
823: oe_order_headers_all oeh
824: ,oe_order_lines_all oel
825: ,hz_parties hzp
826: ,hz_cust_accounts hzca
827: ,mtl_system_items msi
828: where (p_document_id is null or p_document_id = '' or oeh.header_id = p_document_id)