[Home] [Help]
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
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)
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)
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
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
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
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
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'
359: AND wdd.organization_id = p_organization_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
381: AND wdd.released_status = 'S'
410: OPEN x_pickslip FOR
411: SELECT UNIQUE pick_slip_number
412: FROM mtl_material_transactions_temp mmtt
413: , mtl_sales_orders mso
414: , mtl_txn_request_headers mh
415: WHERE mmtt.organization_id = p_organization_id
416: AND mmtt.move_order_header_id = mh.header_id
417: AND mso.sales_order_id = mmtt.transaction_source_id
418: AND (p_so_number IS NULL OR mso.segment1 = p_so_number)