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_SOURCES

Line 129: OE_HOLD_SOURCES s,

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
133: AND H.LINE_ID IS NULL

Line 145: OE_HOLD_SOURCES s,

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
149: AND H.LINE_ID = p_line_id

Line 170: OE_HOLD_SOURCES s

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
174: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 209: OE_HOLD_SOURCES s

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
213: AND H.HOLD_RELEASE_ID IS NOT NULL