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_TASK_LINKS

Line 3803: AHL_TASK_LINKS LINK

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'
3807: AND NVL(CHILD.STATUS_CODE,'X') = 'PLANNING'

Line 3900: AHL_TASK_LINKS LINK

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
3904: AND PARENT.visit_id = c_visit_id

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

4092: and v.status_code = 'PARTIALLY RELEASED'
4093: and t.start_date_time < SYSDATE
4094: and t.status_code ='PLANNING'
4095: and t.task_type_code <>'SUMMARY'
4096: and (not exists (select 1 from ahl_task_links l0
4097: where l0.parent_task_id = t.visit_task_id
4098: or l0.visit_task_id = t.visit_task_id)
4099: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
4100: where not exists (select l2.visit_task_id from ahl_task_links l2

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

4095: and t.task_type_code <>'SUMMARY'
4096: and (not exists (select 1 from ahl_task_links l0
4097: where l0.parent_task_id = t.visit_task_id
4098: or l0.visit_task_id = t.visit_task_id)
4099: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
4100: where not exists (select l2.visit_task_id from ahl_task_links l2
4101: where l2.visit_task_id = l1.parent_task_id)));
4102: --Modified by Srini Nov08, 2004 to create master workorder not having an asset
4103:

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

4096: and (not exists (select 1 from ahl_task_links l0
4097: where l0.parent_task_id = t.visit_task_id
4098: or l0.visit_task_id = t.visit_task_id)
4099: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
4100: where not exists (select l2.visit_task_id from ahl_task_links l2
4101: where l2.visit_task_id = l1.parent_task_id)));
4102: --Modified by Srini Nov08, 2004 to create master workorder not having an asset
4103:
4104: -- anraj: Modified the cursor definition to exclude the tasks in status DELETED

Line 5848: ahl_task_links L

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:
5852: -- Get all the Child Task Dependencies.

Line 5856: ahl_task_links L

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:
5860: c_par_tech_dep_rec get_parent_task_dependencies%ROWTYPE;

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

7141: and v.status_code = 'PARTIALLY RELEASED'
7142: and t.start_date_time < SYSDATE
7143: and t.status_code ='PLANNING'
7144: and t.task_type_code <>'SUMMARY'
7145: and (not exists (select 1 from ahl_task_links l0
7146: where l0.parent_task_id = t.visit_task_id
7147: or l0.visit_task_id = t.visit_task_id )
7148: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
7149: where not exists (select l2.visit_task_id from ahl_task_links l2

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

7144: and t.task_type_code <>'SUMMARY'
7145: and (not exists (select 1 from ahl_task_links l0
7146: where l0.parent_task_id = t.visit_task_id
7147: or l0.visit_task_id = t.visit_task_id )
7148: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
7149: where not exists (select l2.visit_task_id from ahl_task_links l2
7150: where l2.visit_task_id = l1.parent_task_id)))
7151: /*NR-MR Changes - For SR's created from non-routines have the originating wo as their originating task, hence they are not null.*/
7152: START WITH t.unit_effectivity_id = x_unit_effectivity_id

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

7145: and (not exists (select 1 from ahl_task_links l0
7146: where l0.parent_task_id = t.visit_task_id
7147: or l0.visit_task_id = t.visit_task_id )
7148: or t.visit_task_id in (select l1.parent_task_id from ahl_task_links l1
7149: where not exists (select l2.visit_task_id from ahl_task_links l2
7150: where l2.visit_task_id = l1.parent_task_id)))
7151: /*NR-MR Changes - For SR's created from non-routines have the originating wo as their originating task, hence they are not null.*/
7152: START WITH t.unit_effectivity_id = x_unit_effectivity_id
7153: AND (( t.originating_task_id is null AND 'SR' <> p_module_type)

Line 7411: AHL_TASK_LINKS LINK

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
7415: AND PARENT.visit_id = c_visit_id