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 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 500: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

496: , x_msg_data OUT NOCOPY VARCHAR2
497: , x_return_status OUT NOCOPY VARCHAR2
498: , p_label_type_info IN label_type_rec
499: , p_transaction_id IN NUMBER
500: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
501: , p_transaction_identifier IN NUMBER
502: ) IS
503:
504: l_transaction_id NUMBER;

Line 3970: FROM mtl_material_transactions_temp mmtt

3966:
3967: CURSOR mmtt_cur(l_inventory_item_id NUMBER , l_lot_number VARCHAR2) IS
3968: SELECT mmtt.organization_id , mmtt.subinventory_code , mmtt.locator_id ,
3969: NVL(mmtt.lpn_id,mmtt.content_lpn_id) lpn_id , mmtt.transaction_action_id
3970: FROM mtl_material_transactions_temp mmtt
3971: WHERE mmtt.transaction_temp_id =p_transaction_id
3972: AND mmtt.inventory_item_id = l_inventory_item_id
3973: AND Nvl(mmtt.item_lot_control_code,-99) <> 2
3974: UNION

Line 3977: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

3973: AND Nvl(mmtt.item_lot_control_code,-99) <> 2
3974: UNION
3975: SELECT mmtt.organization_id , mmtt.subinventory_code , mmtt.locator_id ,
3976: NVL(mmtt.lpn_id,mmtt.content_lpn_id) lpn_id , mmtt.transaction_action_id
3977: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
3978: WHERE mmtt.transaction_temp_id =p_transaction_id
3979: AND mmtt.inventory_item_id = l_inventory_item_id
3980: AND Nvl(mmtt.item_lot_control_code,-99) = 2
3981: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id