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_REPORT_UTIL dependencies on DUAL

Line 332: FROM dual UNION ALL

328: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
329: Build_Selection('POA_BIS_PERIOD_TYPE2',
330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),
331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')
332: FROM dual UNION ALL
333: SELECT FND_MESSAGE.get_string(''PO'',''POA_TIME''),
334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',
335: p_param(p_index).Value);
336: END Build_KPI_2PeriodType;

Line 334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',

330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),
331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')
332: FROM dual UNION ALL
333: SELECT FND_MESSAGE.get_string(''PO'',''POA_TIME''),
334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',
335: p_param(p_index).Value);
336: END Build_KPI_2PeriodType;
337:
338: PROCEDURE Build_CTL_ViewBy(

Line 345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual

341: BEGIN
342: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
343: Build_Selection('POA_BIS_VIEW_BY',
344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),
345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual
346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),
347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',
348: p_param(p_index).Value);
349: END Build_CTL_ViewBy;

Line 347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',

343: Build_Selection('POA_BIS_VIEW_BY',
344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),
345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual
346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),
347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',
348: p_param(p_index).Value);
349: END Build_CTL_ViewBy;
350:
351: PROCEDURE Build_LSS_ViewBy(

Line 358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual

354: BEGIN
355: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
356: Build_Selection('POA_BIS_VIEW_BY',
357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',

Line 360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual

356: Build_Selection('POA_BIS_VIEW_BY',
357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',
363: p_param(p_index).Value);
364: END Build_LSS_ViewBy;

Line 362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',

358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',
363: p_param(p_index).Value);
364: END Build_LSS_ViewBy;
365:
366: PROCEDURE Build_SPA_ViewBy(

Line 373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual

369: BEGIN
370: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
371: Build_Selection('POA_BIS_VIEW_BY',
372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual

Line 375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual

371: Build_Selection('POA_BIS_VIEW_BY',
372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual

Line 377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual

373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',

Line 379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual

375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',
382: p_param(p_index).Value);
383: END Build_SPA_ViewBy;

Line 381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',

377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',
382: p_param(p_index).Value);
383: END Build_SPA_ViewBy;
384:
385: PROCEDURE Build_SavingsShipToOrg(

Line 511: FROM SYS.DUAL;

507: BEGIN
508: IF (p_fdate IS NULL) THEN
509: SELECT to_char(add_months(sysdate, -12)+1, icx_sec.g_date_format)
510: INTO p_fdate
511: FROM SYS.DUAL;
512: END IF;
513:
514: IF (p_tdate IS NULL) THEN
515: SELECT to_char(sysdate, icx_sec.g_date_format)

Line 517: FROM SYS.DUAL;

513:
514: IF (p_tdate IS NULL) THEN
515: SELECT to_char(sysdate, icx_sec.g_date_format)
516: INTO p_tdate
517: FROM SYS.DUAL;
518: END IF;
519:
520: -- Convert date to DD-MON-YYYY format as thats the format reports expect
521: SELECT to_char(to_date(p_fdate, icx_sec.g_date_format), 'DD-MON-YYYY')

Line 523: FROM SYS.DUAL;

519:
520: -- Convert date to DD-MON-YYYY format as thats the format reports expect
521: SELECT to_char(to_date(p_fdate, icx_sec.g_date_format), 'DD-MON-YYYY')
522: INTO p_fdate
523: FROM SYS.DUAL;
524:
525: SELECT to_char(to_date(p_tdate, icx_sec.g_date_format), 'DD-MON-YYYY')
526: INTO p_tdate
527: FROM SYS.DUAL;

Line 527: FROM SYS.DUAL;

523: FROM SYS.DUAL;
524:
525: SELECT to_char(to_date(p_tdate, icx_sec.g_date_format), 'DD-MON-YYYY')
526: INTO p_tdate
527: FROM SYS.DUAL;
528:
529: RETURN TRUE;
530:
531: EXCEPTION WHEN OTHERS THEN