eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 340: -- rather than writing them to ra_cust_trx_line_gl_dist

336: -- Function : Transfers a specified amount of revenue from
337: -- unearned to earned revenue account. This is an
338: -- overlaid version of the previous procedure that
339: -- returns the new distributions in a pl/sql table
340: -- rather than writing them to ra_cust_trx_line_gl_dist
341: -- Pre-reqs : Sufficient unearned revenue must exist.
342: -- Parameters :
343: -- IN : p_api_version NUMBER Required
344: -- p_init_msg_list VARCHAR2 Optional

Line 365: -- entries into ra_cust_trx_line_gl_dist. Instead it outputs

361: --
362: -- Notes : AutoAccounting used for both debits and credits
363: -- This procedure is an overlay of the standard Unearn_Revenue
364: -- API which does not write out NOCOPY a revenue adjustment record or
365: -- entries into ra_cust_trx_line_gl_dist. Instead it outputs
366: -- the distributions to a pl/sql table which is passed out NOCOPY to
367: -- the calling routine
368: -----------------------------------------------------------------------
369: PROCEDURE Earn_Revenue

Line 637: /* Bug 4304865: set flag for later storage on ra_cust_trx_line_gl_dist

633: THEN
634: l_revenue_amount := l_revenue_amount * -1;
635: END IF;
636:
637: /* Bug 4304865: set flag for later storage on ra_cust_trx_line_gl_dist
638: if earn/unearn not called from revenue management package */
639: IF NVL(p_rev_adj_rec.source, -99999) <>
640: ar_revenue_management_pvt.c_revenue_management_source
641: THEN

Line 997: FROM ra_cust_trx_line_gl_dist d

993: SUM(NVL(s1.revenue_percent_split,0))) <> 0);
994:
995: CURSOR c_rev_total IS
996: SELECT NVL(SUM(d.amount),0)
997: FROM ra_cust_trx_line_gl_dist d
998: ,mtl_item_categories mic
999: ,ra_customer_trx_lines l
1000: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1001: AND d.account_class = 'REV'

Line 1134: FROM ra_cust_trx_line_gl_dist d

1130: -- complete flag for credit memos
1131:
1132: CURSOR c_line_revenue_total IS
1133: SELECT NVL(SUM(d.amount),0)
1134: FROM ra_cust_trx_line_gl_dist d
1135: WHERE d.customer_trx_line_id = l_cust_trx_line_id
1136: AND d.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1137: AND d.account_set_flag = 'N'
1138: AND d.account_class = 'REV';

Line 1142: FROM ra_cust_trx_line_gl_dist d,

1138: AND d.account_class = 'REV';
1139:
1140: CURSOR c_cm_line_revenue_total IS
1141: SELECT NVL(SUM(d.amount),0)
1142: FROM ra_cust_trx_line_gl_dist d,
1143: ra_customer_trx_lines l
1144: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1145: AND d.customer_trx_id = l.customer_trx_id
1146: AND l.previous_customer_trx_line_id = l_cust_trx_line_id

Line 2432: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

2428: l_deferred_revenue_flag VARCHAR2(1);
2429: l_deferred_days NUMBER := 0;
2430: l_gl_date DATE;
2431: l_gl_date_valid DATE; -- Bug 2146970
2432: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
2433: l_revenue_type VARCHAR2(10);
2434: l_gl_date_total NUMBER; -- Bug 2477881
2435: l_gl_date_acctd_total NUMBER; -- Bug 2477881
2436: l_gl_date_pct_total NUMBER; -- Bug 2477881

Line 2748: INSERT INTO ra_cust_trx_line_gl_dist

2744: /* Insert using statement similar to one in
2745: arp_auto_rule.create_assignments. Main diff is
2746: that this one is by line rather than trx. */
2747:
2748: INSERT INTO ra_cust_trx_line_gl_dist
2749: (
2750: customer_trx_line_id,
2751: customer_trx_id,
2752: code_combination_id,

Line 2776: SELECT /+ ORDERED push_pred(ra.lgd) index(dist ra_cust_trx_line_gl_dist_n1)/

2772: revenue_adjustment_id,
2773: user_generated_flag,
2774: org_id
2775: )
2776: SELECT /*+ ORDERED push_pred(ra.lgd) index(dist ra_cust_trx_line_gl_dist_n1)*/
2777: ra.customer_trx_line_id, /* customer_trx_line_id */
2778: l.customer_trx_id, /* customer_trx_id */
2779: dist.code_combination_id, /* code_combination_id */
2780: arp_standard.sysparm.set_of_books_id, /* set_of_books_id */

Line 2822: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */

2818: sysdate,
2819: arp_standard.profile.user_id,
2820: -3,
2821: ra.gl_date, /* original_gl_date */
2822: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
2823: p_adjustment_id,
2824: p_user_generated_flag,
2825: arp_standard.sysparm.org_id
2826: FROM

Line 2830: ra_cust_trx_line_gl_dist dist,

2826: FROM
2827: ra_customer_trx_lines l,
2828: ra_customer_trx h,
2829: fnd_currencies fc,
2830: ra_cust_trx_line_gl_dist dist,
2831: ar_revenue_assignments ra
2832: WHERE
2833: l.customer_trx_line_id = p_customer_trx_line_id
2834: AND fc.currency_code = h.invoice_currency_code

Line 2900: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

2896: l_rule_start_date DATE;
2897: l_deferred_revenue_flag VARCHAR2(1);
2898: l_gl_date DATE;
2899: l_gl_date_valid DATE;
2900: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
2901: l_revenue_type VARCHAR2(10);
2902: l_default_rule VARCHAR2(80);
2903: l_err_mesg VARCHAR2(2000);
2904:

Line 3346: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

3342: l_fail_count NUMBER := 0;
3343: l_ext_amount NUMBER := 0;
3344: l_acc_rule_duration NUMBER := 0;
3345: l_gl_date DATE;
3346: l_cr_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
3347: l_revenue_type VARCHAR2(10);
3348:
3349: l_warehouse_id NUMBER; -- Bug 1930302.
3350:

Line 3704: ra_cust_trx_line_gl_dist gl

3700: NVL(sum(gl.amount),0) amount,
3701: NVL(sum(gl.acctd_amount),0) acctd_amount,
3702: NVL(sum(gl.percent),0) percent
3703: FROM ra_customer_trx_lines l,
3704: ra_cust_trx_line_gl_dist gl
3705: WHERE l.customer_trx_line_id = p_customer_trx_line_id
3706: AND l.customer_trx_id = p_customer_trx_id
3707: AND l.line_type = 'LINE'
3708: AND l.customer_trx_line_id = gl.customer_trx_line_id (+)

Line 3988: FROM ra_cust_trx_line_gl_dist d

3984: invalid_lines EXCEPTION;
3985:
3986: CURSOR c_lines_from_total IS
3987: SELECT NVL(SUM(d.amount),0)
3988: FROM ra_cust_trx_line_gl_dist d
3989: ,mtl_item_categories mic
3990: ,ra_customer_trx_lines l
3991: WHERE d.customer_trx_line_id = l.customer_trx_line_id
3992: AND d.account_class = 'REV'

Line 4017: FROM ra_cust_trx_line_gl_dist d

4013: ,l.memo_line_id
4014: ,l.inventory_item_id
4015: ,l.accounting_rule_id
4016: ,NVL(SUM(d.amount),0) amount
4017: FROM ra_cust_trx_line_gl_dist d
4018: ,mtl_item_categories mic
4019: ,ra_customer_trx_lines l
4020: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4021: AND d.account_class = 'REV'

Line 4077: FROM ra_cust_trx_line_gl_dist d

4073: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id;
4074:
4075: CURSOR c_lines_to_total IS
4076: SELECT NVL(SUM(d.amount),0) amount
4077: FROM ra_cust_trx_line_gl_dist d
4078: ,mtl_item_categories mic
4079: ,ra_customer_trx_lines l
4080: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4081: AND d.account_class = 'REV'

Line 4126: FROM ra_cust_trx_line_gl_dist d

4122: ,l.inventory_item_id
4123: ,l.accounting_rule_id
4124: ,l.accounting_rule_duration
4125: ,SUM(d.amount) amount
4126: FROM ra_cust_trx_line_gl_dist d
4127: ,mtl_item_categories mic
4128: ,ra_customer_trx_lines l
4129: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4130: AND d.account_class = 'REV'

Line 4513: FROM ra_cust_trx_line_gl_dist

4509: l_percent_total NUMBER;
4510:
4511: CURSOR c_total IS
4512: SELECT NVL(SUM(amount),0)
4513: FROM ra_cust_trx_line_gl_dist
4514: WHERE customer_trx_line_id = p_customer_trx_line_id
4515: AND account_set_flag = 'N'
4516: AND account_class IN ('REV','UNEARN')
4517: AND NVL(amount,0) <> 0;

Line 4521: FROM ra_cust_trx_line_gl_dist

4517: AND NVL(amount,0) <> 0;
4518:
4519: CURSOR c_count IS
4520: SELECT COUNT(*)
4521: FROM ra_cust_trx_line_gl_dist
4522: WHERE customer_trx_line_id = p_customer_trx_line_id
4523: AND account_set_flag = 'N'
4524: AND NVL(amount,0) <> 0;
4525:

Line 4528: FROM ra_cust_trx_line_gl_dist

4524: AND NVL(amount,0) <> 0;
4525:
4526: CURSOR c_dist_lines IS
4527: SELECT rowid, amount
4528: FROM ra_cust_trx_line_gl_dist
4529: WHERE customer_trx_line_id = p_customer_trx_line_id
4530: AND account_set_flag = 'N'
4531: AND NVL(amount,0) <> 0;
4532:

Line 4554: UPDATE ra_cust_trx_line_gl_dist

4550: ELSE
4551: l_percent := ROUND(c1.amount / l_total * 100,4);
4552: l_percent_total := l_percent_total + l_percent;
4553: END IF;
4554: UPDATE ra_cust_trx_line_gl_dist
4555: SET percent = l_percent
4556: WHERE rowid = c1.rowid;
4557: END LOOP;
4558: IF PG_DEBUG in ('Y', 'C') THEN

Line 4984: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL

4980: END IF;
4981:
4982: IF g_update_db_flag = 'Y'
4983: THEN
4984: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
4985: INTO l_dist_id
4986: FROM dual;
4987:
4988: INSERT INTO ra_cust_trx_line_gl_dist

Line 4988: INSERT INTO ra_cust_trx_line_gl_dist

4984: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
4985: INTO l_dist_id
4986: FROM dual;
4987:
4988: INSERT INTO ra_cust_trx_line_gl_dist
4989: (cust_trx_line_gl_dist_id
4990: ,customer_trx_line_id
4991: ,code_combination_id
4992: ,set_of_books_id

Line 5119: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL

5115: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL
5116: FROM dual;
5117:
5118: CURSOR get_gldist_line_id IS
5119: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5120: FROM dual;
5121:
5122: l_user_id NUMBER;
5123: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;

Line 5123: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;

5119: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5120: FROM dual;
5121:
5122: l_user_id NUMBER;
5123: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5124: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5125: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5126: l_concat_segments VARCHAR2(2000);
5127: l_fail_count NUMBER := 0;

Line 5124: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;

5120: FROM dual;
5121:
5122: l_user_id NUMBER;
5123: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5124: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5125: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5126: l_concat_segments VARCHAR2(2000);
5127: l_fail_count NUMBER := 0;
5128:

Line 5125: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;

5121:
5122: l_user_id NUMBER;
5123: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5124: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5125: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5126: l_concat_segments VARCHAR2(2000);
5127: l_fail_count NUMBER := 0;
5128:
5129: invalid_ccid EXCEPTION;

Line 5272: INSERT INTO ra_cust_trx_line_gl_dist

5268: OPEN get_gldist_line_id;
5269: FETCH get_gldist_line_id INTO l_gl_dist_id;
5270: CLOSE get_gldist_line_id;
5271:
5272: INSERT INTO ra_cust_trx_line_gl_dist
5273: (
5274: customer_trx_line_id,
5275: customer_trx_id,
5276: code_combination_id,

Line 5395: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,

5391: (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
5392: p_category_id IN mtl_categories.category_id%TYPE,
5393: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
5394: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
5395: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,
5396: p_comments IN ar_revenue_adjustments.comments%TYPE,
5397: p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
5398: x_scenario OUT NOCOPY NUMBER,
5399: x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,