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_RSV_RESERVATIONS_PVT dependencies on AHL_WORKORDERS

Line 1236: FROM ahl_workorders awo

1232: OR
1233: ( avtl.status_code='RELEASED'
1234: AND
1235: EXISTS ( SELECT awo.visit_task_id
1236: FROM ahl_workorders awo
1237: WHERE avtl.visit_task_id = awo.visit_task_id
1238: AND (awo.status_code = '1' OR awo.status_code='3') -- 1:Unreleased,3:Released
1239: )
1240: )

Line 1620: FROM ahl_workorders aw

1616:
1617: CURSOR get_wip_dtls_csr (c_visit_task_ID IN NUMBER)
1618: IS
1619: SELECT aw.wip_entity_id
1620: FROM ahl_workorders aw
1621: WHERE aw.status_code in ('1','3') -- 1:Unreleased,3:Released
1622: AND aw.visit_task_id = c_visit_task_id;
1623:
1624: BEGIN

Line 2294: FROM ahl_workorders aw

2290: -- Cursor to get the WIP details
2291: CURSOR get_wip_dtls_csr (c_visit_task_ID IN NUMBER)
2292: IS
2293: SELECT aw.wip_entity_id
2294: FROM ahl_workorders aw
2295: WHERE aw.status_code in ('1','3') -- 1:Unreleased,3:Released
2296: AND aw.visit_task_id = c_visit_task_id;
2297: l_get_wip_dtls_rec get_wip_dtls_csr%ROWTYPE;
2298: