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_MARGIN_PVT dependencies on OE_HOLD_RELEASES

Line 130: oe_hold_releases ohr

126: cursor released_hold is
127: SELECT ohr.HOLD_RELEASE_ID
128: FROM OE_ORDER_HOLDS h,
129: OE_HOLD_SOURCES s,
130: oe_hold_releases ohr
131: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
132: AND H.HEADER_ID = p_header_id
133: AND H.LINE_ID IS NULL
134: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 146: oe_hold_releases ohr

142: cursor released_hold_line is
143: SELECT ohr.HOLD_RELEASE_ID
144: FROM OE_ORDER_HOLDS h,
145: OE_HOLD_SOURCES s,
146: oe_hold_releases ohr
147: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
148: AND H.HEADER_ID = p_header_id
149: AND H.LINE_ID = p_line_id
150: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 248: FROM OE_HOLD_RELEASES

244: IF l_released_rec_exists = 'Y' THEN
245: BEGIN
246: select 'Y'
247: into l_manual_hold_exists
248: FROM OE_HOLD_RELEASES
249: WHERE HOLD_RELEASE_ID = l_hold_release_id
250: AND RELEASE_REASON_CODE <> 'PASS_MIN_MARGIN'
251: AND CREATED_BY <> 1;
252: EXCEPTION