APPS.ARRX_COGS_REP_INNER dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 25: FROM ra_cust_trx_line_gl_dist_all

21: p_base_transaction_value NUMBER) RETURN NUMBER IS
22:
23: CURSOR rev_rows IS
24: SELECT count(*)
25: FROM ra_cust_trx_line_gl_dist_all
26: WHERE customer_trx_line_id = p_line_id
27: AND account_set_flag = 'N'
28: AND account_class = 'REV';
29:

Line 255: FROM ra_cust_trx_line_gl_dist dist,

251: ),
252: 2, DECODE(dist.account_class, 'UNEARN', 0, dist.acctd_amount), 0
253: )
254: ))/count(DISTINCT mmt.transaction_id), l_precision) revenue
255: FROM ra_cust_trx_line_gl_dist dist,
256: ra_customer_trx_lines lines,
257: mtl_material_transactions mmt,
258: mtl_transaction_accounts mta,
259: ra_customer_trx trx,