[Home] [Help]
117: /**
118: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_subinventory_code IN VARCHAR2)
119: IS
120: SELECT mrsv.reservation_id, mrsv.primary_reservation_quantity
121: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
122: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
123: AND external_source_code = 'AHL'
124: AND subinventory_code = c_subinventory_code
125: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
538:
539: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER)
540: IS
541: SELECT reservation_id
542: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
543: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
544: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
545: AND mrsv.organization_id = asmt.organization_id
546: AND mrsv.requirement_date = asmt.requested_date
866: WHERE asmt.scheduled_material_id = c_scheduled_material_id;
867: */
868:
869: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS
870: -- on mtl_reservations
871: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_subinventory_code IN VARCHAR2)
872: IS
873: SELECT reservation_id
874: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
870: -- on mtl_reservations
871: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_subinventory_code IN VARCHAR2)
872: IS
873: SELECT reservation_id
874: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
875: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
876: AND mrsv.external_source_code = 'AHL'
877: AND (c_subinventory_code IS NULL OR mrsv.subinventory_code = c_subinventory_code)
878: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
1246: /**
1247: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_SUBINVENTORY_CODE IN VARCHAR2)
1248: IS
1249: SELECT reservation_id, primary_reservation_quantity
1250: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
1251: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
1252: AND mrsv.external_source_code = 'AHL'
1253: AND mrsv.SUBINVENTORY_CODE = c_SUBINVENTORY_CODE
1254: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
1605: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS
1606: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER)
1607: IS
1608: SELECT reservation_id
1609: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
1610: WHERE demand_source_line_detail = c_scheduled_material_id
1611: AND external_source_code = 'AHL'
1612: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
1613: AND mrsv.organization_id = asmt.organization_id
1874: IS
1875: SELECT mrsv.reservation_id, mrsv.demand_source_header_id, mrsv.demand_source_line_id, mrsv.inventory_item_id,mrsv.organization_id
1876: FROM ahl_schedule_materials asmt,
1877: ahl_visit_tasks_b vt,
1878: mtl_reservations mrsv
1879: WHERE vt.status_code = 'PLANNING'
1880: AND vt.visit_task_id = asmt.visit_task_id
1881: AND vt.visit_id = c_visit_id
1882: AND mrsv.external_source_code = 'AHL'
2163: IS
2164: SELECT mrsv.reservation_id
2165: FROM ahl_schedule_materials asmt,
2166: ahl_visit_tasks_b avt,
2167: mtl_reservations mrsv
2168: WHERE avt.status_code in ( 'PLANNING','DELETED')
2169: AND avt.visit_task_id = asmt.visit_task_id
2170: AND avt.visit_id = c_visit_ID
2171: AND avt.visit_id = asmt.visit_id
2684: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2685:
2686: CURSOR get_reservation_csr IS
2687: SELECT mrsv.reservation_id, mrsv.primary_reservation_quantity
2688: FROM mtl_reservations mrsv, ahl_schedule_materials asmt, mtl_serial_numbers msn
2689: WHERE mrsv.demand_source_line_detail = p_scheduled_material_id
2690: AND mrsv.external_source_code = 'AHL'
2691: AND msn.serial_number = p_serial_number
2692: AND mrsv.organization_id = msn.current_organization_id