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_LTP_REQST_MATRL_PVT dependencies on WIP_DISCRETE_JOBS

Line 3593: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr

3589:
3590: CURSOR get_workorder_detls (c_task_id IN NUMBER)
3591: IS
3592: SELECT wip.scheduled_start_date, wo.workorder_id, opr.operation_sequence_num, opr.workorder_operation_id
3593: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr
3594: WHERE wo.visit_task_id = c_task_id
3595: AND wo.wip_entity_id = wip.wip_entity_id
3596: AND opr.workorder_id = wo.workorder_id;
3597:

Line 4054: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr

4050:
4051: CURSOR get_workorder_detls (c_task_id IN NUMBER)
4052: IS
4053: SELECT wip.scheduled_start_date, wo.workorder_id, opr.operation_sequence_num, opr.workorder_operation_id
4054: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr
4055: WHERE wo.visit_task_id = c_task_id
4056: AND wo.wip_entity_id = wip.wip_entity_id
4057: AND opr.workorder_id = wo.workorder_id;
4058:

Line 4386: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr

4382: -- Cursor to workorder details of the default stage task
4383: CURSOR get_workorder_detls (c_task_id IN NUMBER)
4384: IS
4385: SELECT wip.scheduled_start_date, wo.workorder_id, opr.operation_sequence_num, opr.workorder_operation_id, wo.visit_id
4386: FROM ahl_workorders wo, wip_discrete_jobs wip, ahl_workorder_operations opr
4387: WHERE wo.visit_task_id = c_task_id
4388: AND wo.wip_entity_id = wip.wip_entity_id
4389: AND opr.workorder_id = wo.workorder_id;
4390: