[Home] [Help]
6771: sob_type,
6772: tax_link_id,
6773: tax_inc_flag
6774: )
6775: 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)*/
6776: p_gt_id,
6777: ctlgd.amount,
6778: ctlgd.acctd_amount,
6779: ctlgd.account_class,
6901: p_ae_sys_rec.sob_type,
6902: rar.tax_link_id,
6903: rar.tax_inc_flag
6904: FROM ra_ar_gt rar,
6905: ra_cust_trx_line_gl_dist ctlgd
6906: WHERE rar.gt_id = p_gt_id
6907: AND rar.ref_customer_trx_id = p_customer_trx_id
6908: AND rar.gp_level = 'L'
6909: AND rar.ref_customer_trx_id = ctlgd.customer_trx_id
8443: 'N'), -- tax_inc_flag
8444: 'Y' -- ref_mf_dist_flag
8445: FROM ra_ar_gt rar,
8446: psa_mf_adj_dist_all rrc,
8447: ra_cust_trx_line_gl_dist ctlgd,
8448: ra_customer_trx_lines ctl,
8449: ar_adjustments adj
8450: WHERE rar.gt_id = p_gt_id
8451: AND rar.ref_customer_trx_id = p_customer_trx_id
9482: CURSOR c(p_customer_trx_id IN NUMBER) IS
9483: SELECT SUM(AMOUNT),
9484: SUM(ACCTD_AMOUNT),
9485: customer_trx_line_id
9486: FROM ra_cust_trx_line_gl_dist
9487: WHERE customer_trx_id = p_customer_trx_id
9488: GROUP BY customer_trx_line_id;
9489:
9490: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9717: ctl.line_type) a,
9718: (SELECT SUM(AMOUNT) sum_orig,
9719: SUM(ACCTD_AMOUNT) sum_acctd_orig,
9720: customer_trx_line_id
9721: FROM ra_cust_trx_line_gl_dist
9722: WHERE customer_trx_id = p_customer_trx_id
9723: GROUP BY customer_trx_line_id) b
9724: WHERE a.ref_customer_trx_line_id (+) = b.customer_trx_line_id
9725: GROUP BY b.customer_trx_line_id,
9820: gld.customer_trx_line_id,
9821: inv.customer_trx_id
9822: FROM
9823: ra_customer_trx inv,
9824: ra_cust_trx_line_gl_dist gld,
9825: ra_cust_trx_types ctt
9826: WHERE inv.customer_trx_id = gld.customer_trx_id
9827: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
9828: AND inv.request_id = p_request_id
13221: -- Amount for original and remaining for all type of lines on reve line
13222: (SELECT SUM(AMOUNT) sum_amt,
13223: SUM(ACCTD_AMOUNT) sum_acctd_amt,
13224: customer_trx_line_id
13225: FROM ra_cust_trx_line_gl_dist
13226: WHERE customer_trx_id = p_customer_trx_id
13227: GROUP BY customer_trx_line_id) orl,
13228: -- Amount for charges and freight on revenue line
13229: (SELECT SUM((DECODE(a.activity_bucket,'ADJ_CHRG',amt,'APP_CHRG',amt,0))) CHRG_ON_REV_LINE
13407: FROM
13408: (SELECT SUM(amount) sum_amt,
13409: SUM(acctd_amount) sum_acctd_amt,
13410: customer_trx_line_id
13411: FROM ra_cust_trx_line_gl_dist
13412: WHERE customer_trx_id = g_cm_trx_id
13413: GROUP BY customer_trx_line_id)
13414: cm_gld,
13415: ra_customer_trx_lines cm_tl
15528: SELECT account_class account_class,
15529: SUM(amount) sum_amount,
15530: SUM(acctd_amount) sum_acctd_amount,
15531: COUNT(account_class) count
15532: FROM ra_cust_trx_line_gl_dist
15533: WHERE customer_trx_id = p_cust_inv_rec.customer_trx_id
15534: AND account_class IN ('UNEARN','UNBILL')
15535: GROUP BY account_class;
15536:
18065: ctl.line_type line_type,
18066: ctx.invoice_currency_code invoice_currency_code
18067: FROM ra_customer_trx ctx,
18068: ra_customer_trx_lines ctl,
18069: ra_cust_trx_line_gl_dist ctlgd
18070: WHERE ctx.customer_trx_id = p_customer_trx_id
18071: AND ctx.customer_trx_id = ctl.customer_trx_id
18072: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
18073: GROUP BY ctx.invoice_currency_code,
18774: min(sob.currency_code) ledger_currency,
18775: ctl.LINE_TYPE
18776: from ra_customer_trx ct,
18777: ra_customer_trx_lines ctl,
18778: RA_CUST_TRX_LINE_GL_DIST gld,
18779: gl_sets_of_books sob,
18780: ar_system_parameters ars
18781: where ct.customer_trx_id = p_customer_trx_id
18782: and ctl.customer_trx_id = ct.customer_trx_id