APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WORKORDER_TASKS_V

Line 715: FROM AHL_WORKORDER_TASKS_V

711: --Get unit name cursor
712: CURSOR Get_Wo_Unit_Name_cur(c_workorder_id IN NUMBER)
713: IS
714: SELECT unit_name
715: FROM AHL_WORKORDER_TASKS_V
716: WHERE workorder_id = c_workorder_id and rownum =1;
717: CURSOR Get_rec_from_id (c_unit_name VARCHAR2, c_mc_header_id NUMBER)
718: IS
719: SELECT DISTINCT

Line 1336: FROM AHL_WORKORDER_TASKS_V

1332: --sukhwsin: SB Effectivity - Added Cursor to get uc_header_id
1333: CURSOR Get_Wo_Uc_Header_Id(c_workorder_id IN NUMBER)
1334: IS
1335: SELECT uc_header_id
1336: FROM AHL_WORKORDER_TASKS_V
1337: WHERE workorder_id = c_workorder_id;
1338:
1339: -- pdoki modified the query to check for position based material reqs along with item group based reqs
1340: -- sukhwsin::VCP Integration - Added cursor to get material req count that contains item group

Line 6493: FROM AHL_WORKORDER_TASKS_V

6489: --Cursor to get uc_header_id for workorder
6490: CURSOR Get_Wo_Uc_Header_Id(c_workorder_id IN NUMBER)
6491: IS
6492: SELECT uc_header_id
6493: FROM AHL_WORKORDER_TASKS_V
6494: WHERE workorder_id = c_workorder_id;
6495:
6496: --Local Variable Declaration
6497: l_api_name CONSTANT VARCHAR2(30) := 'Wo_Mat_Req_Item_Change';