APPS.INV_LABEL_PVT2 dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 302: , mtl_serial_numbers_temp msnt

298: , rti.vendor_site_id
299: , rti.oe_order_header_id --Bug 4582954
300: , rti.oe_order_line_id --Bug 4582954
301: FROM rcv_transactions_interface rti
302: , mtl_serial_numbers_temp msnt
303: , mtl_transaction_lots_temp mtlt
304: , po_lines_trx_v pol -- CLM project, bug 9403291
305: , po_headers_trx_v pha -- CLM project, bug 9403291
306: WHERE mtlt.transaction_temp_id(+) = rti.interface_transaction_id

Line 329: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

325: , msnt.to_serial_number to_serial_number
326: , mmtt.subinventory_code
327: , mmtt.transaction_uom
328: , mmtt.locator_id /* Added for Bug # 4672471 */
329: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
330: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
331: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
332: AND mmtt.transaction_temp_id = p_transaction_id;
333:

Line 377: and there would not be any mtl_serial_numbers_temp record for it. */

373: , NVL(wdd.project_id, 0) project_id
374: , NVL(wdd.task_id, 0) task_id
375: , wdd.revision revision
376: , wdd.serial_number serial_number /* If there is only one item then this sl. no will get populated
377: and there would not be any mtl_serial_numbers_temp record for it. */
378: , msnt.fm_serial_number fm_serial_number --Added to fix Bug# 4290536
379: , NVL(msnt.to_serial_number, msnt.fm_serial_number) to_serial_number --Added to fix Bug# 4290536
380: , wdd.subinventory
381: , wdd.requested_quantity_uom

Line 383: wsh_new_deliveries wnd, mtl_serial_numbers_temp msnt

379: , NVL(msnt.to_serial_number, msnt.fm_serial_number) to_serial_number --Added to fix Bug# 4290536
380: , wdd.subinventory
381: , wdd.requested_quantity_uom
382: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda,
383: wsh_new_deliveries wnd, mtl_serial_numbers_temp msnt
384: WHERE wda.delivery_id = wnd.delivery_id
385: AND NVL(wdd.transaction_temp_id, -1) = msnt.transaction_temp_id(+)
386: AND wdd.delivery_detail_id = wda.delivery_detail_id
387: AND wdd.inventory_item_id IS NOT NULL

Line 410: , mtl_serial_numbers_temp msnt

406: , wnt.wip_entity_name --Added for Bug: 4642062
407: , wnt.wip_entity_id
408: FROM mtl_material_transactions_temp mmtt
409: , mtl_transaction_lots_temp mtlt
410: , mtl_serial_numbers_temp msnt
411: , wip_entities wnt --Added for Bug 4642062
412: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
413: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
414: AND mmtt.transaction_temp_id = p_transaction_id

Line 608: * mtl_transaction_lots_temp and mtl_serial_numbers_temp based on transaction_id,

604:
605:
606: /*
607: * The following cursor has been added to fetch the lot and serial attributes from
608: * mtl_transaction_lots_temp and mtl_serial_numbers_temp based on transaction_id,
609: * lot_number, from_serial_number and to_serial_number. Since a lot can have
610: * multiple serials associated with it and each serial can have different attributes,
611: * fm_serial_number and to_serial_number has been added in the condition.
612: *

Line 697: , mtl_serial_numbers_temp msnt

693: , msnt.n_attribute8
694: , msnt.n_attribute9
695: , msnt.n_attribute10
696: FROM mtl_transaction_lots_temp mtlt
697: , mtl_serial_numbers_temp msnt
698: , mtl_material_transactions_temp mmtt
699: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
700: AND msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id)
701: AND mmtt.transaction_temp_id = p_transaction_id