[Home] [Help]
1037: WHERE r.route_id = res.object_id
1038: AND r.mr_header_id IN
1039: (SELECT mr.mr_header_id
1040: FROM ahl_mr_headers_b mr,
1041: ahl_ue_simulations ue
1042: WHERE mr.mr_header_id = ue.mr_header_id
1043: AND ue.originator_ue_id = p_grp_ue_id
1044: AND ue.parent_ue_id IS NOT NULL -- Deb: get this logic for chld UEs checked
1045: )
1141: AND r.mr_header_id IN
1142: ( -- all mr headers belonging to child UEs
1143: SELECT mr.mr_header_id
1144: FROM ahl_mr_headers_b mr,
1145: ahl_ue_simulations ue
1146: WHERE mr.mr_header_id = ue.mr_header_id
1147: AND ue.originator_ue_id = p_grp_ue_id
1148: AND ue.parent_ue_id IS NOT NULL
1149: )
1291: CURSOR child_ue_details_sim(p_parent_ue_id NUMBER)
1292: IS
1293: SELECT ue.simulation_ue_id, ue.mr_header_id, ue.csi_item_instance_id,
1294: ue.due_date, od.mr_maintenance_org_id maintenance_org_id, od.mr_maintenance_dept_id dept_id, b.down_time
1295: FROM ahl_ue_simulations ue, ahl_mr_headers_b b, AHL_UE_ORGS_DEPTS_V od
1296: WHERE ue.originator_ue_id = p_parent_ue_id
1297: AND ue.parent_ue_id IS NOT NULL
1298: AND ue.mr_header_id IS NOT NULL
1299: AND ue.mr_header_id = b.mr_header_id
2412: FROM ahl_mr_headers_b mr
2413: WHERE mr_status_code = 'COMPLETE'
2414: AND EXISTS
2415: (SELECT 1
2416: FROM ahl_ue_simulations ues
2417: WHERE ues.mr_header_id = mr.mr_header_id
2418: AND (ues.status_code IS NULL
2419: OR ues.status_code = 'INIT-DUE')
2420: AND NVL(p_plan_id, simulation_plan_id) = simulation_plan_id);
2473: (SELECT manually_planned_flag
2474: FROM ahl_unit_effectivities_b
2475: WHERE unit_effectivity_id = ues.unit_effectivity_id)) manually_planned_flag,
2476: ii.quantity,
2477: (SELECT 'Y' from ahl_ue_simulations WHERE originator_ue_id = ues.simulation_ue_id AND ROWNUM < 2) grp_flag,
2478: mr.down_time,
2479: mr.uom_code,
2480: od.MR_MAINTENANCE_ORG_ID maintenance_org_id,
2481: od.MR_MAINTENANCE_DEPT_ID dept_id,
2479: mr.uom_code,
2480: od.MR_MAINTENANCE_ORG_ID maintenance_org_id,
2481: od.MR_MAINTENANCE_DEPT_ID dept_id,
2482: ues.fleet_header_id
2483: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_MR_HEADERS_B mr, AHL_UE_ORGS_DEPTS_V od
2484: WHERE UES.csi_item_instance_id = II.instance_id
2485: AND UES.mr_header_id = mr.mr_header_id
2486: AND UES.cs_incident_id IS NULL
2487: AND UES.mr_header_id = p_mr_header_id
2557: (SELECT manually_planned_flag
2558: FROM ahl_unit_effectivities_b
2559: WHERE unit_effectivity_id = ues.unit_effectivity_id)) manually_planned_flag,
2560: ii.quantity,
2561: (SELECT 'Y' from ahl_ue_simulations WHERE originator_ue_id = ues.simulation_ue_id AND ROWNUM < 2) grp_flag,
2562: flt.operating_org_id maintenance_org_id, flt.department_id dept_id, ues.fleet_header_id
2563: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt
2564: WHERE UES.csi_item_instance_id = II.instance_id
2565: --AND UE.APPLICATION_USG_CODE = 'AHL'
2559: WHERE unit_effectivity_id = ues.unit_effectivity_id)) manually_planned_flag,
2560: ii.quantity,
2561: (SELECT 'Y' from ahl_ue_simulations WHERE originator_ue_id = ues.simulation_ue_id AND ROWNUM < 2) grp_flag,
2562: flt.operating_org_id maintenance_org_id, flt.department_id dept_id, ues.fleet_header_id
2563: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt
2564: WHERE UES.csi_item_instance_id = II.instance_id
2565: --AND UE.APPLICATION_USG_CODE = 'AHL'
2566: AND UES.cs_incident_id IS NOT NULL-- Deb: When object type is SR them mr_header_id is null. In that case all mr dependent cursor is going to fail
2567: AND (UES.status_code IS NULL OR UES.status_code = 'INIT-DUE')