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 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 347: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn

343: , msn.serial_number serial_number
344: , mmtt.subinventory_code
345: , mmtt.transaction_uom
346: , mmtt.locator_id
347: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn
348: WHERE mmtt.transaction_temp_id = p_transaction_id
349: AND mmtt.lpn_id = msn.lpn_id;
350:
351: -- For business_flow_code of Cross Dock, the delivery_detail_id is passed.

Line 408: FROM mtl_material_transactions_temp mmtt

404: , mmtt.subinventory_code
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

Line 698: , mtl_material_transactions_temp mmtt

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

Line 3731: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

3727: , x_msg_data OUT NOCOPY VARCHAR2
3728: , x_return_status OUT NOCOPY VARCHAR2
3729: , p_label_type_info IN inv_label.label_type_rec
3730: , p_transaction_id IN NUMBER
3731: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
3732: , p_transaction_identifier IN NUMBER
3733: ) IS
3734: l_variable_data_tbl inv_label.label_tbl_type;
3735: BEGIN