[Home] [Help]
64: -- cursor to get the reserved quantity from the WMS tables
65: CURSOR get_rsvd_qty_csr(c_scheduled_material_id IN NUMBER)
66: IS
67: SELECT SUM(primary_reservation_quantity) reserved_quantity
68: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
69: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
70: AND mrsv.external_source_code = 'AHL'
71: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
72: AND mrsv.organization_id = asmt.organization_id
86: AND wo.status_code NOT IN (7, 22, 17, 12, 18, 21, 4, 5) -- cancelled, deleted, draft, closed,Deffered,Pending Defer/Cancel Approval, Complete, Complete No-charge
87: AND vts.visit_task_id = wo.visit_task_id
88: AND vts.return_to_supply_flag = 'Y'
89: /* commented out by debadey for WO-WO reservation updation validation
90: AND NOT EXISTS (SELECT 'X' FROM mtl_reservations
91: WHERE external_source_code = 'AHL'
92: AND supply_source_type_id = c_source_type
93: AND supply_source_header_id = c_wip_entity_id)*/;
94:
416: AND wdj.rebuild_item_id = c_item_id
417: AND vts.return_to_supply_flag = 'Y'
418: AND wdj.organization_id = c_organization_id
419: /* Commented out for WO-WO validation by debadey as per instructions from Balaji
420: AND NOT EXISTS (SELECT 'X' FROM mtl_reservations
421: WHERE external_source_code = 'AHL'
422: AND supply_source_type_id = c_source_type
423: AND supply_source_header_id = c_wip_entity_id)*/;
424: --sukhwsin::Marshling enhancements - changes ends