eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VISIT_TASKS_B

Line 746: UPDATE AHL_VISIT_TASKS_B

742: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
743: END IF;
744:
745: IF l_return_status = 'S' THEN
746: UPDATE AHL_VISIT_TASKS_B
747: SET PROJECT_TASK_ID = l_task_id,
748: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
749: WHERE VISIT_TASK_ID = p_visit_task_id;
750: END IF;

Line 1486: UPDATE AHL_VISIT_TASKS_B

1482: OPEN c_Task_OVN(p_visit_id,l_task_in(z).PA_TASK_NUMBER);
1483: FETCH c_Task_OVN INTO l_obj_version;
1484: CLOSE c_Task_OVN;
1485:
1486: UPDATE AHL_VISIT_TASKS_B
1487: SET PROJECT_TASK_ID = l_task_out(z).pa_task_id,
1488: OBJECT_VERSION_NUMBER = l_obj_version + 1
1489: WHERE VISIT_ID = p_visit_id AND VISIT_TASK_NUMBER = l_task_in(z).PA_TASK_NUMBER;
1490:

Line 1931: UPDATE AHL_VISIT_TASKS_B SET

1927: LOOP
1928: FETCH c_task_proj INTO c_task_proj_rec;
1929: EXIT WHEN c_task_proj%NOTFOUND;
1930:
1931: UPDATE AHL_VISIT_TASKS_B SET
1932: PROJECT_TASK_ID = c_task_proj_rec.task_id,
1933: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
1934: /*B6436358 - sowsubra - Visit task number is of type number and task number in projects
1935: is of type char. Hence the invalid number error. And so added a to_char function to convert

Line 2526: FROM AHL_VISIT_TASKS_B VT

2522: -- To find only those routes which are there in tasks table but not in route table for a visit
2523: -- Added where condition for checking DELETED status in 11.5.10
2524: CURSOR c_route_chk (x_id IN NUMBER) IS
2525: SELECT VT.MR_ROUTE_ID
2526: FROM AHL_VISIT_TASKS_B VT
2527: WHERE VT.VISIT_ID = x_id
2528: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED')
2529: AND VT.MR_Route_ID IS NOT NULL
2530: AND NOT EXISTS (

Line 2542: SELECT VISIT_TASK_ID, VISIT_TASK_NUMBER FROM AHL_VISIT_TASKS_B

2538:
2539: -- To find visit task id for the non-summary tasks which have no MR Routes
2540: -- Added where condition for checking DELETED status in 11.5.10
2541: CURSOR c_route_tsk (x_id IN NUMBER) IS
2542: SELECT VISIT_TASK_ID, VISIT_TASK_NUMBER FROM AHL_VISIT_TASKS_B
2543: WHERE VISIT_ID = x_id
2544: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED')
2545: AND MR_Route_ID IS NULL
2546: AND TASK_TYPE_CODE <> 'SUMMARY';

Line 2561: SELECT DEPARTMENT_ID FROM AHL_VISIT_TASKS_B

2557:
2558: -- To find all departments from a visit's tasks table
2559: -- Added where condition for checking DELETED status in 11.5.10
2560: CURSOR c_dept_task (x_id IN NUMBER) IS
2561: SELECT DEPARTMENT_ID FROM AHL_VISIT_TASKS_B
2562: WHERE VISIT_ID = x_id
2563: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED')
2564: AND DEPARTMENT_ID IS NOT NULL;
2565: c_dept_task_rec c_dept_task%ROWTYPE;

Line 2570: SELECT DEPARTMENT_ID, VISIT_TASK_NUMBER FROM AHL_VISIT_TASKS_B

2566:
2567: -- To find all departments from a visit's tasks table
2568: -- Added where condition for checking DELETED status in 11.5.10
2569: CURSOR c_dept_tsk (x_id IN NUMBER) IS
2570: SELECT DEPARTMENT_ID, VISIT_TASK_NUMBER FROM AHL_VISIT_TASKS_B
2571: WHERE VISIT_ID = x_id
2572: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED')
2573: AND DEPARTMENT_ID IS NOT NULL;
2574: c_dept_tsk_rec c_dept_tsk%ROWTYPE;

Line 3422: FROM AHL_VISIT_TASKS_B

3418: AND MASTER_WORKORDER_FLAG = 'Y';
3419:
3420: CURSOR get_task_dtls(c_visit_task_id IN NUMBER) IS
3421: SELECT visit_task_number, task_type_code, SERVICE_REQUEST_ID, MR_ID, originating_task_id
3422: FROM AHL_VISIT_TASKS_B
3423: WHERE visit_task_id = c_visit_task_id;
3424:
3425: -- Get all the Parent Task Records For the Visit Task
3426: CURSOR get_parent_task_dtls(c_visit_task_id NUMBER) IS

Line 3428: FROM AHL_VISIT_TASKS_B PARENT, AHL_VISIT_TASKS_B CHILD

3424:
3425: -- Get all the Parent Task Records For the Visit Task
3426: CURSOR get_parent_task_dtls(c_visit_task_id NUMBER) IS
3427: SELECT PARENT.visit_task_number, PARENT.visit_task_id
3428: FROM AHL_VISIT_TASKS_B PARENT, AHL_VISIT_TASKS_B CHILD
3429: WHERE PARENT.visit_task_id = CHILD.originating_task_id
3430: AND CHILD.visit_task_id = c_visit_task_id;
3431:
3432: CURSOR does_wo_exist_csr(c_visit_task_id NUMBER) IS

Line 3568: FROM AHL_VISIT_TASKS_B

3564: IS
3565: SELECT visit_task_id,
3566: visit_task_number,
3567: NVL(originating_task_id, -1)
3568: FROM AHL_VISIT_TASKS_B
3569: WHERE visit_id = c_visit_id
3570: AND task_type_code='SUMMARY'
3571: AND mr_id IS NOT NULL
3572: ORDER BY 3;*/

Line 3581: FROM AHL_VISIT_TASKS_B

3577: IS
3578: SELECT visit_task_id,
3579: visit_task_number,
3580: NVL(originating_task_id, -1)
3581: FROM AHL_VISIT_TASKS_B
3582: WHERE visit_id = c_visit_id
3583: AND task_type_code='SUMMARY'
3584: AND (mr_id IS NOT NULL OR unit_effectivity_id IS NOT NULL)
3585: AND NVL(STATUS_CODE, 'X') <> 'DELETED'

Line 3605: FROM AHL_VISIT_TASKS_B

3601: -- Get all the Tasks associated to a MR.
3602: CURSOR get_tasks_for_mr(c_visit_id NUMBER, c_mr_task_id NUMBER)
3603: IS
3604: SELECT visit_task_number, visit_task_id
3605: FROM AHL_VISIT_TASKS_B
3606: WHERE visit_id = c_visit_id
3607: AND originating_task_id = c_mr_task_id
3608: AND task_type_code <> 'SUMMARY'
3609: AND NVL(STATUS_CODE, 'X') = 'PLANNING' --Srini Bug #4075702

Line 3616: FROM AHL_VISIT_TASKS_B

3612: -- Get all the Unassociated Tasks.
3613: CURSOR get_un_associated_tasks(c_visit_id NUMBER)
3614: IS
3615: SELECT visit_task_number, visit_task_id
3616: FROM AHL_VISIT_TASKS_B
3617: WHERE visit_id = c_visit_id
3618: AND NVL(STATUS_CODE, 'X') = 'PLANNING' --Srini Bug #4075702
3619: AND task_type_code='UNASSOCIATED';
3620:

Line 3801: FROM AHL_VISIT_TASKS_B PARENT,

3797: CURSOR get_tech_dependencies(c_visit_task_id NUMBER)
3798: IS
3799: SELECT PARENT.visit_task_number parent_task_number,
3800: CHILD.visit_task_number child_task_number
3801: FROM AHL_VISIT_TASKS_B PARENT,
3802: AHL_VISIT_TASKS_B CHILD,
3803: AHL_TASK_LINKS LINK
3804: WHERE PARENT.visit_task_id = LINK.parent_task_id
3805: AND CHILD.visit_task_id = LINK.visit_task_id

Line 3802: AHL_VISIT_TASKS_B CHILD,

3798: IS
3799: SELECT PARENT.visit_task_number parent_task_number,
3800: CHILD.visit_task_number child_task_number
3801: FROM AHL_VISIT_TASKS_B PARENT,
3802: AHL_VISIT_TASKS_B CHILD,
3803: AHL_TASK_LINKS LINK
3804: WHERE PARENT.visit_task_id = LINK.parent_task_id
3805: AND CHILD.visit_task_id = LINK.visit_task_id
3806: AND NVL(PARENT.STATUS_CODE,'X') = 'PLANNING'

Line 3898: FROM AHL_VISIT_TASKS_B PARENT,

3894: CURSOR get_tech_dependencies(c_visit_id NUMBER)
3895: IS
3896: SELECT PARENT.visit_task_number parent_task_number,
3897: CHILD.visit_task_number child_task_number
3898: FROM AHL_VISIT_TASKS_B PARENT,
3899: AHL_VISIT_TASKS_B CHILD,
3900: AHL_TASK_LINKS LINK
3901: WHERE PARENT.visit_task_id = LINK.parent_task_id
3902: AND CHILD.visit_task_id = LINK.visit_task_id

Line 3899: AHL_VISIT_TASKS_B CHILD,

3895: IS
3896: SELECT PARENT.visit_task_number parent_task_number,
3897: CHILD.visit_task_number child_task_number
3898: FROM AHL_VISIT_TASKS_B PARENT,
3899: AHL_VISIT_TASKS_B CHILD,
3900: AHL_TASK_LINKS LINK
3901: WHERE PARENT.visit_task_id = LINK.parent_task_id
3902: AND CHILD.visit_task_id = LINK.visit_task_id
3903: AND NVL(PARENT.STATUS_CODE,'X') = 'PLANNING' --Srini Bug #4075702

Line 4063: AHL_VISIT_TASKS_B t

4059: -- Get workorder status for the coresponding job in originating visit
4060: CURSOR c_wo_status (x_orig_visit_id IN NUMBER, x_visit_task_id IN NUMBER) IS
4061: SELECT wo.status_code
4062: FROM AHL_WORKORDERS WO,
4063: AHL_VISIT_TASKS_B t
4064: WHERE wo.VISIT_ID = x_orig_visit_id
4065: AND wo.visit_task_id = t.visit_task_id
4066: AND t.visit_task_number = (Select visit_task_number
4067: from ahl_visit_tasks_b

Line 4067: from ahl_visit_tasks_b

4063: AHL_VISIT_TASKS_B t
4064: WHERE wo.VISIT_ID = x_orig_visit_id
4065: AND wo.visit_task_id = t.visit_task_id
4066: AND t.visit_task_number = (Select visit_task_number
4067: from ahl_visit_tasks_b
4068: where visit_task_id = x_visit_task_id)
4069: AND wo.STATUS_CODE not in ('22','7'); --(22-Deleted, 7-Cancelled)
4070: -- yazhou end
4071:

Line 4088: from ahl_visit_tasks_b t,

4084: -- Added by Jerry on 08/13/2004 per Yan and Alex's request
4085: -- Yan added the condition to filter out summary tasks on 08/31/2005
4086: CURSOR get_independent_tasks(c_visit_id IN NUMBER) IS
4087: select t.visit_task_id
4088: from ahl_visit_tasks_b t,
4089: ahl_visits_b v
4090: where v.visit_id = c_visit_id
4091: and v.visit_id = t.visit_id
4092: and v.status_code = 'PARTIALLY RELEASED'

Line 4126: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

4122: Fetches the route information for updating workorder
4123: description for tasks created from Routes */
4124: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
4125: SELECT ar.route_no||'.'||substr(ar.title,1,(240 - (length(ar.route_no) + 1))) workorder_description
4126: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
4127: WHERE avt.visit_task_id = p_task_id
4128: AND nvl(avt.status_code,'Y') = 'PLANNING'
4129: AND avt.mr_route_id = mrr.mr_route_id
4130: AND mrr.route_id = ar.route_id;

Line 4943: UPDATE AHL_VISIT_TASKS_B

4939:
4940: IF ( p_module_type <> 'CST' ) THEN
4941: IF p_orig_visit_id is null THEN
4942:
4943: UPDATE AHL_VISIT_TASKS_B
4944: SET STATUS_CODE = 'RELEASED',
4945: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
4946: WHERE VISIT_ID = p_visit_id
4947: AND STATUS_CODE = 'PLANNING';

Line 4950: UPDATE AHL_VISIT_TASKS_B

4946: WHERE VISIT_ID = p_visit_id
4947: AND STATUS_CODE = 'PLANNING';
4948:
4949: ELSE
4950: UPDATE AHL_VISIT_TASKS_B
4951: SET STATUS_CODE = 'RELEASED',
4952: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
4953: WHERE VISIT_ID = p_visit_id
4954: AND STATUS_CODE = 'PLANNING'

Line 4956: FROM ahl_visit_tasks_b

4952: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
4953: WHERE VISIT_ID = p_visit_id
4954: AND STATUS_CODE = 'PLANNING'
4955: AND VISIT_TASK_NUMBER in (Select VISIT_TASK_NUMBER
4956: FROM ahl_visit_tasks_b
4957: where visit_id = p_orig_visit_id
4958: AND STATUS_CODE = 'RELEASED');
4959: END IF;
4960: END IF;

Line 5812: FROM ahl_visit_tasks_b

5808: --cursor to fetch the details of the tasks that have been pushe to production
5809: CURSOR c_task_dtls(x_vst_task_id IN NUMBER) IS
5810: SELECT mr_id,visit_id,visit_task_id,status_code,task_type_code,nvl(originating_task_id,0) as originating_task_id,
5811: summary_task_flag, inventory_item_id,item_organization_id,visit_task_number,end_date_time
5812: FROM ahl_visit_tasks_b
5813: WHERE visit_task_id = x_vst_task_id
5814: AND NVL(status_code,'X') in ('PLANNING')
5815: order by visit_task_id;
5816:

Line 5823: FROM ahl_visit_tasks_b

5819: --cursor to fetch the summary task id of the planned/unplanned task
5820: CURSOR c_summary_tsk_dtl (x_originating_tsk_id IN NUMBER) IS
5821: SELECT mr_id,visit_id,visit_task_id,status_code,task_type_code,nvl(originating_task_id,0) as originating_task_id,
5822: summary_task_flag, inventory_item_id,item_organization_id,visit_task_number,end_date_time
5823: FROM ahl_visit_tasks_b
5824: WHERE visit_task_id = x_originating_tsk_id
5825: AND NVL(status_code,'X') in ('PLANNING')
5826: AND task_type_code = 'SUMMARY';
5827:

Line 5847: FROM ahl_visit_tasks_b P,

5843:
5844: -- Get all the Parent Task Dependencies.
5845: CURSOR get_parent_task_dependencies (x_vst_task_id IN NUMBER) IS
5846: SELECT P.visit_task_number , P.visit_task_id
5847: FROM ahl_visit_tasks_b P,
5848: ahl_task_links L
5849: WHERE P.visit_task_id = L.parent_task_id
5850: AND L.visit_task_id = x_vst_task_id;
5851:

Line 5855: FROM ahl_visit_tasks_b C,

5851:
5852: -- Get all the Child Task Dependencies.
5853: CURSOR get_child_task_dependencies (x_vst_task_id IN NUMBER) IS
5854: SELECT C.visit_task_number ,C.visit_task_id
5855: FROM ahl_visit_tasks_b C,
5856: ahl_task_links L
5857: WHERE C.visit_task_id = L.visit_task_id
5858: AND L.parent_task_id = x_vst_task_id;
5859:

Line 5867: FROM ahl_visit_tasks_b

5863: /*cursor to fetch all the child MR's/tasks for the summary MR to ensure all the dtl tasks are pushed to production*/
5864: CURSOR c_dtl_task_sum (x_vst_task_id IN NUMBER) IS
5865: select mr_id,visit_id,visit_task_id,status_code,task_type_code,nvl(originating_task_id,0) as originating_task_id,
5866: summary_task_flag, inventory_item_id,item_organization_id,visit_task_number,end_date_time
5867: FROM ahl_visit_tasks_b
5868: WHERE NVL(status_code,'X') in ('PLANNING')
5869: START WITH visit_task_id = x_vst_task_id
5870: CONNECT BY originating_task_id = PRIOR visit_task_id
5871: order by visit_id,visit_task_id,mr_id;

Line 6256: FROM ahl_visit_tasks_b v, ahl_workorders wo, wip_discrete_jobs wip

6252:
6253: --fetch work order for the task
6254: CURSOR c_task_wo (x_visit_id IN NUMBER,x_visit_task_id IN NUMBER) IS
6255: SELECT v.visit_task_id, wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
6256: FROM ahl_visit_tasks_b v, ahl_workorders wo, wip_discrete_jobs wip
6257: WHERE v.visit_id = x_visit_id
6258: AND v.visit_id = wo.visit_id
6259: AND wo.visit_task_id IS NOT NULL
6260: AND wo.visit_task_id = x_visit_task_id

Line 6268: SELECT summary_task_flag FROM ahl_visit_tasks_b

6264: c_task_wo_rec c_task_wo%ROWTYPE;
6265:
6266: --fetch summary task flag for the task
6267: CURSOR c_fet_sum_task_flg (x_visit_id IN NUMBER, x_visit_task_id IN NUMBER) IS
6268: SELECT summary_task_flag FROM ahl_visit_tasks_b
6269: WHERE visit_task_id = x_visit_task_id;
6270:
6271: --fetch all the tasks in the visit
6272: CURSOR c_all_task_dtl (x_visit_id IN NUMBER) IS

Line 6273: SELECT count(visit_task_id) FROM ahl_visit_tasks_b

6269: WHERE visit_task_id = x_visit_task_id;
6270:
6271: --fetch all the tasks in the visit
6272: CURSOR c_all_task_dtl (x_visit_id IN NUMBER) IS
6273: SELECT count(visit_task_id) FROM ahl_visit_tasks_b
6274: WHERE visit_id = x_visit_id
6275: AND NVL(status_code,'X') IN ('PLANNING');
6276:
6277: --get summary task start, end time

Line 6280: FROM ahl_visit_tasks_b VST

6276:
6277: --get summary task start, end time
6278: CURSOR get_summary_task_times_csr(x_task_id IN NUMBER)IS
6279: SELECT min(start_date_time), max(end_date_time)
6280: FROM ahl_visit_tasks_b VST
6281: START WITH visit_task_id = x_task_id
6282: AND NVL(VST.status_code, 'Y') <> 'DELETED'
6283: CONNECT BY originating_task_id = PRIOR visit_task_id;
6284:

Line 6304: FROM ahl_visit_tasks_b

6300: --Inventory item id and instance id to be defaulted when
6301: --the item and instance are not specified at the header level
6302: CURSOR default_task_inst_dtls(c_task_id IN NUMBER) IS
6303: SELECT inventory_item_id,instance_id
6304: FROM ahl_visit_tasks_b
6305: WHERE visit_task_id = c_task_id;
6306:
6307: def_task_inst_rec default_task_inst_dtls%ROWTYPE;
6308:

Line 6313: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

6309: /*B5758813 - rnahata - fetches the route information for updating workorder
6310: description for tasks created from Routes */
6311: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
6312: SELECT ar.route_no||'.'||substr(ar.title,1,(240 - (length(ar.route_no) + 1))) workorder_description
6313: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
6314: WHERE avt.visit_task_id = p_task_id
6315: and nvl(avt.status_code,'Y') = 'PLANNING'
6316: and avt.mr_route_id = mrr.mr_route_id
6317: and mrr.route_id = ar.route_id;

Line 6339: SELECT * FROM AHL_VISIT_TASKS_B vst

6335: l_sr_mwo_rec c_get_sr_mwo_dtls%ROWTYPE;
6336:
6337: --get SR task details
6338: CURSOR c_get_sr_task_dtls(p_sr_task_id IN NUMBER) IS
6339: SELECT * FROM AHL_VISIT_TASKS_B vst
6340: WHERE vst.TASK_TYPE_CODE = 'SUMMARY'
6341: AND vst.MR_ID IS NULL
6342: AND vst.SERVICE_REQUEST_ID =
6343: (SELECT vst1.SERVICE_REQUEST_ID

Line 6344: FROM ahl_visit_tasks_b vst1

6340: WHERE vst.TASK_TYPE_CODE = 'SUMMARY'
6341: AND vst.MR_ID IS NULL
6342: AND vst.SERVICE_REQUEST_ID =
6343: (SELECT vst1.SERVICE_REQUEST_ID
6344: FROM ahl_visit_tasks_b vst1
6345: WHERE vst1.visit_task_id = p_sr_task_id);
6346:
6347: --check if visit has planned tasks
6348: CURSOR c_visit_has_planned_tasks(p_visit_id IN NUMBER) IS

Line 6349: SELECT 1 FROM ahl_visit_tasks_b

6345: WHERE vst1.visit_task_id = p_sr_task_id);
6346:
6347: --check if visit has planned tasks
6348: CURSOR c_visit_has_planned_tasks(p_visit_id IN NUMBER) IS
6349: SELECT 1 FROM ahl_visit_tasks_b
6350: WHERE visit_id = p_visit_id
6351: AND status_code = 'PLANNING';
6352:
6353: CURSOR c_visit_time_matches_MWO_time(p_visit_id IN NUMBER) IS

Line 6530: UPDATE ahl_visit_tasks_b

6526:
6527: IF (l_manual_summ_task_flag = 'Y') THEN
6528: -- No work order will be created for manually created summary task
6529: -- Just update the task status to Released.
6530: UPDATE ahl_visit_tasks_b
6531: SET status_code = 'RELEASED'
6532: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
6533:
6534: ELSE

Line 6874: UPDATE ahl_visit_tasks_b

6870: END IF; -- Return Status is Success or not
6871: /*B5758813 - rnahata - ends*/
6872:
6873: FOR i IN p_tasks_tbl.FIRST..p_tasks_tbl.LAST LOOP
6874: UPDATE ahl_visit_tasks_b
6875: SET status_code = 'RELEASED'
6876: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
6877: END LOOP;
6878:

Line 7098: WHERE VISIT_TASK_ID = (select visit_task_id from ahl_visit_tasks_b

7094:
7095: CURSOR get_wo(c_visit_id NUMBER, c_unit_effectivity_id NUMBER) IS
7096: SELECT workorder_id
7097: FROM AHL_WORKORDERS
7098: WHERE VISIT_TASK_ID = (select visit_task_id from ahl_visit_tasks_b
7099: where visit_id = c_visit_id
7100: and unit_effectivity_id = c_unit_effectivity_id
7101: AND NVL(status_code, 'Y') <> 'DELETED'
7102: and originating_task_id is null)

Line 7127: FROM ahl_visit_tasks_b VST

7123:
7124: -- get end time of the root task for a given UE
7125: CURSOR get_summary_task_times_csr(x_visit_id IN NUMBER, x_unit_effectivity_id IN NUMBER)IS
7126: SELECT max(end_date_time)
7127: FROM ahl_visit_tasks_b VST
7128: where visit_id = x_visit_id
7129: AND NVL(VST.status_code, 'Y') <> 'DELETED'
7130: START WITH unit_effectivity_id = x_unit_effectivity_id
7131: and originating_task_id is null

Line 7137: from ahl_visit_tasks_b t,

7133:
7134: -- Get all the parent tasks for a given UE that start in a past date
7135: CURSOR get_independent_tasks(x_visit_id IN NUMBER, x_unit_effectivity_id IN NUMBER) IS
7136: select distinct t.visit_task_id
7137: from ahl_visit_tasks_b t,
7138: ahl_visits_b v
7139: where v.visit_id = x_visit_id
7140: and v.visit_id = t.visit_id
7141: and v.status_code = 'PARTIALLY RELEASED'

Line 7409: FROM AHL_VISIT_TASKS_B PARENT,

7405: CURSOR get_tech_dependencies( c_visit_id NUMBER, c_unit_effectivity_id NUMBER )
7406: IS
7407: SELECT distinct PARENT.visit_task_number parent_task_number,
7408: CHILD.visit_task_number child_task_number
7409: FROM AHL_VISIT_TASKS_B PARENT,
7410: AHL_VISIT_TASKS_B CHILD,
7411: AHL_TASK_LINKS LINK
7412: WHERE PARENT.visit_task_id = LINK.parent_task_id
7413: AND CHILD.visit_task_id = LINK.visit_task_id

Line 7410: AHL_VISIT_TASKS_B CHILD,

7406: IS
7407: SELECT distinct PARENT.visit_task_number parent_task_number,
7408: CHILD.visit_task_number child_task_number
7409: FROM AHL_VISIT_TASKS_B PARENT,
7410: AHL_VISIT_TASKS_B CHILD,
7411: AHL_TASK_LINKS LINK
7412: WHERE PARENT.visit_task_id = LINK.parent_task_id
7413: AND CHILD.visit_task_id = LINK.visit_task_id
7414: AND NVL(PARENT.STATUS_CODE,'X') = 'PLANNING' --Srini Bug #4075702

Line 7417: AND PARENT.visit_task_id in (select visit_task_id from ahl_visit_tasks_b

7413: AND CHILD.visit_task_id = LINK.visit_task_id
7414: AND NVL(PARENT.STATUS_CODE,'X') = 'PLANNING' --Srini Bug #4075702
7415: AND PARENT.visit_id = c_visit_id
7416: AND CHILD.visit_id = c_visit_id
7417: AND PARENT.visit_task_id in (select visit_task_id from ahl_visit_tasks_b
7418: where visit_id = c_visit_id
7419: /*NR-MR Changes - For SR's created from non-routines have the originating wo as their originating task, hence they are not null.*/
7420: START WITH unit_effectivity_id = c_unit_effectivity_id
7421: AND (( originating_task_id is null AND 'SR' <> p_module_type)

Line 7425: AND CHILD.visit_task_id in ( select visit_task_id from ahl_visit_tasks_b

7421: AND (( originating_task_id is null AND 'SR' <> p_module_type)
7422: OR ( originating_task_id is not null AND 'SR' = p_module_type
7423: and service_request_id is not null))
7424: CONNECT BY originating_task_id = PRIOR visit_task_id)
7425: AND CHILD.visit_task_id in ( select visit_task_id from ahl_visit_tasks_b
7426: where visit_id = c_visit_id
7427: /*NR-MR Changes - For SR's created from non-routines have the originating wo as their originating task, hence they are not null.*/
7428: START WITH unit_effectivity_id = c_unit_effectivity_id
7429: AND (( originating_task_id is null AND 'SR' <> p_module_type)

Line 7496: FROM AHL_VISIT_TASKS_B

7492: task_type_code,
7493: service_request_id,
7494: mr_id,
7495: NVL(originating_task_id, -1)
7496: FROM AHL_VISIT_TASKS_B
7497: WHERE visit_id = c_visit_id
7498: AND task_type_code='SUMMARY'
7499: AND NVL(STATUS_CODE, 'X') = 'PLANNING'
7500: /*NR-MR Changes - For SR's created from non-routines have the originating wo as their originating task, hence they are not null.*/

Line 7528: FROM AHL_VISIT_TASKS_B

7524: -- Get all the Tasks associated to a MR.
7525: CURSOR get_tasks_for_mr( c_visit_id NUMBER, c_mr_task_id NUMBER )
7526: IS
7527: SELECT visit_task_number, visit_task_id
7528: FROM AHL_VISIT_TASKS_B
7529: WHERE visit_id = c_visit_id
7530: AND originating_task_id = c_mr_task_id
7531: AND task_type_code <> 'SUMMARY'
7532: AND NVL(STATUS_CODE, 'X') = 'PLANNING';

Line 7766: SELECT count(*) FROM AHL_VISIT_TASKS_B

7762: c_task_rec c_task%ROWTYPE;
7763:
7764: -- To get the count of all the tasks for the given UE
7765: CURSOR c_task_ct (x_visit_id IN NUMBER, x_unit_effectivity_id IN NUMBER) IS
7766: SELECT count(*) FROM AHL_VISIT_TASKS_B
7767: WHERE VISIT_ID = x_visit_id
7768: AND NVL( STATUS_CODE, 'X' ) = 'PLANNING'
7769: /*NR-MR Changes*/
7770: START WITH unit_effectivity_id = x_unit_effectivity_id

Line 7792: FROM ahl_visit_tasks_b

7788:
7789: CURSOR c_visit_task_exists(x_visit_id IN NUMBER)
7790: IS
7791: SELECT 'x'
7792: FROM ahl_visit_tasks_b
7793: WHERE visit_id = x_visit_id
7794: AND STATUS_CODE = 'PLANNING';
7795:
7796:

Line 7822: FROM ahl_routes_vl ar, ahl_visit_tasks_b avt,

7818: -- SATHAPLI::Bug 5758813, 04-Jun-2008
7819: -- Cursor to get the required format for the workorder description, given a visit task.
7820: CURSOR get_wo_dtls_for_mrtasks_cur (c_visit_task_id IN NUMBER) IS
7821: SELECT ar.route_no||'.'||SUBSTR(ar.title, 1, (240 - (LENGTH(ar.route_no) + 1))) workorder_description
7822: FROM ahl_routes_vl ar, ahl_visit_tasks_b avt,
7823: ahl_mr_routes mrr
7824: WHERE avt.visit_task_id = c_visit_task_id
7825: AND NVL(avt.status_code, 'X') = 'PLANNING'
7826: AND avt.mr_route_id = mrr.mr_route_id

Line 8074: UPDATE AHL_VISIT_TASKS_B

8070: OPEN c_task(p_visit_id, p_unit_effectivity_id);
8071: FETCH c_task INTO c_task_rec;
8072: WHILE c_task%FOUND
8073: LOOP
8074: UPDATE AHL_VISIT_TASKS_B
8075: SET STATUS_CODE = 'RELEASED',
8076: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
8077: WHERE VISIT_ID = p_visit_id
8078: AND VISIT_TASK_ID = c_task_rec.visit_task_id

Line 8417: UPDATE AHL_VISIT_TASKS_B SET PROJECT_TASK_ID = l_task_id,

8413:
8414: IF l_return_status = 'S' THEN
8415: /*NR-MR Changes - added this to ensure that duplicates are not passed*/
8416: l_curr_task_id := c_task_rec.visit_task_id;
8417: UPDATE AHL_VISIT_TASKS_B SET PROJECT_TASK_ID = l_task_id,
8418: OBJECT_VERSION_NUMBER = c_task_rec.object_version_number + 1
8419: WHERE VISIT_TASK_ID = c_task_rec.visit_task_id;
8420: END IF;
8421: ELSIF l_project_tsk_flag = 'N' AND l_proj_ref_flag = 'Y' THEN

Line 8512: FROM ahl_visit_tasks_b

8508: IS
8509: -- get all tasks in planning status for a visit
8510: CURSOR get_visit_tasks_cur(c_visit_id NUMBER) IS
8511: SELECT visit_task_id
8512: FROM ahl_visit_tasks_b
8513: WHERE visit_id = c_visit_id
8514: AND NVL(status_code,'X') = 'PLANNING';
8515:
8516: -- Declare local variables

Line 8873: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,

8869: --fetches project task id, the task start and end date of visit task
8870: CURSOR get_task_dates_cur(p_wo_id IN NUMBER) IS
8871: SELECT AVT.PROJECT_TASK_ID, AVT.START_DATE_TIME, AVT.END_DATE_TIME,
8872: PAT.DESCRIPTION -- Pass the old description back again
8873: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,
8874: PA_TASKS PAT
8875: WHERE WO.VISIT_TASK_ID = AVT.VISIT_TASK_ID AND
8876: WO.WORKORDER_ID = p_wo_id AND
8877: PAT.TASK_ID (+) = AVT.PROJECT_TASK_ID;

Line 9115: FROM ahl_visit_tasks_b

9111: -- yazhou Jul-20-2005 start
9112: CURSOR c_visit_task_exists(x_visit_id IN NUMBER)
9113: IS
9114: SELECT 'x'
9115: FROM ahl_visit_tasks_b
9116: WHERE visit_id = x_visit_id
9117: AND STATUS_CODE = 'PLANNING';
9118:
9119: CURSOR c_get_wo_details(x_visit_id IN NUMBER)

Line 9462: UPDATE AHL_VISIT_TASKS_B

9458: p_x_task_Tbl(i).workorder_id := c_chk_job_rec.workorder_id;
9459:
9460: --yazhou Jul-18-2005 start
9461: -- Fix for bug # 4078095
9462: UPDATE AHL_VISIT_TASKS_B
9463: SET STATUS_CODE = 'RELEASED',
9464: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
9465: WHERE VISIT_TASK_ID = p_x_task_Tbl(i).visit_task_id
9466: AND STATUS_CODE = 'PLANNING';