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

Line 511: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

507: mmtt.subinventory_code, mmtt.locator_id --Bug 8528146
508: , mmtt.subinventory_code /*from sub, to select printer*/
509: , abs(nvl(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) secondary_quantity, -- invocnv changes
510: mmtt.secondary_uom_code -- invconv changes
511: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
512: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
513: AND mmtt.transaction_temp_id = p_transaction_id;
514:
515: CURSOR c_mmtt_cart_lpn IS

Line 910: , mtl_transaction_lots_temp mtlt

906: , mtlt.expiration_action_code
907: , mtlt.supplier_lot_number
908: FROM mtl_parameters mp
909: , mtl_system_items_kfv msik
910: , mtl_transaction_lots_temp mtlt
911: , mtl_material_transactions_temp mmtt
912: , po_hazard_classes poh
913: , mtl_material_statuses_vl mmsv
914: WHERE msik.inventory_item_id = p_item_id

Line 1863: FROM MTL_TRANSACTION_LOTS_TEMP

1859: -- multiple labels getting fired when PO received into more than one lot
1860: BEGIN
1861: SELECT LOT_NUMBER
1862: INTO p_lot_number
1863: FROM MTL_TRANSACTION_LOTS_TEMP
1864: WHERE TRANSACTION_TEMP_ID = p_transaction_id;
1865: EXCEPTION WHEN OTHERS
1866: THEN
1867: p_lot_number := NULL;