APPS.AHL_UMP_BOM_PVT dependencies on AHL_FLEET_HEADERS_B

Line 2521: FROM AHL_UNIT_EFFECTIVITIES_B UE, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt

2517: ii.quantity,
2518: (SELECT 'Y' from ahl_ue_relationships
2519: where originator_ue_id = ue.unit_effectivity_id and rownum < 2) grp_flag,
2520: flt.operating_org_id maintenance_org_id, flt.department_id dept_id, ue.fleet_header_id
2521: FROM AHL_UNIT_EFFECTIVITIES_B UE, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt
2522: WHERE UE.csi_item_instance_id = II.instance_id
2523: AND UE.APPLICATION_USG_CODE = 'AHL'
2524: AND UE.Object_type = 'SR'-- Deb: When object type is SR then mr_header_id is null. In that case all mr dependent cursor is going to fail
2525: AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE')

Line 2563: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt

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')