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_PRD_DISPOSITION_PVT dependencies on WIP_SCHED_RELATIONSHIPS

Line 1016: FROM wip_sched_relationships

1012: FROM ahl_workorders
1013: WHERE master_workorder_flag = 'N'
1014: AND wip_entity_id IN
1015: (SELECT child_object_id
1016: FROM wip_sched_relationships
1017: START WITH parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = c_nr_wo_id)
1018: CONNECT BY parent_object_id = PRIOR child_object_id
1019: AND parent_object_type_id = PRIOR child_object_type_id
1020: AND relationship_type = 1

Line 1578: FROM wip_sched_relationships

1574: FROM ahl_workorders
1575: WHERE master_workorder_flag = 'N'
1576: AND wip_entity_id IN
1577: (SELECT child_object_id
1578: FROM wip_sched_relationships
1579: START WITH parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = c_nr_wo_id)
1580: CONNECT BY parent_object_id = PRIOR child_object_id
1581: AND parent_object_type_id = PRIOR child_object_type_id
1582: AND relationship_type = 1

Line 2625: FROM wip_sched_relationships

2621: FROM ahl_workorders
2622: WHERE master_workorder_flag = 'N'
2623: AND wip_entity_id IN
2624: (SELECT child_object_id
2625: FROM wip_sched_relationships
2626: START WITH parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = c_nr_wo_id)
2627: CONNECT BY parent_object_id = PRIOR child_object_id
2628: AND parent_object_type_id = PRIOR child_object_type_id
2629: AND relationship_type = 1