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.CE_AUTO_BANK_CLEAR1 dependencies on RA_CUST_TRX_TYPES

Line 2477: cc_id ra_cust_trx_types.gl_id_rec%type;

2473:
2474: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2475: CE_AUTO_BANK_MATCH.trx_customer_id is not null) THEN
2476: declare
2477: cc_id ra_cust_trx_types.gl_id_rec%type;
2478: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2479: cust_trx_type ra_cust_trx_types.name%type;
2480: l_dbseqname varchar2(30);
2481: l_doc_seq_id NUMBER;

Line 2478: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

2474: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2475: CE_AUTO_BANK_MATCH.trx_customer_id is not null) THEN
2476: declare
2477: cc_id ra_cust_trx_types.gl_id_rec%type;
2478: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2479: cust_trx_type ra_cust_trx_types.name%type;
2480: l_dbseqname varchar2(30);
2481: l_doc_seq_id NUMBER;
2482: l_doc_seq_value NUMBER;

Line 2479: cust_trx_type ra_cust_trx_types.name%type;

2475: CE_AUTO_BANK_MATCH.trx_customer_id is not null) THEN
2476: declare
2477: cc_id ra_cust_trx_types.gl_id_rec%type;
2478: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2479: cust_trx_type ra_cust_trx_types.name%type;
2480: l_dbseqname varchar2(30);
2481: l_doc_seq_id NUMBER;
2482: l_doc_seq_value NUMBER;
2483: l_valid_seq BOOLEAN := TRUE;

Line 2490: from ra_cust_trx_types

2486:
2487: begin
2488: select name, gl_id_rec, cust_trx_type_id
2489: into cust_trx_type, cc_id, cust_trx_type_id
2490: from ra_cust_trx_types
2491: where type = 'DM'
2492: and post_to_gl = 'Y'
2493: and accounting_affect_flag = 'Y'
2494: and tax_calculation_flag = 'N'