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 2173: FROM dual;

2169:
2170: SELECT SUBSTR(l_refer2, 0, decode(INSTR(l_refer2, 'C'), 0,
2171: LENGTH(l_refer2),INSTR(l_refer2,'C')-1))
2172: INTO l_reference_2
2173: FROM dual;
2174:
2175: -- Added to handle 3131834 for deobligated invoices in final match
2176: -- and reversal requisitions created by autocreate PO.
2177: --

Line 3231: FROM DUAL;

3227: BEGIN
3228: --gscc fix
3229: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3230: INTO l_doc_date
3231: FROM DUAL;
3232:
3233: EXCEPTION WHEN OTHERS THEN
3234: l_select :=
3235: 'SELECT creation_date, creation_date, created_by

Line 3288: FROM DUAL;

3284: BEGIN
3285: --gscc fix
3286: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3287: INTO l_doc_date
3288: FROM DUAL;
3289:
3290: EXCEPTION WHEN OTHERS THEN
3291: l_gl_date := NULL;
3292: l_select :=

Line 3360: FROM DUAL;

3356: BEGIN
3357: --gscc fix
3358: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3359: INTO l_doc_date
3360: FROM DUAL;
3361:
3362: EXCEPTION WHEN OTHERS THEN
3363: l_select :=
3364: 'SELECT rt.transaction_date,