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 729: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;

725: AND all_lpn.lpn_id = nvl(p_lpn_id, all_lpn.lpn_id);
726:
727: p_organization_id NUMBER := null;
728: p_inventory_item_id NUMBER := null;
729: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
730: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
731: p_qty NUMBER := null;
732: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
733: p_cost_group_id NUMBER := null;

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

732: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
733: p_cost_group_id NUMBER := null;
734:
735: --Fix for 4891916
736: l_lot_number mtl_lot_numbers.lot_number%TYPE := NULL;
737: l_revision mtl_material_transactions_temp.revision%TYPE := NULL;
738: -- End of fix for 4891916
739:
740: l_subinventory_code VARCHAR2(10) := null;

Line 1022: , mtl_lot_numbers mln

1018: , mln.expiration_action_code expiration_action_code
1019: , mln.supplier_lot_number supplier_lot_number -- invconv changes end
1020: FROM mtl_parameters mp
1021: ,mtl_system_items_kfv msik
1022: , mtl_lot_numbers mln
1023: , po_hazard_classes poh
1024: , mtl_material_statuses_vl mmsv
1025: WHERE msik.inventory_item_id = p_item_id
1026: AND msik.organization_id = p_org_id