[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
149: AND rti.interface_transaction_id = p_transaction_id
150: ORDER BY msn.serial_number;
151:
152: /* Patchset J - Earlier serial numbers were only recorded for WMS organizations
153: * using RTI_SERIAL_LPN_CUR by joining RTI to WLC and MTL_SERIAL_NUMBERS(MSN).
154: * Now th Serial numbers are recorded for both WMS and INV organizations in
155: * RCV_SERIALS_INTERFACE table, with the link to RTI, and/or RLI.
156: * The old cursor RTI_SERIAL_LPN_CUR should be replaced by new cursor RTI_SERIAL_CUR
157: */
293: , rti.vendor_site_id
294: , rti.oe_order_header_id --Bug 4582954
295: , rti.oe_order_line_id --Bug 4582954
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
320: , msnt.to_serial_number to_serial_number
321: , mmtt.subinventory_code
322: , mmtt.transaction_uom
323: , mmtt.locator_id /* Added for Bug # 4672471 */
324: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
325: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
326: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
327: AND mmtt.transaction_temp_id = p_transaction_id;
328:
338: , msn.serial_number serial_number
339: , mmtt.subinventory_code
340: , mmtt.transaction_uom
341: , mmtt.locator_id
342: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn
343: WHERE mmtt.transaction_temp_id = p_transaction_id
344: AND mmtt.lpn_id = msn.lpn_id;
345:
346: -- For business_flow_code of Cross Dock, the delivery_detail_id is passed.
368: , NVL(wdd.project_id, 0) project_id
369: , NVL(wdd.task_id, 0) task_id
370: , wdd.revision revision
371: , wdd.serial_number serial_number /* If there is only one item then this sl. no will get populated
372: and there would not be any mtl_serial_numbers_temp record for it. */
373: , msnt.fm_serial_number fm_serial_number --Added to fix Bug# 4290536
374: , NVL(msnt.to_serial_number, msnt.fm_serial_number) to_serial_number --Added to fix Bug# 4290536
375: , wdd.subinventory
376: , wdd.requested_quantity_uom
374: , NVL(msnt.to_serial_number, msnt.fm_serial_number) to_serial_number --Added to fix Bug# 4290536
375: , wdd.subinventory
376: , wdd.requested_quantity_uom
377: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda,
378: wsh_new_deliveries wnd, mtl_serial_numbers_temp msnt
379: WHERE wda.delivery_id = wnd.delivery_id
380: AND NVL(wdd.transaction_temp_id, -1) = msnt.transaction_temp_id(+)
381: AND wdd.delivery_detail_id = wda.delivery_detail_id
382: AND wdd.inventory_item_id IS NOT NULL
401: , wnt.wip_entity_name --Added for Bug: 4642062
402: , wnt.wip_entity_id
403: FROM mtl_material_transactions_temp mmtt
404: , mtl_transaction_lots_temp mtlt
405: , mtl_serial_numbers_temp msnt
406: , wip_entities wnt --Added for Bug 4642062
407: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
408: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
409: AND mmtt.transaction_temp_id = p_transaction_id
424: , msni.to_serial_number to_serial_number
425: , mti.subinventory_code
426: , mti.locator_id -- Added for Bug #5533362
427: , mti.transaction_uom
428: FROM mtl_transactions_interface mti, mtl_transaction_lots_interface mtil, mtl_serial_numbers_interface msni
429: WHERE mtil.transaction_interface_id(+) = mti.transaction_interface_id
430: AND msni.transaction_interface_id = NVL(mtil.serial_transaction_temp_id, mti.transaction_interface_id)
431: AND mti.transaction_interface_id = p_transaction_id;
432:
599:
600:
601: /*
602: * The following cursor has been added to fetch the lot and serial attributes from
603: * mtl_transaction_lots_temp and mtl_serial_numbers_temp based on transaction_id,
604: * lot_number, from_serial_number and to_serial_number. Since a lot can have
605: * multiple serials associated with it and each serial can have different attributes,
606: * fm_serial_number and to_serial_number has been added in the condition.
607: *
688: , msnt.n_attribute8
689: , msnt.n_attribute9
690: , msnt.n_attribute10
691: FROM mtl_transaction_lots_temp mtlt
692: , mtl_serial_numbers_temp msnt
693: , mtl_material_transactions_temp mmtt
694: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
695: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
696: AND mmtt.transaction_temp_id = p_transaction_id
987: --milk.concatenated_segments LOCATOR -- Modified for bug # 5015415
988: FROM mtl_system_items_vl msik
989: , mtl_material_statuses_vl mmsvl2
990: , po_hazard_classes poh
991: , mtl_serial_numbers msn
992: , cst_cost_groups ccg
993: , wip_entities wipent
994: , wms_item_locations_kfv wilk -- Modified for bug # 5015415
995: -- , mtl_item_locations_kfv milk -- Added as part of change for patchset "I".