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

Line 117: oe_hold_releases ohr

113: cursor released_hold is
114: SELECT ohr.HOLD_RELEASE_ID
115: FROM OE_ORDER_HOLDS h,
116: OE_HOLD_SOURCES_ALL s,
117: oe_hold_releases ohr
118: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
119: AND H.HEADER_ID = p_header_id
120: AND H.LINE_ID IS NULL
121: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 198: FROM OE_HOLD_RELEASES

194: 'Y',CREATION_DATE
195: INTO
196: l_manual_hold_exists
197: , l_release_date
198: FROM OE_HOLD_RELEASES
199: WHERE HOLD_RELEASE_ID = l_hold_release_id
200: AND RELEASE_REASON_CODE <> 'PASS_CREDIT'
201: AND CREATED_BY <> 1;
202:

Line 2394: oe_hold_releases ohr

2390: IS
2391: SELECT Credit_Profile_Level
2392: FROM OE_ORDER_HOLDS_all h,
2393: OE_HOLD_SOURCES_ALL s,
2394: oe_hold_releases ohr
2395: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
2396: AND H.HEADER_ID = p_header_rec.header_id
2397: AND H.LINE_ID IS NULL
2398: AND H.HOLD_RELEASE_ID IS NOT NULL