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_ORDER_HOLDS

Line 128: FROM OE_ORDER_HOLDS h,

124:
125: --added for BUG#9728597 Start
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

Line 144: FROM OE_ORDER_HOLDS h,

140: ORDER BY ohr.creation_date DESC;
141:
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

Line 169: FROM OE_ORDER_HOLDS h,

165: BEGIN
166: --commented for BUG#9728597
167: /* SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
168: INTO l_hold_release_id
169: FROM OE_ORDER_HOLDS h,
170: OE_HOLD_SOURCES s
171: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
172: AND H.HEADER_ID = p_header_id
173: AND H.LINE_ID IS NULL

Line 208: FROM OE_ORDER_HOLDS h,

204: BEGIN
205: --commented for BUG#9728597
206: /*SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
207: INTO l_hold_release_id
208: FROM OE_ORDER_HOLDS h,
209: OE_HOLD_SOURCES s
210: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
211: AND H.HEADER_ID = p_header_id
212: AND H.LINE_ID = p_line_id