APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISIT_TASK_MATRL_V

Line 90: FROM ahl_visit_task_matrl_v

86:
87: CURSOR c_visit_task_matrl_cur(c_sch_mat_id IN NUMBER)
88: IS
89: SELECT scheduled_date,scheduled_quantity
90: FROM ahl_visit_task_matrl_v
91: WHERE schedule_material_id = c_sch_mat_id;
92:
93: l_api_name CONSTANT VARCHAR2(30) := 'Unschedule_Visit_Materials';
94: l_api_version CONSTANT NUMBER := 1.0;

Line 2143: FROM ahl_visit_task_matrl_v

2139: AND scheduled_date IS NOT NULL;
2140: /*
2141: SELECT visit_id,visit_task_id,schedule_material_id,
2142: scheduled_date,scheduled_quantity
2143: FROM ahl_visit_task_matrl_v
2144: WHERE visit_id = C_VISIT_ID
2145: AND scheduled_date IS NOT NULL;
2146: */
2147: --

Line 2671: FROM ahl_visit_task_matrl_v vtm,

2667: asm.requested_quantity,
2668: asm.uom,
2669: asm.requested_date,
2670: asm.scheduled_date asm_scheduled_date
2671: FROM ahl_visit_task_matrl_v vtm,
2672: ahl_schedule_materials asm
2673: WHERE vtm.visit_task_id = c_visit_task_id
2674: AND asm.scheduled_material_id = vtm.schedule_material_id;
2675:

Line 2693: FROM ahl_visit_task_matrl_v vtm,

2689: asm.requested_quantity,
2690: asm.uom,
2691: asm.requested_date,
2692: asm.scheduled_date asm_scheduled_date
2693: FROM ahl_visit_task_matrl_v vtm,
2694: ahl_schedule_materials asm
2695: WHERE vtm.visit_id = c_visit_id
2696: AND asm.scheduled_material_id = vtm.schedule_material_id;
2697: