DBA Data[Home] [Help]

APPS.ARRX_TX dependencies on RA_CUSTOMER_TRX_LINES

Line 1084: RA_CUSTOMER_TRX_LINES CTL,

1080: -- Add to the FROM clause specific to this report
1081: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1082: fa_rx_util_pkg.From_Clause :=
1083: fa_rx_util_pkg.From_Clause || ',
1084: RA_CUSTOMER_TRX_LINES CTL,
1085: RA_CUST_TRX_LINE_GL_DIST DIST,
1086: MTL_SYSTEM_ITEMS ITEM,
1087: AR_MEMO_LINES MEMO,
1088: GL_CODE_COMBINATIONS CCDIST';

Line 1745: RA_CUSTOMER_TRX_LINES CTL,

1741: -- Add to the FROM clause specific to this report
1742: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1743: fa_rx_util_pkg.From_Clause :=
1744: fa_rx_util_pkg.From_Clause || ',
1745: RA_CUSTOMER_TRX_LINES CTL,
1746: RA_CUST_TRX_LINE_GL_DIST DIST,
1747: MTL_SYSTEM_ITEMS ITEM,
1748: AR_MEMO_LINES MEMO,
1749: GL_CODE_COMBINATIONS CCDIST';

Line 1781: ra_customer_trx_lines line,

1777: line_select_statement :=
1778: ' AND CT.CUSTOMER_TRX_ID in '||
1779: '(select distinct line.customer_trx_id
1780: from ra_cust_trx_line_gl_dist linedist,
1781: ra_customer_trx_lines line,
1782: gl_code_combinations linegl
1783: where linedist.account_class <> ''REC''
1784: and linedist.customer_trx_line_id = line.customer_trx_line_id
1785: and linedist.code_combination_id = linegl.code_combination_id

Line 1901: from ra_customer_trx_lines

1897: order by last_update_date desc;
1898:
1899: cursor L is
1900: select last_update_date,last_updated_by
1901: from ra_customer_trx_lines
1902: where customer_trx_id = P_CUSTOMER_TRX_ID
1903: order by last_update_date desc;
1904:
1905: cursor D is