203: moh.request_number mo_number
204: FROM
205: ic_txn_request_headers moh,
206: ic_txn_request_lines mol,
207: oe_order_lines_all oel,
208: oe_order_headers_all oeh
209: WHERE oeh.header_id = oel.header_id
210: AND oeh.order_number LIKE (p_so_no)
211: AND oel.line_id = mol.txn_source_line_id
232: -- WHERE organization_id = p_org_id
233: -- AND line_status in (3,7)
234: -- ) mol,
235: -- ic_txn_request_headers moh,
236: -- oe_order_lines_all oel,
237: -- oe_order_headers_all oeh
238: -- WHERE oeh.header_id = oel.header_id
239: -- AND oeh.order_number LIKE (p_so_no)
240: -- AND oel.line_id = mol.txn_source_line_id