APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 4037: FROM MTL_SYSTEM_ITEMS_VL

4033: CURSOR l_item_id_cur ( c_item_description IN VARCHAR2,
4034: c_item_id IN NUMBER)
4035: IS
4036: SELECT distinct(inventory_item_id)
4037: FROM MTL_SYSTEM_ITEMS_VL
4038: WHERE (inventory_item_id = c_item_id OR concatenated_segments = c_item_description);
4039: */
4040: CURSOR l_item_id_cur ( c_item_id IN NUMBER)
4041: IS

Line 4043: FROM MTL_SYSTEM_ITEMS_VL

4039: */
4040: CURSOR l_item_id_cur ( c_item_id IN NUMBER)
4041: IS
4042: SELECT distinct(inventory_item_id)
4043: FROM MTL_SYSTEM_ITEMS_VL
4044: WHERE inventory_item_id = c_item_id;
4045:
4046: CURSOR l_item_name_cur ( c_item_description IN VARCHAR2)
4047: IS

Line 4049: FROM MTL_SYSTEM_ITEMS_VL

4045:
4046: CURSOR l_item_name_cur ( c_item_description IN VARCHAR2)
4047: IS
4048: SELECT distinct(inventory_item_id)
4049: FROM MTL_SYSTEM_ITEMS_VL
4050: WHERE concatenated_segments = c_item_description;
4051:
4052:
4053: --Cursor to filter visit type and item type (space capabilities)

Line 5446: FROM MTL_SYSTEM_ITEMS_VL

5442: CURSOR l_item_id_cur (c_item_description IN VARCHAR2,
5443: c_item_id IN NUMBER)
5444: IS
5445: SELECT distinct(inventory_item_id),concatenated_segments
5446: FROM MTL_SYSTEM_ITEMS_VL
5447: WHERE (inventory_item_id = c_item_id
5448: OR concatenated_segments = c_item_description);
5449: */
5450: CURSOR l_item_name_cur (c_item_description IN VARCHAR2)

Line 5453: FROM MTL_SYSTEM_ITEMS_VL

5449: */
5450: CURSOR l_item_name_cur (c_item_description IN VARCHAR2)
5451: IS
5452: SELECT distinct(inventory_item_id),concatenated_segments
5453: FROM MTL_SYSTEM_ITEMS_VL
5454: WHERE concatenated_segments = c_item_description;
5455:
5456: CURSOR l_item_id_cur (c_item_id IN NUMBER)
5457: IS

Line 5459: FROM MTL_SYSTEM_ITEMS_VL

5455:
5456: CURSOR l_item_id_cur (c_item_id IN NUMBER)
5457: IS
5458: SELECT distinct(inventory_item_id),concatenated_segments
5459: FROM MTL_SYSTEM_ITEMS_VL
5460: WHERE inventory_item_id = c_item_id;
5461:
5462: --
5463: l_api_name CONSTANT VARCHAR2(30) := 'GET_VISIT_DETAILS';