APPS.INV_LABEL_PVT4 dependencies on MTL_LOT_NUMBERS

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

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

Line 707: , mtl_lot_numbers mln

703: , mln.expiration_action_code
704: , mln.supplier_lot_number -- invconv fabdi end
705: FROM mtl_parameters mp
706: , mtl_system_items_kfv msik
707: , mtl_lot_numbers mln
708: , po_hazard_classes poh
709: , mtl_material_statuses_vl mmsv
710: WHERE msik.inventory_item_id = p_item_id
711: AND msik.organization_id = p_org_id