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_LABEL_PVT2 dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 303: , mtl_transaction_lots_temp mtlt

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
307: AND msnt.transaction_temp_id = NVL(mtlt.serial_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 409: , mtl_transaction_lots_temp mtlt

405: , mmtt.locator_id
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)

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 696: FROM mtl_transaction_lots_temp mtlt

692: , msnt.n_attribute7
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)

Line 1074: FROM mtl_transaction_lots_temp t,

1070: retest_date,
1071: lot_expiration_date,
1072: origination_date,
1073: sts.status_code
1074: FROM mtl_transaction_lots_temp t,
1075: mtl_material_statuses_vl sts
1076: WHERE transaction_temp_id = p_input_param.transaction_temp_id AND
1077: lot_number = l_lot_number
1078: AND sts.status_id(+) = t.status_id; -- Bug 4355080