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_BIS dependencies on GL_CURRENCY_API

Line 14: decode(gl_currency_api.rate_exists(line_currency,p_currency,

10: BEGIN
11:
12: /*
13: select sum(
14: decode(gl_currency_api.rate_exists(line_currency,p_currency,
15: trunc(sysdate),'Corporate'),
16: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
17: trunc(sysdate),'Corporate'),
18: 1) *

Line 16: 'Y', gl_currency_API.get_rate(line_currency, p_currency,

12: /*
13: select sum(
14: decode(gl_currency_api.rate_exists(line_currency,p_currency,
15: trunc(sysdate),'Corporate'),
16: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
17: trunc(sysdate),'Corporate'),
18: 1) *
19: shipment_value)
20: into p_daily_value

Line 129: decode(gl_currency_api.rate_exists(line_currency,p_currency,

125:
126: cursor cust is
127: select customer_id,
128: sum(
129: decode(gl_currency_api.rate_exists(line_currency,p_currency,
130: trunc(sysdate),'Corporate'),
131: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
132: trunc(sysdate),'Corporate'),
133: 1) *

Line 131: 'Y', gl_currency_API.get_rate(line_currency, p_currency,

127: select customer_id,
128: sum(
129: decode(gl_currency_api.rate_exists(line_currency,p_currency,
130: trunc(sysdate),'Corporate'),
131: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
132: trunc(sysdate),'Corporate'),
133: 1) *
134: (ordered_quantity - cancelled_quantity) *
135: unit_selling_price) sales

Line 184: decode(gl_currency_api.rate_exists(line_currency,p_currency,

180:
181: update oe_bis_top_customers c
182: set period_bookings =
183: (select sum(
184: decode(gl_currency_api.rate_exists(line_currency,p_currency,
185: trunc(sysdate),'Corporate'),
186: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
187: trunc(sysdate),'Corporate'),
188: 1) *

Line 186: 'Y', gl_currency_API.get_rate(line_currency, p_currency,

182: set period_bookings =
183: (select sum(
184: decode(gl_currency_api.rate_exists(line_currency,p_currency,
185: trunc(sysdate),'Corporate'),
186: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
187: trunc(sysdate),'Corporate'),
188: 1) *
189: line_selling_price)
190: from oe_bis_bookings_v

Line 198: decode(gl_currency_api.rate_exists(line_currency,p_currency,

194:
195: update oe_bis_top_customers c set
196: period_billings =
197: (select sum(
198: decode(gl_currency_api.rate_exists(line_currency,p_currency,
199: trunc(sysdate),'Corporate'),
200: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
201: trunc(sysdate),'Corporate'),
202: 1) *

Line 200: 'Y', gl_currency_API.get_rate(line_currency, p_currency,

196: period_billings =
197: (select sum(
198: decode(gl_currency_api.rate_exists(line_currency,p_currency,
199: trunc(sysdate),'Corporate'),
200: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
201: trunc(sysdate),'Corporate'),
202: 1) *
203: invoiced_selling_price)
204: from oe_bis_billings_v

Line 212: decode(gl_currency_api.rate_exists(line_currency,p_currency,

208:
209: update oe_bis_top_customers c set
210: current_backlog =
211: (select sum(
212: decode(gl_currency_api.rate_exists(line_currency,p_currency,
213: trunc(sysdate),'Corporate'),
214: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
215: trunc(sysdate),'Corporate'),
216: 1) *

Line 214: 'Y', gl_currency_API.get_rate(line_currency, p_currency,

210: current_backlog =
211: (select sum(
212: decode(gl_currency_api.rate_exists(line_currency,p_currency,
213: trunc(sysdate),'Corporate'),
214: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
215: trunc(sysdate),'Corporate'),
216: 1) *
217: bl_selling_price)
218: from oe_bis_backlog_v

Line 295: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,

291:
292: update oe_bis_bbb_info bbb
293: set bookings =
294: (select sum(
295: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,
296: trunc(sysdate),'Corporate'),
297: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
298: trunc(sysdate),'Corporate'),
299: 1) *

Line 297: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,

293: set bookings =
294: (select sum(
295: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,
296: trunc(sysdate),'Corporate'),
297: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
298: trunc(sysdate),'Corporate'),
299: 1) *
300: line_selling_price)
301: from oe_bis_bookings_v

Line 308: decode(gl_currency_api.rate_exists(line_currency,bbb.currency_code,

304:
305: update oe_bis_bbb_info bbb set
306: billings =
307: (select sum(
308: decode(gl_currency_api.rate_exists(line_currency,bbb.currency_code,
309: trunc(sysdate),'Corporate'),
310: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
311: trunc(sysdate),'Corporate'),
312: 1) *

Line 310: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,

306: billings =
307: (select sum(
308: decode(gl_currency_api.rate_exists(line_currency,bbb.currency_code,
309: trunc(sysdate),'Corporate'),
310: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
311: trunc(sysdate),'Corporate'),
312: 1) *
313: invoiced_selling_price)
314: from oe_bis_billings_v

Line 321: decode(gl_currency_api.rate_exists(currency_code,bbb.currency_code,

317:
318: update oe_bis_bbb_info bbb set
319: adjustments =
320: (select sum(
321: decode(gl_currency_api.rate_exists(currency_code,bbb.currency_code,
322: trunc(sysdate),'Corporate'),
323: 'Y', gl_currency_API.get_rate(currency_code, bbb.currency_code,
324: trunc(sysdate),'Corporate'),
325: 1) *

Line 323: 'Y', gl_currency_API.get_rate(currency_code, bbb.currency_code,

319: adjustments =
320: (select sum(
321: decode(gl_currency_api.rate_exists(currency_code,bbb.currency_code,
322: trunc(sysdate),'Corporate'),
323: 'Y', gl_currency_API.get_rate(currency_code, bbb.currency_code,
324: trunc(sysdate),'Corporate'),
325: 1) *
326: selling_price * cancelled_quantity)
327: from oe_bis_cancelled_bookings_v

Line 335: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,

331:
332: update oe_bis_bbb_info bbb set
333: closing_backlog =
334: (select sum(
335: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,
336: trunc(sysdate),'Corporate'),
337: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
338: trunc(sysdate),'Corporate'),
339: 1) *

Line 337: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,

333: closing_backlog =
334: (select sum(
335: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,
336: trunc(sysdate),'Corporate'),
337: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
338: trunc(sysdate),'Corporate'),
339: 1) *
340: bl_selling_price)
341: from oe_bis_backlog_v