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 464: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

460: , x_msg_data OUT NOCOPY VARCHAR2
461: , x_return_status OUT NOCOPY VARCHAR2
462: , p_label_type_info IN label_type_rec
463: , p_transaction_id IN NUMBER
464: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
465: , p_transaction_identifier IN NUMBER
466: ) IS
467:
468: l_transaction_id NUMBER;

Line 3871: FROM mtl_material_transactions_temp mmtt

3867:
3868: CURSOR mmtt_cur(l_inventory_item_id NUMBER , l_lot_number VARCHAR2) IS
3869: SELECT mmtt.organization_id , mmtt.subinventory_code , mmtt.locator_id ,
3870: NVL(mmtt.lpn_id,mmtt.content_lpn_id) lpn_id , mmtt.transaction_action_id
3871: FROM mtl_material_transactions_temp mmtt
3872: WHERE mmtt.transaction_temp_id =p_transaction_id
3873: AND mmtt.inventory_item_id = l_inventory_item_id
3874: AND Nvl(mmtt.item_lot_control_code,-99) <> 2
3875: UNION

Line 3878: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

3874: AND Nvl(mmtt.item_lot_control_code,-99) <> 2
3875: UNION
3876: SELECT mmtt.organization_id , mmtt.subinventory_code , mmtt.locator_id ,
3877: NVL(mmtt.lpn_id,mmtt.content_lpn_id) lpn_id , mmtt.transaction_action_id
3878: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
3879: WHERE mmtt.transaction_temp_id =p_transaction_id
3880: AND mmtt.inventory_item_id = l_inventory_item_id
3881: AND Nvl(mmtt.item_lot_control_code,-99) = 2
3882: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id