APPS.ARP_DET_DIST_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 5835: SELECT /*+INDEX (rar ra_ar_n1) LEADING(rar,ctlgd) USE_NL_WITH_INDEX(rar ra_ar_n1) USE_NL_WITH_INDEX(ctlgd RA_CUST_TRX_LINE_GL_DIST_N1)*/

5831: sob_type,
5832: tax_link_id,
5833: tax_inc_flag
5834: )
5835: SELECT /*+INDEX (rar ra_ar_n1) LEADING(rar,ctlgd) USE_NL_WITH_INDEX(rar ra_ar_n1) USE_NL_WITH_INDEX(ctlgd RA_CUST_TRX_LINE_GL_DIST_N1)*/
5836: p_gt_id,
5837: ctlgd.amount,
5838: ctlgd.acctd_amount,
5839: ctlgd.account_class,

Line 5965: ra_cust_trx_line_gl_dist ctlgd

5961: p_ae_sys_rec.sob_type,
5962: rar.tax_link_id,
5963: rar.tax_inc_flag
5964: FROM ra_ar_gt rar,
5965: ra_cust_trx_line_gl_dist ctlgd
5966: WHERE rar.gt_id = p_gt_id
5967: AND rar.ref_customer_trx_id = p_customer_trx_id
5968: AND rar.gp_level = 'L'
5969: AND rar.ref_customer_trx_id = ctlgd.customer_trx_id

Line 7109: ra_cust_trx_line_gl_dist ctlgd,

7105: 'N'), -- tax_inc_flag
7106: 'Y' -- ref_mf_dist_flag
7107: FROM ra_ar_gt rar,
7108: psa_mf_adj_dist_all rrc,
7109: ra_cust_trx_line_gl_dist ctlgd,
7110: ra_customer_trx_lines ctl,
7111: ar_adjustments adj
7112: WHERE rar.gt_id = p_gt_id
7113: AND rar.ref_customer_trx_id = p_customer_trx_id

Line 8069: FROM ra_cust_trx_line_gl_dist

8065: CURSOR c(p_customer_trx_id IN NUMBER) IS
8066: SELECT SUM(AMOUNT),
8067: SUM(ACCTD_AMOUNT),
8068: customer_trx_line_id
8069: FROM ra_cust_trx_line_gl_dist
8070: WHERE customer_trx_id = p_customer_trx_id
8071: GROUP BY customer_trx_line_id;
8072:
8073: l_amt_tab DBMS_SQL.NUMBER_TABLE;

Line 8304: FROM ra_cust_trx_line_gl_dist

8300: ctl.line_type) a,
8301: (SELECT SUM(AMOUNT) sum_orig,
8302: SUM(ACCTD_AMOUNT) sum_acctd_orig,
8303: customer_trx_line_id
8304: FROM ra_cust_trx_line_gl_dist
8305: WHERE customer_trx_id = p_customer_trx_id
8306: GROUP BY customer_trx_line_id) b
8307: WHERE a.ref_customer_trx_line_id = b.customer_trx_line_id
8308: GROUP BY a.ref_customer_trx_line_id,

Line 8407: ra_cust_trx_line_gl_dist gld,

8403: gld.customer_trx_line_id,
8404: inv.customer_trx_id
8405: FROM
8406: ra_customer_trx inv,
8407: ra_cust_trx_line_gl_dist gld,
8408: ra_cust_trx_types ctt
8409: WHERE inv.customer_trx_id = gld.customer_trx_id
8410: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
8411: AND inv.request_id = p_request_id

Line 11757: FROM ra_cust_trx_line_gl_dist

11753: -- Amount for original and remaining for all type of lines on reve line
11754: (SELECT SUM(AMOUNT) sum_amt,
11755: SUM(ACCTD_AMOUNT) sum_acctd_amt,
11756: customer_trx_line_id
11757: FROM ra_cust_trx_line_gl_dist
11758: WHERE customer_trx_id = p_customer_trx_id
11759: GROUP BY customer_trx_line_id) orl,
11760: -- Amount for charges and freight on revenue line
11761: (SELECT SUM((DECODE(a.activity_bucket,'ADJ_CHRG',amt,0))) CHRG_ON_REV_LINE

Line 13820: FROM ra_cust_trx_line_gl_dist

13816: SELECT account_class account_class,
13817: SUM(amount) sum_amount,
13818: SUM(acctd_amount) sum_acctd_amount,
13819: COUNT(account_class) count
13820: FROM ra_cust_trx_line_gl_dist
13821: WHERE customer_trx_id = p_cust_inv_rec.customer_trx_id
13822: AND account_class IN ('UNEARN','UNBILL')
13823: GROUP BY account_class;
13824:

Line 16350: ra_cust_trx_line_gl_dist ctlgd

16346: ctl.line_type line_type,
16347: ctx.invoice_currency_code invoice_currency_code
16348: FROM ra_customer_trx ctx,
16349: ra_customer_trx_lines ctl,
16350: ra_cust_trx_line_gl_dist ctlgd
16351: WHERE ctx.customer_trx_id = p_customer_trx_id
16352: AND ctx.customer_trx_id = ctl.customer_trx_id
16353: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
16354: GROUP BY ctx.invoice_currency_code,