DBA Data[Home] [Help]

APPS.ARRX_TX dependencies on RA_CUSTOMER_TRX_LINES

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 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