[Home] [Help]
1222: asmt.requested_quantity,
1223: asmt.inventory_item_id,
1224: asmt.object_version_number
1225: FROM ahl_schedule_materials asmt,
1226: ahl_visit_tasks_b avtl
1227: WHERE asmt.status = 'ACTIVE'
1228: AND asmt.requested_quantity <>0
1229: AND asmt.scheduled_material_id = c_scheduled_material_id
1230: AND asmt.visit_task_id = avtl.visit_task_id
1593: CURSOR get_mtl_req_dtls_csr (c_visit_id IN NUMBER)
1594: IS
1595: SELECT mat.visit_task_id, mat.scheduled_material_id, mat.workorder_operation_id, mat.operation_sequence
1596: FROM ahl_schedule_materials mat,
1597: ahl_visit_tasks_b vt
1598: WHERE mat.status = 'ACTIVE'
1599: AND mat.requested_quantity <>0
1600: AND vt.status_code = 'PLANNING'
1601: AND vt.visit_task_id = mat.visit_task_id
1873: CURSOR get_upd_rsv_csr (c_visit_id IN NUMBER)
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
2162: CURSOR get_del_rsv_csr (c_visit_id IN NUMBER)
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
2280: vt.visit_task_number, v.visit_number, mat.operation_sequence,
2281: mat.visit_task_id, mat.rt_oper_material_id
2282: FROM ahl_schedule_materials mat,
2283: ahl_visits_b v,
2284: ahl_visit_tasks_b vt
2285: WHERE vt.visit_task_id = mat.visit_task_id
2286: AND vt.visit_id = v.visit_id
2287: AND mat.scheduled_material_id = c_scheduled_material_id;
2288: l_get_mtl_req_dtls_rec get_mtl_req_dtls_csr%ROWTYPE;