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_ORDER_HOLDS

Line 115: FROM OE_ORDER_HOLDS h,

111:
112: --added for BUG#9728597 Start
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

Line 158: FROM OE_ORDER_HOLDS h,

154: --commented for BUG#9728597
155: /*
156: SELECT /* MOAC_SQL_CHANGE */ /*NVL(MAX(H.HOLD_RELEASE_ID),0)
157: INTO l_hold_release_id
158: FROM OE_ORDER_HOLDS h,
159: OE_HOLD_SOURCES_ALL s
160: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
161: AND H.HEADER_ID = p_header_id
162: AND H.LINE_ID IS NULL

Line 2392: FROM OE_ORDER_HOLDS_all h,

2388: -- To retrieve the credit profile level of the latest manually released hold.
2389: CURSOR released_hold
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