APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISIT_TASK_MATRL_V

Line 46: FROM ahl_visit_task_matrl_v

42:
43: CURSOR c_visit_task_matrl_cur(c_sch_mat_id IN NUMBER)
44: IS
45: SELECT scheduled_date,scheduled_quantity
46: FROM ahl_visit_task_matrl_v
47: WHERE schedule_material_id = c_sch_mat_id;
48:
49: l_api_name CONSTANT VARCHAR2(30) := 'Unschedule_Visit_Materials';
50: l_api_version CONSTANT NUMBER := 1.0;

Line 1996: FROM ahl_visit_task_matrl_v

1992: AND scheduled_date IS NOT NULL;
1993: /*
1994: SELECT visit_id,visit_task_id,schedule_material_id,
1995: scheduled_date,scheduled_quantity
1996: FROM ahl_visit_task_matrl_v
1997: WHERE visit_id = C_VISIT_ID
1998: AND scheduled_date IS NOT NULL;
1999: */
2000: --

Line 2651: FROM ahl_visit_task_matrl_v

2647: object_version_number,
2648: inventory_item_id,
2649: scheduled_date,
2650: scheduled_quantity
2651: FROM ahl_visit_task_matrl_v
2652: WHERE visit_task_id = c_visit_task_id;
2653:
2654: --Retrieve visit level planned materials
2655: CURSOR visit_mtrls_cur (c_visit_id IN NUMBER)

Line 2664: FROM ahl_visit_task_matrl_v

2660: object_version_number,
2661: inventory_item_id,
2662: scheduled_date,
2663: scheduled_quantity
2664: FROM ahl_visit_task_matrl_v
2665: WHERE visit_id = c_visit_id;
2666:
2667: --Standard local variables
2668: l_api_name CONSTANT VARCHAR2(30) := 'Remove_Visit_Task_Matrls';