APPS.AHL_UMP_BOM_PVT dependencies on CS_INCIDENTS_ALL_B

Line 2513: FROM CS_INCIDENTS_ALL_B CS, CS_INCIDENT_TYPES_TL CIT

2509: SELECT ue.unit_effectivity_id, ue.due_date, ue.mr_header_id,
2510: ue.csi_item_instance_id, ue.object_type, ue.defer_from_ue_id,
2511: ue.manually_planned_flag,
2512: (SELECT CIT.NAME || '-' || CS.INCIDENT_NUMBER
2513: FROM CS_INCIDENTS_ALL_B CS, CS_INCIDENT_TYPES_TL CIT
2514: WHERE CS.incident_id = ue.cs_incident_id
2515: AND CS.INCIDENT_TYPE_ID = CIT.INCIDENT_TYPE_ID
2516: AND CIT.LANGUAGE = USERENV('LANG')) sr_title,
2517: ii.quantity,

Line 2552: FROM CS_INCIDENTS_ALL_B CS, CS_INCIDENT_TYPES_TL CIT

2548: SELECT * FROM (
2549: SELECT UES.simulation_ue_id,ues.simulation_plan_id, ues.due_date, ues.mr_header_id,
2550: ues.csi_item_instance_id, 'SR' object_type, ues.defer_from_ue_id,
2551: (SELECT CIT.NAME || '-' || CS.INCIDENT_NUMBER
2552: FROM CS_INCIDENTS_ALL_B CS, CS_INCIDENT_TYPES_TL CIT
2553: WHERE CS.incident_id = ues.cs_incident_id
2554: AND CS.INCIDENT_TYPE_ID = CIT.INCIDENT_TYPE_ID
2555: AND CIT.LANGUAGE = USERENV('LANG')) sr_title,
2556: DECODE(ues.unit_effectivity_id, NULL, 'N',