APPS.GML_MOBILE_MOVE_ORDER dependencies on IC_TXN_REQUEST_LINES

Line 206: ic_txn_request_lines mol,

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
210: AND oeh.order_number LIKE (p_so_no)

Line 229: -- (SELECT /*+ INDEX(itr ic_txn_request_lines_n1) */

225: -- oeh.order_number,
226: -- oeh.header_id,
227: -- moh.request_number mo_number
228: -- FROM
229: -- (SELECT /*+ INDEX(itr ic_txn_request_lines_n1) */
230: -- DISTINCT header_id, txn_source_line_id
231: -- FROM ic_txn_request_lines itr
232: -- WHERE organization_id = p_org_id
233: -- AND line_status in (3,7)

Line 231: -- FROM ic_txn_request_lines itr

227: -- moh.request_number mo_number
228: -- FROM
229: -- (SELECT /*+ INDEX(itr ic_txn_request_lines_n1) */
230: -- DISTINCT header_id, txn_source_line_id
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,

Line 265: ic_txn_request_lines l

261:
262: SELECT DISTINCT opi.item_no, opi.item_desc1, opi.item_id, mti.inventory_item_id
263: FROM mtl_system_items mti,
264: ic_item_mst opi,
265: ic_txn_request_lines l
266: WHERE opi.item_no = mti.segment1
267: and opi.item_no LIKE (p_item_no)
268: and mti.organization_id = p_org_id
269: and mti.inventory_item_flag = 'Y'

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

Line 537: ic_txn_request_lines ml

533: BEGIN
534: OPEN x_delivery FOR
535: SELECT wnd.NAME, wnd.delivery_id
536: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments wda,
537: ic_txn_request_lines ml
538:
539: WHERE wda.delivery_id = wnd.delivery_id
540: AND wda.delivery_detail_id = wdd.delivery_detail_id
541: AND wdd.move_order_line_id = ml.line_id