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_MATERIAL_TRANSACTIONS_TEMP

Line 32: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_return_status OUT NOCOPY VARCHAR2
30: , p_label_type_info IN inv_label.label_type_rec
31: , p_transaction_id IN NUMBER
32: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
33: , p_transaction_identifier IN NUMBER
34: ) IS
35: l_receipt_number VARCHAR2(30); -- Added for Bug 2847799
36: l_delivery_detail_id NUMBER;

Line 44: l_revision mtl_material_transactions_temp.revision%TYPE;

40: l_inventory_item_id NUMBER;
41: l_organization_id NUMBER;
42: l_lot_number VARCHAR2(240);
43: l_serial_number VARCHAR2(240);
44: l_revision mtl_material_transactions_temp.revision%TYPE;
45: l_subinventory VARCHAR2(30) := NULL;
46: l_project_number VARCHAR (25); -- Fix For Bug: 4907062
47: l_project_name VARCHAR2(240);
48: l_task_number VARCHAR (25); -- Fix For Bug: 4907062

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

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:

Line 342: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn

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.

Line 403: FROM mtl_material_transactions_temp mmtt

399: , mmtt.subinventory_code
400: , mmtt.locator_id
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

Line 693: , mtl_material_transactions_temp mmtt

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
697: AND mtlt.lot_number(+) = l_lot_number

Line 3691: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

3687: , x_msg_data OUT NOCOPY VARCHAR2
3688: , x_return_status OUT NOCOPY VARCHAR2
3689: , p_label_type_info IN inv_label.label_type_rec
3690: , p_transaction_id IN NUMBER
3691: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
3692: , p_transaction_identifier IN NUMBER
3693: ) IS
3694: l_variable_data_tbl inv_label.label_tbl_type;
3695: BEGIN