APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 748: FROM AHL_ITEM_COMP_DETAILS ICD

744: c_uom IN VARCHAR2) IS
745: SELECT ICD.inventory_item_id, ICD.inventory_master_org_id, ICD.item_group_id,
746: DECODE(ICD.inventory_item_id, null, c_quantity, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(ICD.inventory_item_id, c_uom, c_quantity)) QUANTITY,
747: DECODE(ICD.inventory_item_id, null, c_uom, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(ICD.inventory_item_id, inventory_master_org_id)) UOM
748: FROM AHL_ITEM_COMP_DETAILS ICD
749: WHERE ITEM_COMP_DETAIL_ID = c_item_comp_detail_id;
750:
751: l_mc_route_effectivity_id NUMBER;
752: l_item_route_effectivity_id NUMBER;