eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MO_LOVS dependencies on MTL_TXN_REQUEST_LINES

Line 34: FROM mtl_txn_request_headers h, mtl_txn_request_lines l

30: , h.header_id
31: , MAX(h.move_order_type)
32: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
33: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
34: FROM mtl_txn_request_headers h, mtl_txn_request_lines l
35: WHERE h.organization_id = p_organization_id
36: AND h.request_number LIKE(p_mo_req_number)
37: AND h.header_status IN(3, 7, 8)
38: AND l.organization_id = h.organization_id

Line 93: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t

89: , h.header_id
90: , MAX(h.move_order_type)
91: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
92: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
93: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t
94: WHERE l.header_id = h.header_id
95: AND l.transaction_type_id = t.transaction_type_id
96: AND h.organization_id = p_organization_id
97: AND h.header_status IN(3, 7, 8)

Line 112: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t

108: , h.header_id
109: , MAX(h.move_order_type)
110: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
111: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
112: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t
113: WHERE l.header_id = h.header_id
114: AND l.transaction_type_id = t.transaction_type_id
115: AND h.organization_id = p_organization_id
116: AND h.header_status IN(3, 7, 8)

Line 131: FROM mtl_txn_request_headers h, mtl_txn_request_lines l

127: , h.header_id
128: , MAX(h.move_order_type)
129: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
130: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
131: FROM mtl_txn_request_headers h, mtl_txn_request_lines l
132: WHERE l.header_id = h.header_id
133: AND h.organization_id = p_organization_id
134: AND h.header_status IN(3, 7, 8)
135: AND h.move_order_type = p_mo_type

Line 162: FROM mtl_txn_request_headers h, mtl_txn_request_lines l

158: , h.header_id
159: , MAX(h.move_order_type)
160: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
161: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
162: FROM mtl_txn_request_headers h, mtl_txn_request_lines l
163: WHERE h.organization_id = p_organization_id
164: AND h.request_number LIKE (p_mo_req_number)
165: AND h.header_status IN(3, 7, 8)
166: AND move_order_type = 3

Line 188: FROM mtl_txn_request_headers h, mtl_txn_request_lines l

184: , h.header_id
185: , MAX(h.move_order_type)
186: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
187: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
188: FROM mtl_txn_request_headers h, mtl_txn_request_lines l
189: , mtl_sales_orders mso
190: WHERE mso.sales_order_id = l.txn_source_id
191: AND (p_so_number IS NULL OR mso.segment1 = p_so_number)
192: AND h.organization_id = p_organization_id

Line 228: FROM mtl_txn_request_headers h, mtl_txn_request_lines l

224: , h.header_id
225: , MAX(h.move_order_type)
226: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
227: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
228: FROM mtl_txn_request_headers h, mtl_txn_request_lines l
229: WHERE h.organization_id = p_organization_id
230: AND h.request_number LIKE(p_mo_req_number)
231: AND h.header_status IN(3, 7, 8)
232: AND move_order_type = 5

Line 272: FROM mtl_txn_request_lines_v mtrl

268: ) IS
269: BEGIN
270: OPEN x_mo_line_lov FOR
271: SELECT line_number, line_id, move_order_type
272: FROM mtl_txn_request_lines_v mtrl
273: WHERE organization_id = p_organization_id
274: AND line_status IN(3, 7, 8)
275: AND NVL(quantity_delivered, 0) < quantity
276: AND header_id = p_mo_header_id

Line 294: FROM mtl_txn_request_lines m, mtl_kanban_cards k

290: OPEN x_mo_kanban FOR
291: SELECT k.kanban_card_number
292: , m.reference_id
293: , m.line_id
294: FROM mtl_txn_request_lines m, mtl_kanban_cards k
295: WHERE m.reference_id = k.kanban_card_id
296: AND m.organization_id = p_organization_id
297: AND m.reference_type_code = 1
298: AND m.line_status IN(3, 7, 8)

Line 319: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda, mtl_txn_request_lines ml

315: BEGIN
316: --bug 4951734, rewriting query with better performance.
317: /*
318: SELECT wnd.NAME, wnd.delivery_id
319: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda, mtl_txn_request_lines ml
320: WHERE wda.delivery_id = wnd.delivery_id
321: AND wda.delivery_detail_id = wdd.delivery_detail_id
322: AND wdd.move_order_line_id = ml.line_id
323: AND wdd.organization_id = p_organization_id

Line 336: , mtl_txn_request_lines ml

332: , wnd.delivery_id
333: FROM wsh_new_deliveries_ob_grp_v wnd
334: , wsh_delivery_details_ob_grp_v wdd
335: , wsh_delivery_assignments wda
336: , mtl_txn_request_lines ml
337: WHERE wda.delivery_id = wnd.delivery_id
338: AND wda.delivery_detail_id = wdd.delivery_detail_id
339: AND wdd.released_status = 'S'
340: AND wdd.organization_id = p_organization_id

Line 354: , mtl_txn_request_lines ml

350: , wnd.delivery_id
351: FROM wsh_new_deliveries_ob_grp_v wnd
352: , wsh_delivery_details_ob_grp_v wdd
353: , wsh_delivery_assignments wda
354: , mtl_txn_request_lines ml
355: , mtl_txn_request_headers mh
356: WHERE wda.delivery_id = wnd.delivery_id
357: AND wda.delivery_detail_id = wdd.delivery_detail_id
358: AND wdd.released_status = 'S'

Line 376: , mtl_txn_request_lines ml

372: , wnd.delivery_id
373: FROM wsh_new_deliveries_ob_grp_v wnd
374: , wsh_delivery_details_ob_grp_v wdd
375: , wsh_delivery_assignments wda
376: , mtl_txn_request_lines ml
377: , mtl_txn_request_headers mh
378: , mtl_material_transactions_temp mmtt
379: WHERE wda.delivery_id = wnd.delivery_id
380: AND wda.delivery_detail_id = wdd.delivery_detail_id