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

Line 2837: FROM dual;

2833:
2834: SELECT SUBSTR(l_refer2, 0, decode(INSTR(l_refer2, 'C'), 0,
2835: LENGTH(l_refer2),INSTR(l_refer2,'C')-1))
2836: INTO l_reference_2
2837: FROM dual;
2838:
2839: -- Added to handle 3131834 for deobligated invoices in final match
2840: -- and reversal requisitions created by autocreate PO.
2841: --

Line 3570: FROM DUAL;

3566: BEGIN
3567: --gscc fix
3568: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3569: INTO l_doc_date
3570: FROM DUAL;
3571:
3572: EXCEPTION WHEN OTHERS THEN
3573: l_select :=
3574: 'SELECT creation_date, creation_date, created_by

Line 3626: FROM DUAL;

3622: BEGIN
3623: --gscc fix
3624: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3625: INTO l_doc_date
3626: FROM DUAL;
3627:
3628: EXCEPTION WHEN OTHERS THEN
3629: l_gl_date := NULL;
3630: l_select :=

Line 3696: FROM DUAL;

3692: BEGIN
3693: --gscc fix
3694: SELECT to_date(l_temp_doc_date, 'mm/dd/yyrr')
3695: INTO l_doc_date
3696: FROM DUAL;
3697:
3698: EXCEPTION WHEN OTHERS THEN
3699: l_select :=
3700: 'SELECT rt.transaction_date,