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_CUSTOMER_TRX

Line 476: ,ra_customer_trx_lines l

472: ,l.accounting_rule_duration -- Bug 2168875
473: ,NVL(l.override_auto_accounting_flag,'N')
474: override_auto_accounting_flag-- Bug 3879222
475: FROM mtl_item_categories mic
476: ,ra_customer_trx_lines l
477: WHERE l.line_type = 'LINE'
478: AND l.autorule_complete_flag IS NULL
479: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
480: AND l.customer_trx_line_id =

Line 969: ,ra_customer_trx_lines l

965: CURSOR c_trx_total IS
966: SELECT SUM(NVL(s.revenue_amount_split,0))
967: FROM ra_cust_trx_line_salesreps s
968: ,mtl_item_categories mic
969: ,ra_customer_trx_lines l
970: WHERE s.customer_trx_line_id = l.customer_trx_line_id
971: AND l.line_type = 'LINE'
972: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
973: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,

Line 999: ,ra_customer_trx_lines l

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'
1002: AND l.line_type = 'LINE'
1003: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 1028: FROM ra_customer_trx_lines l

1024: SUM(NVL(s.revenue_percent_split,0))) <> 0);
1025:
1026: CURSOR c_nonrev_trx_total IS
1027: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1028: FROM ra_customer_trx_lines l
1029: ,mtl_item_categories mic
1030: ,ra_cust_trx_line_salesreps s
1031: WHERE l.customer_trx_line_id = s.customer_trx_line_id
1032: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,

Line 1049: ,ra_customer_trx_lines l

1045:
1046: CURSOR c_nonrev_line_count IS
1047: SELECT COUNT(*)
1048: FROM mtl_item_categories mic
1049: ,ra_customer_trx_lines l
1050: WHERE l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1051: l.customer_trx_line_id)
1052: AND NVL(l.inventory_item_id,0) =
1053: NVL(AR_RAAPI_UTIL.g_from_inventory_item_id,NVL(l.inventory_item_id,0))

Line 1083: ,ra_customer_trx_lines l

1079: ,l.warehouse_id
1080: ,l.line_number
1081: FROM ra_cust_trx_line_salesreps s
1082: ,mtl_item_categories mic
1083: ,ra_customer_trx_lines l
1084: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1085: AND l.customer_trx_line_id = s.customer_trx_line_id
1086: AND l.customer_trx_line_id =
1087: NVL (AR_RAAPI_UTIL.g_from_cust_trx_line_id, l.customer_trx_line_id)

Line 1143: ra_customer_trx_lines l

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
1147: AND l.previous_customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 1164: ra_customer_trx_lines l

1160: SUM(NVL(s.revenue_percent_split,0)) revenue_percent_split,
1161: SUM(NVL(s.non_revenue_amount_split,0)) nonrev_amount_split,
1162: SUM(NVL(s.non_revenue_percent_split,0)) nonrev_percent_split
1163: FROM ra_cust_trx_line_salesreps s,
1164: ra_customer_trx_lines l
1165: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1166: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1167: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
1168: NVL(AR_RAAPI_UTIL.g_from_salesgroup_id, DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)))

Line 1179: ra_customer_trx_lines l

1175: NVL(SUM(s.revenue_percent_split),0),
1176: NVL(SUM(s.non_revenue_amount_split),0),
1177: NVL(SUM(s.non_revenue_percent_split),0)
1178: FROM ra_cust_trx_line_salesreps s,
1179: ra_customer_trx_lines l
1180: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1181: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
1182: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
1183: NVL(AR_RAAPI_UTIL.g_to_salesgroup_id, DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)))

Line 2062: ,ra_customer_trx_lines l

2058: CURSOR c_trx_total IS
2059: SELECT SUM(NVL(s.revenue_amount_split,0))
2060: FROM ra_cust_trx_line_salesreps s
2061: ,mtl_item_categories mic
2062: ,ra_customer_trx_lines l
2063: WHERE s.customer_trx_line_id = l.customer_trx_line_id
2064: AND l.line_type = 'LINE'
2065: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2066: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,

Line 2079: ,ra_customer_trx_lines l

2075:
2076: CURSOR c_line_count IS
2077: SELECT COUNT(*)
2078: FROM mtl_item_categories mic
2079: ,ra_customer_trx_lines l
2080: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2081: AND l.line_type = 'LINE'
2082: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
2083: l.customer_trx_line_id)

Line 2098: ,ra_customer_trx_lines l

2094: ,l.line_number
2095: ,SUM(NVL(s.revenue_amount_split,0)) amount
2096: FROM mtl_item_categories mic
2097: ,ra_cust_trx_line_salesreps s
2098: ,ra_customer_trx_lines l
2099: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2100: AND l.customer_trx_line_id = s.customer_trx_line_id
2101: AND l.customer_trx_line_id =
2102: NVL (AR_RAAPI_UTIL.g_from_cust_trx_line_id, l.customer_trx_line_id)

Line 2120: ra_customer_trx_lines l

2116: NVL(SUM(s.revenue_percent_split),0),
2117: NVL(SUM(s.non_revenue_amount_split),0),
2118: NVL(SUM(s.non_revenue_percent_split),0)
2119: FROM ra_cust_trx_line_salesreps s,
2120: ra_customer_trx_lines l
2121: WHERE s.customer_trx_line_id = l_cust_trx_line_id
2122: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
2123: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
2124: NVL(AR_RAAPI_UTIL.g_to_salesgroup_id, DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)))

Line 2472: FROM ra_customer_trx_lines l,

2468: l.extended_amount,
2469: l.accounting_rule_duration,
2470: r.deferred_revenue_flag,
2471: l.rule_start_date
2472: FROM ra_customer_trx_lines l,
2473: ra_rules r
2474: WHERE l.accounting_rule_id = r.rule_id
2475: AND l.customer_trx_line_id = p_customer_trx_line_id
2476: AND l.customer_trx_id = p_customer_trx_id

Line 2718: FROM ra_customer_trx_lines

2714:
2715: --{BUG#5064609
2716: CURSOR cu_trx IS
2717: SELECT customer_trx_id
2718: FROM ra_customer_trx_lines
2719: WHERE customer_trx_line_id = p_customer_trx_line_id;
2720: l_trx_id NUMBER;
2721: l_xla_event arp_xla_events.xla_events_type;
2722: --}

Line 2777: ra.customer_trx_line_id, /* customer_trx_line_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 */
2781: ra.account_class, /* account_class */

Line 2827: ra_customer_trx_lines l,

2823: p_adjustment_id,
2824: p_user_generated_flag,
2825: arp_standard.sysparm.org_id
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

Line 2828: ra_customer_trx h,

2824: p_user_generated_flag,
2825: arp_standard.sysparm.org_id
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

Line 2836: AND ra.customer_trx_line_id = l.customer_trx_line_id

2832: WHERE
2833: l.customer_trx_line_id = p_customer_trx_line_id
2834: AND fc.currency_code = h.invoice_currency_code
2835: AND l.customer_trx_id = h.customer_trx_id
2836: AND ra.customer_trx_line_id = l.customer_trx_line_id
2837: AND ra.period_set_name = g_period_set_name
2838: AND dist.customer_trx_line_id= ra.customer_trx_line_id
2839: AND dist.account_class = ra.account_class
2840: AND dist.account_set_flag = 'Y'; /* model accounts */

Line 2838: AND dist.customer_trx_line_id= ra.customer_trx_line_id

2834: AND fc.currency_code = h.invoice_currency_code
2835: AND l.customer_trx_id = h.customer_trx_id
2836: AND ra.customer_trx_line_id = l.customer_trx_line_id
2837: AND ra.period_set_name = g_period_set_name
2838: AND dist.customer_trx_line_id= ra.customer_trx_line_id
2839: AND dist.account_class = ra.account_class
2840: AND dist.account_set_flag = 'Y'; /* model accounts */
2841:
2842: /* Call MRC for inserts/updates if we have rows to

Line 2968: FROM ra_customer_trx_lines l,

2964: l.accounting_rule_duration,
2965: r.deferred_revenue_flag,
2966: l.warehouse_id,
2967: l.rule_start_date
2968: FROM ra_customer_trx_lines l,
2969: ra_rules r
2970: WHERE l.accounting_rule_id = r.rule_id
2971: AND l.customer_trx_line_id = p_customer_trx_line_id
2972: AND l.customer_trx_id = p_customer_trx_id

Line 3392: FROM ra_customer_trx_lines

3388: line_number,
3389: extended_amount,
3390: warehouse_id,
3391: accounting_rule_duration
3392: FROM ra_customer_trx_lines
3393: WHERE customer_trx_line_id = p_customer_trx_line_id
3394: AND customer_trx_id = p_customer_trx_id
3395: AND line_type = 'LINE';
3396:

Line 3703: FROM ra_customer_trx_lines l,

3699: gl.code_combination_id,
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'

Line 3990: ,ra_customer_trx_lines l

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'
3993: AND l.line_type = 'LINE'
3994: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4019: ,ra_customer_trx_lines l

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'
4022: AND l.line_type = 'LINE'
4023: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4055: FROM ra_customer_trx_lines line

4051: CURSOR c_tax_rate_count IS
4052: SELECT NVL(COUNT(DISTINCT tax.item_exception_rate_id||
4053: tax.tax_exemption_id|| tax.vat_tax_id||
4054: tax.sales_tax_id|| tax.tax_rate|| tax.tax_precedence),0)
4055: FROM ra_customer_trx_lines line
4056: ,mtl_item_categories mic
4057: ,ra_customer_trx_lines tax
4058: WHERE line.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4059: AND tax.line_type = 'TAX'

Line 4057: ,ra_customer_trx_lines tax

4053: tax.tax_exemption_id|| tax.vat_tax_id||
4054: tax.sales_tax_id|| tax.tax_rate|| tax.tax_precedence),0)
4055: FROM ra_customer_trx_lines line
4056: ,mtl_item_categories mic
4057: ,ra_customer_trx_lines tax
4058: WHERE line.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4059: AND tax.line_type = 'TAX'
4060: AND line.customer_trx_line_id = tax.link_to_cust_trx_line_id
4061: AND line.customer_trx_line_id IN

Line 4079: ,ra_customer_trx_lines l

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'
4082: AND l.line_type = 'LINE'
4083: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4101: ,ra_customer_trx_lines l

4097:
4098: CURSOR c_line_to_count IS
4099: SELECT COUNT(*)
4100: FROM mtl_item_categories mic
4101: ,ra_customer_trx_lines l
4102: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4103: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_to_cust_trx_line_id,
4104: l.customer_trx_line_id)
4105: AND NVL(l.inventory_item_id,0) =

Line 4128: ,ra_customer_trx_lines l

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'
4131: AND l.line_type = 'LINE'
4132: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4764: FROM ra_customer_trx_lines

4760: HAVING SUM(NVL(revenue_percent_split,0)) <> 0);
4761:
4762: CURSOR c_line IS
4763: SELECT extended_amount, warehouse_id
4764: FROM ra_customer_trx_lines
4765: WHERE customer_trx_line_id = p_customer_trx_line_id;
4766:
4767: CURSOR c_salesrep IS
4768: SELECT salesrep_id,

Line 4953: FROM ra_customer_trx_lines

4949: l_user_id NUMBER;
4950:
4951: CURSOR cu_trx IS
4952: SELECT customer_trx_id
4953: FROM ra_customer_trx_lines
4954: WHERE customer_trx_line_id = p_customer_trx_line_id;
4955:
4956: l_trx_id NUMBER;
4957: l_xla_event arp_xla_events.xla_events_type;

Line 5211: FROM RA_CUSTOMER_TRX_LINES

5207: ELSE
5208: /* fetch warehouse, etc for this line */
5209: SELECT inventory_item_id, memo_line_id, warehouse_id
5210: INTO g_inventory_item_id, g_memo_line_id, g_warehouse_id
5211: FROM RA_CUSTOMER_TRX_LINES
5212: WHERE customer_trx_line_id = p_cust_trx_line_id;
5213:
5214: g_line_id := p_cust_trx_line_id;
5215:

Line 5391: (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

5387: --
5388: --
5389: -- Notes :
5390: PROCEDURE Record_Acceptance
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,

Line 5394: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,

5390: PROCEDURE Record_Acceptance
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,

Line 5417: ,ra_customer_trx_lines l

5413: CURSOR c_line IS
5414: SELECT l.customer_trx_line_id
5415: FROM mtl_item_categories mic
5416: ,ra_rules r
5417: ,ra_customer_trx_lines l
5418: WHERE l.customer_trx_id = p_customer_trx_id
5419: AND l.accounting_rule_id = r.rule_id(+)
5420: AND NVL(l.inventory_item_id,0) =
5421: NVL(p_inventory_item_id,NVL(l.inventory_item_id,0))