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.OE_VERIFY_PAYMENT_PUB dependencies on OE_HOLD_RELEASES

Line 240: oe_hold_releases ohr

236: cursor released_hold is
237: SELECT ohr.HOLD_RELEASE_ID
238: FROM OE_ORDER_HOLDS h,
239: OE_HOLD_SOURCES s,
240: oe_hold_releases ohr
241: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
242: AND H.HEADER_ID = p_header_id
243: AND H.LINE_ID IS NULL
244: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 256: oe_hold_releases ohr

252: cursor released_hold_line is
253: SELECT ohr.HOLD_RELEASE_ID
254: FROM OE_ORDER_HOLDS h,
255: OE_HOLD_SOURCES s,
256: oe_hold_releases ohr
257: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
258: AND H.HEADER_ID = p_header_id
259: AND H.LINE_ID = p_line_id
260: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 361: FROM OE_HOLD_RELEASES

357: IF l_released_rec_exists = 'Y' THEN
358: BEGIN
359: select 'Y'
360: into l_manual_hold_exists
361: FROM OE_HOLD_RELEASES
362: WHERE HOLD_RELEASE_ID = l_hold_release_id
363: AND RELEASE_REASON_CODE <> 'PASS_CREDIT'
364: AND CREATED_BY <> 1;
365: EXCEPTION