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.ARRX_RC_UNAPP dependencies on AR_LOOKUPS

Line 676: select MEANING into l_app from ar_lookups

672:
673: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
674: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
675:
676: select MEANING into l_app from ar_lookups
677: where lookup_type='CHECK_STATUS' and lookup_code='APP';
678: select MEANING into l_nsf from ar_lookups
679: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
680: select MEANING into l_rev from ar_lookups

Line 678: select MEANING into l_nsf from ar_lookups

674: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
675:
676: select MEANING into l_app from ar_lookups
677: where lookup_type='CHECK_STATUS' and lookup_code='APP';
678: select MEANING into l_nsf from ar_lookups
679: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
680: select MEANING into l_rev from ar_lookups
681: where lookup_type='CHECK_STATUS' and lookup_code='REV';
682: select MEANING into l_stop from ar_lookups

Line 680: select MEANING into l_rev from ar_lookups

676: select MEANING into l_app from ar_lookups
677: where lookup_type='CHECK_STATUS' and lookup_code='APP';
678: select MEANING into l_nsf from ar_lookups
679: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
680: select MEANING into l_rev from ar_lookups
681: where lookup_type='CHECK_STATUS' and lookup_code='REV';
682: select MEANING into l_stop from ar_lookups
683: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
684: select MEANING into l_unapp from ar_lookups

Line 682: select MEANING into l_stop from ar_lookups

678: select MEANING into l_nsf from ar_lookups
679: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
680: select MEANING into l_rev from ar_lookups
681: where lookup_type='CHECK_STATUS' and lookup_code='REV';
682: select MEANING into l_stop from ar_lookups
683: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
684: select MEANING into l_unapp from ar_lookups
685: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
686: select MEANING into l_unid from ar_lookups

Line 684: select MEANING into l_unapp from ar_lookups

680: select MEANING into l_rev from ar_lookups
681: where lookup_type='CHECK_STATUS' and lookup_code='REV';
682: select MEANING into l_stop from ar_lookups
683: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
684: select MEANING into l_unapp from ar_lookups
685: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
686: select MEANING into l_unid from ar_lookups
687: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
688: dbms_sql.bind_variable(c, 'L_APP' , l_app);

Line 686: select MEANING into l_unid from ar_lookups

682: select MEANING into l_stop from ar_lookups
683: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
684: select MEANING into l_unapp from ar_lookups
685: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
686: select MEANING into l_unid from ar_lookups
687: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
688: dbms_sql.bind_variable(c, 'L_APP' , l_app);
689: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
690: dbms_sql.bind_variable(c, 'L_REV' , l_rev);

Line 695: select substr(MEANING,1,44) into l_unid_cust from ar_lookups

691: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
692: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
693: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
694:
695: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
696: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
697: l_unid_cust := ' **** '||l_unid_cust;
698: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
699:

Line 700: select MEANING into L_APPROVED from ar_lookups

696: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
697: l_unid_cust := ' **** '||l_unid_cust;
698: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
699:
700: select MEANING into L_APPROVED from ar_lookups
701: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
702: select MEANING into L_CLEARED from ar_lookups
703: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
704: select MEANING into L_CONFIRMED from ar_lookups

Line 702: select MEANING into L_CLEARED from ar_lookups

698: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
699:
700: select MEANING into L_APPROVED from ar_lookups
701: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
702: select MEANING into L_CLEARED from ar_lookups
703: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
704: select MEANING into L_CONFIRMED from ar_lookups
705: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
706: select MEANING into L_REMITTED from ar_lookups

Line 704: select MEANING into L_CONFIRMED from ar_lookups

700: select MEANING into L_APPROVED from ar_lookups
701: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
702: select MEANING into L_CLEARED from ar_lookups
703: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
704: select MEANING into L_CONFIRMED from ar_lookups
705: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
706: select MEANING into L_REMITTED from ar_lookups
707: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
708: select MEANING into L_REVERSED from ar_lookups

Line 706: select MEANING into L_REMITTED from ar_lookups

702: select MEANING into L_CLEARED from ar_lookups
703: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
704: select MEANING into L_CONFIRMED from ar_lookups
705: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
706: select MEANING into L_REMITTED from ar_lookups
707: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
708: select MEANING into L_REVERSED from ar_lookups
709: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
710: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);

Line 708: select MEANING into L_REVERSED from ar_lookups

704: select MEANING into L_CONFIRMED from ar_lookups
705: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
706: select MEANING into L_REMITTED from ar_lookups
707: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
708: select MEANING into L_REVERSED from ar_lookups
709: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
710: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
711: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
712: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);