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_LOT_NUMBERS

Line 700: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;

696: AND all_lpn.lpn_id = nvl(p_lpn_id, all_lpn.lpn_id);
697:
698: p_organization_id NUMBER := null;
699: p_inventory_item_id NUMBER := null;
700: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
701: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
702: p_qty NUMBER := null;
703: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
704: p_cost_group_id NUMBER := null;

Line 707: l_lot_number mtl_lot_numbers.lot_number%TYPE := NULL;

703: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
704: p_cost_group_id NUMBER := null;
705:
706: --Fix for 4891916
707: l_lot_number mtl_lot_numbers.lot_number%TYPE := NULL;
708: l_revision mtl_material_transactions_temp.revision%TYPE := NULL;
709: -- End of fix for 4891916
710:
711: l_subinventory_code VARCHAR2(10) := null;

Line 878: , mtl_lot_numbers mln

874: , mln.expiration_action_code expiration_action_code
875: , mln.supplier_lot_number supplier_lot_number -- invconv changes end
876: FROM mtl_parameters mp
877: ,mtl_system_items_kfv msik
878: , mtl_lot_numbers mln
879: , po_hazard_classes poh
880: , mtl_material_statuses_vl mmsv
881: WHERE msik.inventory_item_id = p_item_id
882: AND msik.organization_id = p_org_id