DBA Data[Home] [Help]

APPS.GML_MOBILE_MOVE_ORDER dependencies on OE_ORDER_HEADERS_ALL

Line 208: oe_order_headers_all oeh

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
212: AND moh.header_id = mol.header_id

Line 237: -- oe_order_headers_all oeh

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
241: -- AND oel.flow_status_code NOT IN ('CLOSED','CANCELLED')