57: IS
58: SELECT asm.inventory_item_id, asm.visit_id, asm.visit_task_id,
59: asm.requested_quantity, awo.workorder_id, awo.wip_entity_id, awo.workorder_name
60: , vst.item_instance_id,asm.organization_id
61: FROM ahl_schedule_materials asm,ahl_workorders awo, ahl_visits_b vst
62: WHERE asm.status = 'ACTIVE'
63: AND asm.AOG_FLAG = 'Y'
64: AND asm.visit_task_id = awo.visit_task_id
65: AND awo.status_code in ('1','3','6')
341: -- CALL WO to WO Reservation API
342: -- << need to call the one from Inventory Wrapper going to write in future>>
343: -- Get the Supply Workorer and Demand so details for wo - wo reservation
344:
345: l_rsv_rec.demand_source_line_detail := p_cannibalization_rec.demand_asm_id; --
347: l_rsv_rec.supply_source_header_id := l_get_wo_det.wip_entity_id; --WIP Entity Id;
348: l_rsv_rec.supply_source_line_id := l_cannibalization_sr_rec.incident_id; --SR Id to manage in UI;
349: l_rsv_rec.supply_source_line_detail := NULL;