APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 353: ahl_rt_oper_materials rm

349: SELECT ro.step,
350: ro.operation_id,
351: ro.concatenated_segments
352: FROM ahl_route_operations_v ro,
353: ahl_rt_oper_materials rm
354: WHERE ro.operation_id = rm.object_id
355: AND ro.route_id = c_route_id
356: AND rm.rt_oper_material_id = c_rt_oper_mat_id
357: AND rm.association_type_code = 'OPERATION';

Line 374: FROM ahl_rt_oper_materials

370: SELECT quantity,
371: in_service, --B5865210 - sowsubra
372: replace_percent,
373: association_type_code
374: FROM ahl_rt_oper_materials
375: WHERE rt_oper_material_id = c_rt_oper_mat_id;
376:
377: --Standard local variables
378: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Planned_Matrls';

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

401: --
402: l_task_type_code VARCHAR2(30);
403: l_material_request_type VARCHAR2(30);
404: l_Prior_Item_Rec Get_Prior_Item_Cur%ROWTYPE;
405: l_isInservice AHL_RT_OPER_MATERIALS.IN_SERVICE%TYPE; --Added by sowsubra for Issue 105
406: l_mat_status AHL_SCHEDULE_MATERIALS.STATUS%TYPE; --Added by sowsubra for Issue 105
407: -- SKPATHAK :: Bug 8604722 :: 04-MAR-2010
408: l_default_dff_values dff_default_values_type;
409:

Line 2133: from AHL_RT_OPER_MATERIALS RTOM

2129: FROM AHL_SCHEDULE_MATERIALS ASMT,
2130: AHL_VISIT_TASKS_B VTSK
2131: WHERE ASMT.STATUS <> 'DELETED'
2132: AND EXISTS ( Select 1
2133: from AHL_RT_OPER_MATERIALS RTOM
2134: where RTOM.RT_OPER_MATERIAL_ID = ASMT.RT_OPER_MATERIAL_ID)
2135: AND VTSK.VISIT_ID = ASMT.VISIT_ID
2136: AND VTSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
2137: AND NVL(VTSK.STATUS_CODE,'X') <> 'DELETED'