APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 192: ahl_unit_effectivities_b ue

188: wo.status_code
189: FROM
190: ahl_visit_tasks_b vtsk,
191: ahl_workorders wo,
192: ahl_unit_effectivities_b ue
193: WHERE
194: ue.cs_incident_id = p_incident_id
195: AND ue.unit_effectivity_id = vtsk.unit_effectivity_id
196: AND vtsk.visit_task_id = wo.visit_task_id

Line 2274: update ahl_unit_effectivities_b

2270: ---Changes by VSUNDARA FOR TRANSIT CHECK
2271:
2272: -- Tamal [MEL/CDL PRD Integration] Begins here...
2273: -- After creating the SR on the instance, need to populate unit_config_id for the newly created UE
2274: update ahl_unit_effectivities_b
2275: set unit_config_header_id = AHL_UTIL_UC_PKG.get_uc_header_id(p_x_sr_task_rec.instance_id),
2276: -- VLAKKU ER # 13787940
2277: qa_inspection_type = p_x_sr_task_rec.quality_inspection_type_code
2278: where unit_effectivity_id in

Line 2281: from ahl_unit_effectivities_b

2277: qa_inspection_type = p_x_sr_task_rec.quality_inspection_type_code
2278: where unit_effectivity_id in
2279: (
2280: select unit_effectivity_id
2281: from ahl_unit_effectivities_b
2282: where object_type = 'SR' and cs_incident_id = p_x_sr_task_rec.incident_id
2283: );
2284: -- Tamal [MEL/CDL PRD Integration] Ends here...
2285:

Line 2302: -- update ump table with originating wo id in AHL_UNIT_EFFECTIVITIES_B.ORIGINATING_WO_ID

2298: ||'p_x_sr_task_rec.incident_id->'||p_x_sr_task_rec.incident_id
2299: );
2300: END IF;
2301:
2302: -- update ump table with originating wo id in AHL_UNIT_EFFECTIVITIES_B.ORIGINATING_WO_ID
2303: IF
2304: (
2305: p_x_sr_task_rec.incident_id IS NOT NULL
2306: AND

Line 2313: UPDATE AHL_UNIT_EFFECTIVITIES_B

2309: THEN
2310:
2311: BEGIN
2312:
2313: UPDATE AHL_UNIT_EFFECTIVITIES_B
2314: SET ORIGINATING_WO_ID = p_x_sr_task_rec.Originating_wo_id
2315: WHERE CS_INCIDENT_ID = p_x_sr_task_rec.incident_id;
2316:
2317: EXCEPTION

Line 2570: from AHL_UNIT_EFFECTIVITIES_B

2566: -- 3. cursor for retrieving unit effectivity id corresponding to the SR created.
2567: CURSOR c_get_ue_id(p_incident_id NUMBER)
2568: IS
2569: Select unit_effectivity_id
2570: from AHL_UNIT_EFFECTIVITIES_B
2571: where cs_incident_id = p_incident_id;
2572:
2573: CURSOR c_get_sr_details(p_incident_id NUMBER)
2574: IS

Line 2610: AHL_UNIT_EFFECTIVITIES_B UE

2606: SELECT WIP.FIRM_PLANNED_FLAG
2607: FROM AHL_VISIT_TASKS_B VST,
2608: AHL_WORKORDERS WO,
2609: WIP_DISCRETE_JOBS WIP,
2610: AHL_UNIT_EFFECTIVITIES_B UE
2611: WHERE VST.SERVICE_REQUEST_ID = c_sr_id
2612: AND VST.TASK_TYPE_CODE IN ('SUMMARY')
2613: AND VST.VISIT_TASK_ID = WO.VISIT_TASK_ID
2614: AND WO.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID

Line 3191: from AHL_UNIT_EFFECTIVITIES_B

3187:
3188: CURSOR getUnitEffectivity(p_incident_id NUMBER)
3189: IS
3190: Select unit_effectivity_id
3191: from AHL_UNIT_EFFECTIVITIES_B
3192: where cs_incident_id = p_incident_id;
3193:
3194: -- FND Logging Constants
3195: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;