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 669: select MEANING into l_app from ar_lookups

665:
666: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
667: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
668:
669: select MEANING into l_app from ar_lookups
670: where lookup_type='CHECK_STATUS' and lookup_code='APP';
671: select MEANING into l_nsf from ar_lookups
672: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
673: select MEANING into l_rev from ar_lookups

Line 671: select MEANING into l_nsf from ar_lookups

667: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
668:
669: select MEANING into l_app from ar_lookups
670: where lookup_type='CHECK_STATUS' and lookup_code='APP';
671: select MEANING into l_nsf from ar_lookups
672: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
673: select MEANING into l_rev from ar_lookups
674: where lookup_type='CHECK_STATUS' and lookup_code='REV';
675: select MEANING into l_stop from ar_lookups

Line 673: select MEANING into l_rev from ar_lookups

669: select MEANING into l_app from ar_lookups
670: where lookup_type='CHECK_STATUS' and lookup_code='APP';
671: select MEANING into l_nsf from ar_lookups
672: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
673: select MEANING into l_rev from ar_lookups
674: where lookup_type='CHECK_STATUS' and lookup_code='REV';
675: select MEANING into l_stop from ar_lookups
676: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
677: select MEANING into l_unapp from ar_lookups

Line 675: select MEANING into l_stop from ar_lookups

671: select MEANING into l_nsf from ar_lookups
672: where lookup_type='CHECK_STATUS' and lookup_code='NSF';
673: select MEANING into l_rev from ar_lookups
674: where lookup_type='CHECK_STATUS' and lookup_code='REV';
675: select MEANING into l_stop from ar_lookups
676: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
677: select MEANING into l_unapp from ar_lookups
678: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
679: select MEANING into l_unid from ar_lookups

Line 677: select MEANING into l_unapp from ar_lookups

673: select MEANING into l_rev from ar_lookups
674: where lookup_type='CHECK_STATUS' and lookup_code='REV';
675: select MEANING into l_stop from ar_lookups
676: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
677: select MEANING into l_unapp from ar_lookups
678: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
679: select MEANING into l_unid from ar_lookups
680: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
681: dbms_sql.bind_variable(c, 'L_APP' , l_app);

Line 679: select MEANING into l_unid from ar_lookups

675: select MEANING into l_stop from ar_lookups
676: where lookup_type='CHECK_STATUS' and lookup_code='STOP';
677: select MEANING into l_unapp from ar_lookups
678: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
679: select MEANING into l_unid from ar_lookups
680: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
681: dbms_sql.bind_variable(c, 'L_APP' , l_app);
682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);

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

684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
686: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
687:
688: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
689: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
690: l_unid_cust := ' **** '||l_unid_cust;
691: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
692:

Line 693: select MEANING into L_APPROVED from ar_lookups

689: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
690: l_unid_cust := ' **** '||l_unid_cust;
691: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
692:
693: select MEANING into L_APPROVED from ar_lookups
694: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
695: select MEANING into L_CLEARED from ar_lookups
696: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
697: select MEANING into L_CONFIRMED from ar_lookups

Line 695: select MEANING into L_CLEARED from ar_lookups

691: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
692:
693: select MEANING into L_APPROVED from ar_lookups
694: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
695: select MEANING into L_CLEARED from ar_lookups
696: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
697: select MEANING into L_CONFIRMED from ar_lookups
698: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
699: select MEANING into L_REMITTED from ar_lookups

Line 697: select MEANING into L_CONFIRMED from ar_lookups

693: select MEANING into L_APPROVED from ar_lookups
694: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
695: select MEANING into L_CLEARED from ar_lookups
696: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
697: select MEANING into L_CONFIRMED from ar_lookups
698: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
699: select MEANING into L_REMITTED from ar_lookups
700: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
701: select MEANING into L_REVERSED from ar_lookups

Line 699: select MEANING into L_REMITTED from ar_lookups

695: select MEANING into L_CLEARED from ar_lookups
696: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';
697: select MEANING into L_CONFIRMED from ar_lookups
698: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
699: select MEANING into L_REMITTED from ar_lookups
700: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
701: select MEANING into L_REVERSED from ar_lookups
702: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);

Line 701: select MEANING into L_REVERSED from ar_lookups

697: select MEANING into L_CONFIRMED from ar_lookups
698: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
699: select MEANING into L_REMITTED from ar_lookups
700: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
701: select MEANING into L_REVERSED from ar_lookups
702: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
704: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);