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.FV_FACTS_TRX_REGISTER dependencies on DUAL

Line 2258: FROM dual;

2254:
2255: SELECT SUBSTR(l_refer2, 0, decode(INSTR(l_refer2, 'C'), 0,
2256: LENGTH(l_refer2),INSTR(l_refer2,'C')-1))
2257: INTO l_reference_2
2258: FROM dual;
2259:
2260: -- Added to handle 3131834 for deobligated invoices in final match
2261: -- and reversal requisitions created by autocreate PO.
2262: --

Line 3441: FROM DUAL;

3437: BEGIN
3438: --gscc fix
3439: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3440: INTO l_doc_date
3441: FROM DUAL;
3442:
3443: EXCEPTION WHEN OTHERS THEN
3444: l_select :=
3445: 'SELECT creation_date, creation_date, created_by

Line 3496: FROM DUAL;

3492: BEGIN
3493: --gscc fix
3494: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3495: INTO l_doc_date
3496: FROM DUAL;
3497:
3498: EXCEPTION WHEN OTHERS THEN
3499: l_gl_date := NULL;
3500: l_select :=

Line 3568: FROM DUAL;

3564: BEGIN
3565: --gscc fix
3566: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3567: INTO l_doc_date
3568: FROM DUAL;
3569:
3570: EXCEPTION WHEN OTHERS THEN
3571: l_select :=
3572: 'SELECT rt.transaction_date,