APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 691: FROM AHL_ITEM_COMP_DETAILS ICD

687: c_uom IN VARCHAR2) IS
688: SELECT ICD.inventory_item_id, ICD.inventory_master_org_id, ICD.item_group_id,
689: 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,
690: 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
691: FROM AHL_ITEM_COMP_DETAILS ICD
692: WHERE ITEM_COMP_DETAIL_ID = c_item_comp_detail_id;
693:
694: l_mc_route_effectivity_id NUMBER;
695: l_item_route_effectivity_id NUMBER;