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.POA_SUPPLIER_CONSOLIDATION_PK dependencies on GL_CURRENCY_API

Line 70: DECODE(gl_currency_api.rate_exists(psp.currency_code,

66: --
67: CURSOR c_cons_supplier IS
68: SELECT psp.po_shipment_id,
69: NVL(psp.purchase_price, 0) *
70: DECODE(gl_currency_api.rate_exists(psp.currency_code,
71: p_currency_code, psp.rate_date,
72: psp.rate_type),
73: 'Y',
74: gl_currency_api.get_rate(psp.currency_code, p_currency_code,

Line 74: gl_currency_api.get_rate(psp.currency_code, p_currency_code,

70: DECODE(gl_currency_api.rate_exists(psp.currency_code,
71: p_currency_code, psp.rate_date,
72: psp.rate_type),
73: 'Y',
74: gl_currency_api.get_rate(psp.currency_code, p_currency_code,
75: psp.rate_date, psp.rate_type),
76: 1),
77: NVL(psp.quantity_purchased, 0), NVL(psp.quantity_ordered, 0),
78: NVL(psp.quantity_received, 0), NVL(psp.quantity_rejected, 0),

Line 92: DECODE(gl_currency_api.rate_exists(psp.currency_code,

88:
89: CURSOR c_cons_supplier_glb_sec IS
90: SELECT psp.po_shipment_id,
91: NVL(psp.purchase_price, 0) *
92: DECODE(gl_currency_api.rate_exists(psp.currency_code,
93: p_currency_code, psp.rate_date,
94: psp.rate_type),
95: 'Y',
96: gl_currency_api.get_rate(psp.currency_code, p_currency_code,

Line 96: gl_currency_api.get_rate(psp.currency_code, p_currency_code,

92: DECODE(gl_currency_api.rate_exists(psp.currency_code,
93: p_currency_code, psp.rate_date,
94: psp.rate_type),
95: 'Y',
96: gl_currency_api.get_rate(psp.currency_code, p_currency_code,
97: psp.rate_date, psp.rate_type),
98: 1),
99: NVL(psp.quantity_purchased, 0), NVL(psp.quantity_ordered, 0),
100: NVL(psp.quantity_received, 0), NVL(psp.quantity_rejected, 0),

Line 124: DECODE(gl_currency_api.rate_exists(phc2.currency_code,

120: -- Get the blanket price for the preferred supplier
121: --
122: CURSOR c_blanket_break IS
123: SELECT psc2.price_override *
124: DECODE(gl_currency_api.rate_exists(phc2.currency_code,
125: p_currency_code,
126: NVL(phc2.rate_date, phc2.creation_date),
127: NVL(phc2.rate_type, 'Corporate')),
128: 'Y',

Line 129: gl_currency_api.get_rate(phc2.currency_code,

125: p_currency_code,
126: NVL(phc2.rate_date, phc2.creation_date),
127: NVL(phc2.rate_type, 'Corporate')),
128: 'Y',
129: gl_currency_api.get_rate(phc2.currency_code,
130: p_currency_code,
131: NVL(phc2.rate_date, phc2.creation_date),
132: NVL(phc2.rate_type, 'Corporate')),
133: 1) blanket_price

Line 166: DECODE(gl_currency_api.rate_exists(phc2.currency_code,

162: ORDER BY psc2.quantity desc, blanket_price asc;
163:
164: CURSOR c_blanket_break_glb_sec IS
165: SELECT psc2.price_override *
166: DECODE(gl_currency_api.rate_exists(phc2.currency_code,
167: p_currency_code,
168: NVL(phc2.rate_date, phc2.creation_date),
169: NVL(phc2.rate_type, 'Corporate')),
170: 'Y',

Line 171: gl_currency_api.get_rate(phc2.currency_code,

167: p_currency_code,
168: NVL(phc2.rate_date, phc2.creation_date),
169: NVL(phc2.rate_type, 'Corporate')),
170: 'Y',
171: gl_currency_api.get_rate(phc2.currency_code,
172: p_currency_code,
173: NVL(phc2.rate_date, phc2.creation_date),
174: NVL(phc2.rate_type, 'Corporate')),
175: 1) blanket_price

Line 216: DECODE(gl_currency_api.rate_exists(phc2.currency_code,

212: ORDER BY psc2.quantity desc, blanket_price asc;
213:
214: CURSOR c_blanket_nobreak IS
215: SELECT plc2.unit_price *
216: DECODE(gl_currency_api.rate_exists(phc2.currency_code,
217: p_currency_code,
218: NVL(phc2.rate_date, phc2.creation_date),
219: NVL(phc2.rate_type, 'Corporate')),
220: 'Y',

Line 221: gl_currency_api.get_rate(phc2.currency_code,

217: p_currency_code,
218: NVL(phc2.rate_date, phc2.creation_date),
219: NVL(phc2.rate_type, 'Corporate')),
220: 'Y',
221: gl_currency_api.get_rate(phc2.currency_code,
222: p_currency_code,
223: NVL(phc2.rate_date, phc2.creation_date),
224: NVL(phc2.rate_type, 'Corporate')),
225: 1) blanket_price

Line 251: DECODE(gl_currency_api.rate_exists(phc2.currency_code,

247: ORDER BY blanket_price;
248:
249: CURSOR c_blanket_nobreak_glb_sec IS
250: SELECT plc2.unit_price *
251: DECODE(gl_currency_api.rate_exists(phc2.currency_code,
252: p_currency_code,
253: NVL(phc2.rate_date, phc2.creation_date),
254: NVL(phc2.rate_type, 'Corporate')),
255: 'Y',

Line 256: gl_currency_api.get_rate(phc2.currency_code,

252: p_currency_code,
253: NVL(phc2.rate_date, phc2.creation_date),
254: NVL(phc2.rate_type, 'Corporate')),
255: 'Y',
256: gl_currency_api.get_rate(phc2.currency_code,
257: p_currency_code,
258: NVL(phc2.rate_date, phc2.creation_date),
259: NVL(phc2.rate_type, 'Corporate')),
260: 1) blanket_price

Line 315: DECODE(gl_currency_api.rate_exists(psp.currency_code,

311: -- Select the average price
312:
313: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
314: SELECT SUM(psp.purchase_price *
315: DECODE(gl_currency_api.rate_exists(psp.currency_code,
316: p_currency_code,
317: psp.rate_date,
318: psp.rate_type),
319: 'Y',

Line 320: gl_currency_api.get_rate(psp.currency_code,

316: p_currency_code,
317: psp.rate_date,
318: psp.rate_type),
319: 'Y',
320: gl_currency_api.get_rate(psp.currency_code,
321: p_currency_code,
322: psp.rate_date, psp.rate_type),
323: 1) *
324: psp.quantity_purchased) /

Line 334: DECODE(gl_currency_api.rate_exists(psp.currency_code,

330: AND NVL(psp.quantity_purchased, 0) <> 0
331: AND psp.date_dimension BETWEEN p_start_date AND p_end_date;
332: ELSE
333: SELECT SUM(psp.purchase_price *
334: DECODE(gl_currency_api.rate_exists(psp.currency_code,
335: p_currency_code,
336: psp.rate_date,
337: psp.rate_type),
338: 'Y',

Line 339: gl_currency_api.get_rate(psp.currency_code,

335: p_currency_code,
336: psp.rate_date,
337: psp.rate_type),
338: 'Y',
339: gl_currency_api.get_rate(psp.currency_code,
340: p_currency_code,
341: psp.rate_date, psp.rate_type),
342: 1) *
343: psp.quantity_purchased) /