APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 293: ahl_rt_oper_materials rm

289: SELECT ro.step,
290: ro.operation_id,
291: ro.concatenated_segments
292: FROM ahl_route_operations_v ro,
293: ahl_rt_oper_materials rm
294: WHERE ro.operation_id = rm.object_id
295: AND ro.route_id = c_route_id
296: AND rm.rt_oper_material_id = c_rt_oper_mat_id
297: AND rm.association_type_code = 'OPERATION';

Line 314: FROM ahl_rt_oper_materials

310: SELECT quantity,
311: in_service, --B5865210 - sowsubra
312: replace_percent,
313: association_type_code
314: FROM ahl_rt_oper_materials
315: WHERE rt_oper_material_id = c_rt_oper_mat_id;
316:
317: --Standard local variables
318: l_api_name CONSTANT VARCHAR2(30) := 'Update_Planned_Materials';

Line 345: l_isInservice AHL_RT_OPER_MATERIALS.IN_SERVICE%TYPE; --Added by sowsubra for Issue 105

341: --
342: l_task_type_code VARCHAR2(30);
343: l_material_request_type VARCHAR2(30);
344: l_Prior_Item_Rec Get_Prior_Item_Cur%ROWTYPE;
345: l_isInservice AHL_RT_OPER_MATERIALS.IN_SERVICE%TYPE; --Added by sowsubra for Issue 105
346: l_mat_status AHL_SCHEDULE_MATERIALS.STATUS%TYPE; --Added by sowsubra for Issue 105
347:
348: BEGIN
349:

Line 1986: from AHL_RT_OPER_MATERIALS RTOM

1982: FROM AHL_SCHEDULE_MATERIALS ASMT,
1983: AHL_VISIT_TASKS_B VTSK
1984: WHERE ASMT.STATUS <> 'DELETED'
1985: AND EXISTS ( Select 1
1986: from AHL_RT_OPER_MATERIALS RTOM
1987: where RTOM.RT_OPER_MATERIAL_ID = ASMT.RT_OPER_MATERIAL_ID)
1988: AND VTSK.VISIT_ID = ASMT.VISIT_ID
1989: AND VTSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
1990: AND NVL(VTSK.STATUS_CODE,'X') <> 'DELETED'