APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_TASK_LINKS

Line 5919: AHL_TASK_LINKS LINK

5915: SELECT PARENT.visit_task_number parent_task_number,
5916: CHILD.visit_task_number child_task_number
5917: FROM AHL_VISIT_TASKS_B PARENT,
5918: AHL_VISIT_TASKS_B CHILD,
5919: AHL_TASK_LINKS LINK
5920: WHERE PARENT.visit_task_id = LINK.parent_task_id
5921: AND CHILD.visit_task_id = LINK.visit_task_id
5922: AND NVL(PARENT.STATUS_CODE,'X') = 'PLANNING'
5923: AND NVL(CHILD.STATUS_CODE,'X') = 'PLANNING'

Line 6018: AHL_TASK_LINKS LINK

6014: SELECT PARENT.visit_task_number parent_task_number,
6015: CHILD.visit_task_number child_task_number
6016: FROM AHL_VISIT_TASKS_B PARENT,
6017: AHL_VISIT_TASKS_B CHILD,
6018: AHL_TASK_LINKS LINK
6019: WHERE PARENT.visit_task_id = LINK.parent_task_id
6020: AND CHILD.visit_task_id = LINK.visit_task_id
6021: AND NVL(PARENT.STATUS_CODE,'X') = 'PLANNING' --Srini Bug #4075702
6022: AND PARENT.visit_id = c_visit_id

Line 6237: and (not exists (select 1 from ahl_task_links l0

6233: and t.status_code ='PLANNING'
6234: and t.task_type_code <>'SUMMARY'
6235: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Adjust task times only if past task start date is null
6236: and t.past_task_start_date IS NULL
6237: and (not exists (select 1 from ahl_task_links l0
6238: where l0.parent_task_id = t.visit_task_id
6239: or l0.visit_task_id = t.visit_task_id)
6240: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
6241: where not exists (select l2.visit_task_id from ahl_task_links l2

Line 6240: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1

6236: and t.past_task_start_date IS NULL
6237: and (not exists (select 1 from ahl_task_links l0
6238: where l0.parent_task_id = t.visit_task_id
6239: or l0.visit_task_id = t.visit_task_id)
6240: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
6241: where not exists (select l2.visit_task_id from ahl_task_links l2
6242: where l2.visit_task_id = l1.parent_task_id)));
6243: --Modified by Srini Nov08, 2004 to create master workorder not having an asset
6244:

Line 6241: where not exists (select l2.visit_task_id from ahl_task_links l2

6237: and (not exists (select 1 from ahl_task_links l0
6238: where l0.parent_task_id = t.visit_task_id
6239: or l0.visit_task_id = t.visit_task_id)
6240: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
6241: where not exists (select l2.visit_task_id from ahl_task_links l2
6242: where l2.visit_task_id = l1.parent_task_id)));
6243: --Modified by Srini Nov08, 2004 to create master workorder not having an asset
6244:
6245: -- anraj: Modified the cursor definition to exclude the tasks in status DELETED

Line 8766: ahl_task_links L

8762: -- Get all the Parent Task Dependencies.
8763: CURSOR get_parent_task_dependencies (x_vst_task_id IN NUMBER) IS
8764: SELECT P.visit_task_number , P.visit_task_id
8765: FROM ahl_visit_tasks_b P,
8766: ahl_task_links L
8767: WHERE P.visit_task_id = L.parent_task_id
8768: AND L.visit_task_id = x_vst_task_id;
8769:
8770: -- Get all the Child Task Dependencies.

Line 8774: ahl_task_links L

8770: -- Get all the Child Task Dependencies.
8771: CURSOR get_child_task_dependencies (x_vst_task_id IN NUMBER) IS
8772: SELECT C.visit_task_number ,C.visit_task_id
8773: FROM ahl_visit_tasks_b C,
8774: ahl_task_links L
8775: WHERE C.visit_task_id = L.visit_task_id
8776: AND L.parent_task_id = x_vst_task_id;
8777:
8778: c_par_tech_dep_rec get_parent_task_dependencies%ROWTYPE;

Line 10469: and (not exists (select 1 from ahl_task_links l0

10465: and t.status_code ='PLANNING'
10466: and t.task_type_code <>'SUMMARY'
10467: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Adjust task times only if past task start date is null
10468: and t.past_task_start_date IS NULL
10469: and (not exists (select 1 from ahl_task_links l0
10470: where l0.parent_task_id = t.visit_task_id
10471: or l0.visit_task_id = t.visit_task_id )
10472: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
10473: where not exists (select l2.visit_task_id from ahl_task_links l2

Line 10472: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1

10468: and t.past_task_start_date IS NULL
10469: and (not exists (select 1 from ahl_task_links l0
10470: where l0.parent_task_id = t.visit_task_id
10471: or l0.visit_task_id = t.visit_task_id )
10472: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
10473: where not exists (select l2.visit_task_id from ahl_task_links l2
10474: where l2.visit_task_id = l1.parent_task_id)))
10475: /*NR-MR Changes - For SR's created from non-routines have the originating wo as their originating task, hence they are not null.*/
10476: START WITH t.unit_effectivity_id = x_unit_effectivity_id

Line 10473: where not exists (select l2.visit_task_id from ahl_task_links l2

10469: and (not exists (select 1 from ahl_task_links l0
10470: where l0.parent_task_id = t.visit_task_id
10471: or l0.visit_task_id = t.visit_task_id )
10472: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
10473: where not exists (select l2.visit_task_id from ahl_task_links l2
10474: where l2.visit_task_id = l1.parent_task_id)))
10475: /*NR-MR Changes - For SR's created from non-routines have the originating wo as their originating task, hence they are not null.*/
10476: START WITH t.unit_effectivity_id = x_unit_effectivity_id
10477: AND (( t.originating_task_id is null AND 'SR' <> p_module_type)

Line 10793: AHL_TASK_LINKS LINK

10789: SELECT distinct PARENT.visit_task_number parent_task_number,
10790: CHILD.visit_task_number child_task_number
10791: FROM AHL_VISIT_TASKS_B PARENT,
10792: AHL_VISIT_TASKS_B CHILD,
10793: AHL_TASK_LINKS LINK
10794: WHERE PARENT.visit_task_id = LINK.parent_task_id
10795: AND CHILD.visit_task_id = LINK.visit_task_id
10796: AND NVL(PARENT.STATUS_CODE,'X') = 'PLANNING' --Srini Bug #4075702
10797: AND PARENT.visit_id = c_visit_id