APPS.GML_MOBILE_MOVE_ORDER dependencies on IC_TXN_REQUEST_HEADERS

Line 205: ic_txn_request_headers moh,

201: oeh.order_number,
202: oeh.header_id,
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

Line 221: -- INDEX(moh ic_txn_request_headers_pk)

217:
218: -- OPEN x_so_mo_lov FOR
219: -- SELECT
220: -- /*+ ORDERED
221: -- INDEX(moh ic_txn_request_headers_pk)
222: -- INDEX(oel oe_order_lines_u1)
223: -- INDEX(oeh oe_order_headers_u1)
224: -- */
225: -- oeh.order_number,

Line 235: -- ic_txn_request_headers moh,

231: -- FROM ic_txn_request_lines itr
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)

Line 517: FROM ic_txn_request_headers h, ic_txn_request_lines l

513: , h.header_id
514: , MAX(h.move_order_type)
515: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
516: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
517: FROM ic_txn_request_headers h, ic_txn_request_lines l
518: WHERE h.organization_id = p_organization_id
519: AND h.request_number LIKE(p_mo_req_number)
520: AND h.header_status IN(3, 7)
521: AND l.organization_id = h.organization_id