APPS.ARRX_TX dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 635: fa_rx_util_pkg.From_Clause := 'RA_CUST_TRX_LINE_GL_DIST_ALL RECDIST,

631:
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,

Line 1067: RA_CUST_TRX_LINE_GL_DIST DIST,

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';
1071:

Line 1728: RA_CUST_TRX_LINE_GL_DIST DIST,

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';
1732:

Line 1762: from ra_cust_trx_line_gl_dist linedist,

1758: then
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

Line 1889: from ra_cust_trx_line_gl_dist

1885: order by last_update_date desc;
1886:
1887: cursor D is
1888: select last_update_date,last_updated_by
1889: from ra_cust_trx_line_gl_dist
1890: where customer_trx_id = P_CUSTOMER_TRX_ID
1891: and ((account_class = 'REC' and latest_rec_flag = 'Y')
1892: or (account_class <> 'REC' and account_set_flag = 'N'))
1893: order by last_update_date desc;