APPS.INV_LABEL_PVT4 dependencies on MTL_LOT_NUMBERS

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

31: ) IS
32:
33: p_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE := null;
34: p_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE := null;
35: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
36: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;
38: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;

Line 872: , mtl_lot_numbers mln

868: , mln.expiration_action_code
869: , mln.supplier_lot_number -- invconv fabdi end
870: FROM mtl_parameters mp
871: , mtl_system_items_kfv msik
872: , mtl_lot_numbers mln
873: , po_hazard_classes poh
874: , mtl_material_statuses_vl mmsv
875: WHERE msik.inventory_item_id = p_item_id
876: AND msik.organization_id = p_org_id