APPS.AHL_PRD_WORKORDER_PUB dependencies on AHL_SEARCH_WORKORDERS_V

Line 39: Select plan_id,collection_id from ahl_search_workorders_v

35: l_workorder_id NUMBER;
36: l_workorder_operation_id NUMBER;
37:
38: CURSOR get_wo_plan_csr(p_Workorder_Id IN NUMBER)IS
39: Select plan_id,collection_id from ahl_search_workorders_v
40: WHERE workorder_id = p_Workorder_Id;
41:
42: CURSOR get_op_plan_csr(p_WoOperationId IN NUMBER)IS
43: Select plan_id,collection_id from ahl_workorder_operations_v

Line 2680: FROM ahl_search_workorders_v

2676:
2677: CURSOR get_workorder_csr(p_workorder_id IN NUMBER)IS
2678: SELECT WORKORDER_ID,WIP_ENTITY_ID,OBJECT_VERSION_NUMBER,JOB_NUMBER,ORGANIZATION_ID,
2679: DEPARTMENT_ID,JOB_STATUS_CODE,PLAN_ID,COLLECTION_ID
2680: FROM ahl_search_workorders_v
2681: WHERE WORKORDER_ID = p_workorder_id;
2682:
2683: BEGIN
2684: -- Standard call to check for call compatibility