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_TX dependencies on RA_CUSTOMER_TRX

Line 636: RA_CUSTOMER_TRX_ALL CT,

632: -- bug3940958 changed to _ALL for cross-org
633: IF var.ca_sob_type = 'P'
634: THEN
635: fa_rx_util_pkg.From_Clause := 'RA_CUST_TRX_LINE_GL_DIST_ALL RECDIST,
636: RA_CUSTOMER_TRX_ALL CT,
637: RA_CUST_TRX_TYPES_ALL TRX_TYPE,
638: HZ_CUST_ACCOUNTS_ALL BILL_TO,
639: HZ_PARTIES PARTY,
640: GL_CODE_COMBINATIONS CCRECDIST,

Line 646: RA_CUSTOMER_TRX_ALL_MRC_V CT,

642: FND_DOCUMENT_SEQUENCES DOC_SEQ,
643: AR_SYSTEM_PARAMETERS_ALL SYSPARAM';
644: ELSE
645: fa_rx_util_pkg.From_Clause := 'RA_TRX_LINE_GL_DIST_ALL_MRC_V RECDIST,
646: RA_CUSTOMER_TRX_ALL_MRC_V CT,
647: RA_CUST_TRX_TYPES_ALL TRX_TYPE,
648: HZ_CUST_ACCOUNTS_ALL BILL_TO,
649: HZ_PARTIES PARTY,
650: GL_CODE_COMBINATIONS CCRECDIST,

Line 1066: RA_CUSTOMER_TRX_LINES CTL,

1062: -- Add to the FROM clause specific to this report
1063: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1064: fa_rx_util_pkg.From_Clause :=
1065: fa_rx_util_pkg.From_Clause || ',
1066: RA_CUSTOMER_TRX_LINES CTL,
1067: RA_CUST_TRX_LINE_GL_DIST DIST,
1068: MTL_SYSTEM_ITEMS ITEM,
1069: AR_MEMO_LINES MEMO,
1070: GL_CODE_COMBINATIONS CCDIST';

Line 1727: RA_CUSTOMER_TRX_LINES CTL,

1723: -- Add to the FROM clause specific to this report
1724: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1725: fa_rx_util_pkg.From_Clause :=
1726: fa_rx_util_pkg.From_Clause || ',
1727: RA_CUSTOMER_TRX_LINES CTL,
1728: RA_CUST_TRX_LINE_GL_DIST DIST,
1729: MTL_SYSTEM_ITEMS ITEM,
1730: AR_MEMO_LINES MEMO,
1731: GL_CODE_COMBINATIONS CCDIST';

Line 1763: ra_customer_trx_lines line,

1759: line_select_statement :=
1760: ' AND CT.CUSTOMER_TRX_ID in '||
1761: '(select distinct line.customer_trx_id
1762: from ra_cust_trx_line_gl_dist linedist,
1763: ra_customer_trx_lines line,
1764: gl_code_combinations linegl
1765: where linedist.account_class <> ''REC''
1766: and linedist.customer_trx_line_id = line.customer_trx_line_id
1767: and linedist.code_combination_id = linegl.code_combination_id

Line 1877: from ra_customer_trx

1873: procedure GET_LAST_UPDATE(P_CUSTOMER_TRX_ID in number)
1874: is
1875: cursor H is
1876: select last_update_date,last_updated_by
1877: from ra_customer_trx
1878: where customer_trx_id = P_CUSTOMER_TRX_ID
1879: order by last_update_date desc;
1880:
1881: cursor L is

Line 1883: from ra_customer_trx_lines

1879: order by last_update_date desc;
1880:
1881: cursor L is
1882: select last_update_date,last_updated_by
1883: from ra_customer_trx_lines
1884: where customer_trx_id = P_CUSTOMER_TRX_ID
1885: order by last_update_date desc;
1886:
1887: cursor D is