[Home] [Help]
137: , rti.vendor_id
138: , rti.vendor_site_id
139: , rti.oe_order_header_id --Bug 4582954
140: , rti.oe_order_line_id --Bug 4582954
141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn, po_lines_all pol, wms_lpn_contents wlc, po_headers_all pha
142: WHERE wlc.parent_lpn_id = rti.lpn_id
143: AND pol.po_line_id(+) = rti.po_line_id
144: AND pha.po_header_id(+) = rti.po_header_id
145: AND msn.lpn_id = rti.lpn_id
187: , rt.oe_order_header_id --Bug 4582954
188: , rt.oe_order_line_id --Bug 4582954
189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol
190: -- , po_distributions_all pod --Commented as part of Bug# 3586116
191: , po_headers_all pha, rcv_shipment_lines rsl
192: , wms_license_plate_numbers wlpn -- Bug 3836623
193: WHERE rss.transaction_id = rt.transaction_id
194: AND pol.po_line_id(+) = rt.po_line_id
195: AND pha.po_header_id(+) = rt.po_header_id
237: , mtl_transaction_lot_numbers mtln
238: , mtl_unit_transactions mut
239: -- , po_distributions_all pod --Commented as part of Bug# 3586116
240: , po_lines_all pol
241: , po_headers_all pha
242: , rcv_shipment_lines rsl
243: , wms_license_plate_numbers wlpn -- Bug 3836623
244: -- Bug 4179732, can not print serial number from putaway
245: -- Changed to link to MUT through MMT
296: FROM rcv_transactions_interface rti
297: , mtl_serial_numbers_temp msnt
298: , mtl_transaction_lots_temp mtlt
299: , po_lines_all pol
300: , po_headers_all pha
301: WHERE mtlt.transaction_temp_id(+) = rti.interface_transaction_id
302: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, rti.interface_transaction_id)
303: AND pol.po_line_id(+) = rti.po_line_id
304: AND pha.po_header_id(+) = rti.po_header_id
1117: i NUMBER;
1118: j NUMBER;
1119: l_serial_table_index NUMBER;
1120: l_serial_loop_count NUMBER;
1121: l_purchase_order po_headers_all.segment1%TYPE;
1122: l_label_index NUMBER;
1123: l_label_request_id NUMBER;
1124: --I cleanup, use l_prev_format_id to record the previous label format
1125: l_prev_format_id NUMBER;