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_LINES

Line 483: ,ra_customer_trx_lines l

479: ,l.customer_trx_id
480: ,NVL(r.deferred_revenue_flag,'N') deferred_revenue_flag
481: ,l.extended_amount -- 7569247
482: FROM mtl_item_categories mic
483: ,ra_customer_trx_lines l
484: ,ra_rules r
485: WHERE l.line_type = 'LINE'
486: AND l.autorule_complete_flag IS NULL
487: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 1046: ,ra_customer_trx_lines l

1042: CURSOR c_trx_total IS
1043: SELECT SUM(NVL(s.revenue_amount_split,0))
1044: FROM ra_cust_trx_line_salesreps s
1045: ,mtl_item_categories mic
1046: ,ra_customer_trx_lines l
1047: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1048: AND l.line_type = 'LINE'
1049: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1050: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,

Line 1076: ,ra_customer_trx_lines l

1072: CURSOR c_rev_total IS
1073: SELECT NVL(SUM(d.amount),0)
1074: FROM ra_cust_trx_line_gl_dist d
1075: ,mtl_item_categories mic
1076: ,ra_customer_trx_lines l
1077: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1078: AND d.account_class = 'REV'
1079: AND l.line_type = 'LINE'
1080: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 1105: FROM ra_customer_trx_lines l

1101: SUM(NVL(s.revenue_percent_split,0))) <> 0);
1102:
1103: CURSOR c_nonrev_trx_total IS
1104: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1105: FROM ra_customer_trx_lines l
1106: ,mtl_item_categories mic
1107: ,ra_cust_trx_line_salesreps s
1108: WHERE l.customer_trx_line_id = s.customer_trx_line_id
1109: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,

Line 1126: ,ra_customer_trx_lines l

1122:
1123: CURSOR c_nonrev_line_count IS
1124: SELECT COUNT(*)
1125: FROM mtl_item_categories mic
1126: ,ra_customer_trx_lines l
1127: WHERE l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1128: l.customer_trx_line_id)
1129: AND NVL(l.inventory_item_id,0) =
1130: NVL(AR_RAAPI_UTIL.g_from_inventory_item_id,NVL(l.inventory_item_id,0))

Line 1160: ,ra_customer_trx_lines l

1156: ,l.warehouse_id
1157: ,l.line_number
1158: FROM ra_cust_trx_line_salesreps s
1159: ,mtl_item_categories mic
1160: ,ra_customer_trx_lines l
1161: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1162: AND l.customer_trx_line_id = s.customer_trx_line_id
1163: AND l.customer_trx_line_id =
1164: NVL (AR_RAAPI_UTIL.g_from_cust_trx_line_id, l.customer_trx_line_id)

Line 1220: ra_customer_trx_lines l

1216:
1217: CURSOR c_cm_line_revenue_total IS
1218: SELECT NVL(SUM(d.amount),0)
1219: FROM ra_cust_trx_line_gl_dist d,
1220: ra_customer_trx_lines l
1221: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1222: AND d.customer_trx_id = l.customer_trx_id
1223: AND l.previous_customer_trx_line_id = l_cust_trx_line_id
1224: AND l.previous_customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 1241: ra_customer_trx_lines l

1237: SUM(NVL(s.revenue_percent_split,0)) revenue_percent_split,
1238: SUM(NVL(s.non_revenue_amount_split,0)) nonrev_amount_split,
1239: SUM(NVL(s.non_revenue_percent_split,0)) nonrev_percent_split
1240: FROM ra_cust_trx_line_salesreps s,
1241: ra_customer_trx_lines l
1242: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1243: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1244: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
1245: 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 1256: ra_customer_trx_lines l

1252: NVL(SUM(s.revenue_percent_split),0),
1253: NVL(SUM(s.non_revenue_amount_split),0),
1254: NVL(SUM(s.non_revenue_percent_split),0)
1255: FROM ra_cust_trx_line_salesreps s,
1256: ra_customer_trx_lines l
1257: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1258: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
1259: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
1260: 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 2139: ,ra_customer_trx_lines l

2135: CURSOR c_trx_total IS
2136: SELECT SUM(NVL(s.revenue_amount_split,0))
2137: FROM ra_cust_trx_line_salesreps s
2138: ,mtl_item_categories mic
2139: ,ra_customer_trx_lines l
2140: WHERE s.customer_trx_line_id = l.customer_trx_line_id
2141: AND l.line_type = 'LINE'
2142: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2143: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,

Line 2156: ,ra_customer_trx_lines l

2152:
2153: CURSOR c_line_count IS
2154: SELECT COUNT(*)
2155: FROM mtl_item_categories mic
2156: ,ra_customer_trx_lines l
2157: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2158: AND l.line_type = 'LINE'
2159: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
2160: l.customer_trx_line_id)

Line 2175: ,ra_customer_trx_lines l

2171: ,l.line_number
2172: ,SUM(NVL(s.revenue_amount_split,0)) amount
2173: FROM mtl_item_categories mic
2174: ,ra_cust_trx_line_salesreps s
2175: ,ra_customer_trx_lines l
2176: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2177: AND l.customer_trx_line_id = s.customer_trx_line_id
2178: AND l.customer_trx_line_id =
2179: NVL (AR_RAAPI_UTIL.g_from_cust_trx_line_id, l.customer_trx_line_id)

Line 2197: ra_customer_trx_lines l

2193: NVL(SUM(s.revenue_percent_split),0),
2194: NVL(SUM(s.non_revenue_amount_split),0),
2195: NVL(SUM(s.non_revenue_percent_split),0)
2196: FROM ra_cust_trx_line_salesreps s,
2197: ra_customer_trx_lines l
2198: WHERE s.customer_trx_line_id = l_cust_trx_line_id
2199: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
2200: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
2201: 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 2549: FROM ra_customer_trx_lines l,

2545: l.extended_amount,
2546: l.accounting_rule_duration,
2547: r.deferred_revenue_flag,
2548: l.rule_start_date
2549: FROM ra_customer_trx_lines l,
2550: ra_rules r
2551: WHERE l.accounting_rule_id = r.rule_id
2552: AND l.customer_trx_line_id = p_customer_trx_line_id
2553: AND l.customer_trx_id = p_customer_trx_id

Line 2842: ra_customer_trx_lines l,

2838: l.warehouse_id,
2839: l.override_auto_accounting_flag,
2840: srep.salesrep_id
2841: FROM
2842: ra_customer_trx_lines l,
2843: ra_customer_trx h,
2844: fnd_currencies fc,
2845: ra_cust_trx_line_gl_dist dist,
2846: ra_cust_trx_line_salesreps srep,

Line 2900: /* update ra_customer_trx_lines to set RSD to override */

2896: IF PG_DEBUG in ('Y', 'C') THEN
2897: arp_util.debug('Setting RSD from ' || p_rule_start_date ||
2898: ' to ' || p_original_gl_date);
2899: END IF;
2900: /* update ra_customer_trx_lines to set RSD to override */
2901: UPDATE ra_customer_trx_lines
2902: SET rule_start_date = p_original_gl_date
2903: WHERE customer_trx_line_id = p_customer_trx_line_id;
2904: END IF;

Line 2901: UPDATE ra_customer_trx_lines

2897: arp_util.debug('Setting RSD from ' || p_rule_start_date ||
2898: ' to ' || p_original_gl_date);
2899: END IF;
2900: /* update ra_customer_trx_lines to set RSD to override */
2901: UPDATE ra_customer_trx_lines
2902: SET rule_start_date = p_original_gl_date
2903: WHERE customer_trx_line_id = p_customer_trx_line_id;
2904: END IF;
2905:

Line 3024: /* update ra_customer_trx_lines to return RSD to original */

3020: IF PG_DEBUG in ('Y', 'C') THEN
3021: arp_util.debug('Setting RSD back from ' || p_original_gl_date ||
3022: ' to ' || p_rule_start_date);
3023: END IF;
3024: /* update ra_customer_trx_lines to return RSD to original */
3025: UPDATE ra_customer_trx_lines
3026: SET rule_start_date = p_rule_start_date
3027: WHERE customer_trx_line_id = p_customer_trx_line_id;
3028: END IF;

Line 3025: UPDATE ra_customer_trx_lines

3021: arp_util.debug('Setting RSD back from ' || p_original_gl_date ||
3022: ' to ' || p_rule_start_date);
3023: END IF;
3024: /* update ra_customer_trx_lines to return RSD to original */
3025: UPDATE ra_customer_trx_lines
3026: SET rule_start_date = p_rule_start_date
3027: WHERE customer_trx_line_id = p_customer_trx_line_id;
3028: END IF;
3029:

Line 3153: FROM ra_customer_trx_lines l,

3149: l.accounting_rule_duration,
3150: r.deferred_revenue_flag,
3151: l.warehouse_id,
3152: l.rule_start_date
3153: FROM ra_customer_trx_lines l,
3154: ra_rules r
3155: WHERE l.accounting_rule_id = r.rule_id
3156: AND l.customer_trx_line_id = p_customer_trx_line_id
3157: AND l.customer_trx_id = p_customer_trx_id

Line 3585: FROM ra_customer_trx_lines

3581: line_number,
3582: extended_amount,
3583: warehouse_id,
3584: accounting_rule_duration
3585: FROM ra_customer_trx_lines
3586: WHERE customer_trx_line_id = p_customer_trx_line_id
3587: AND customer_trx_id = p_customer_trx_id
3588: AND line_type = 'LINE';
3589:

Line 3905: FROM ra_customer_trx_lines l,

3901: gl.code_combination_id,
3902: NVL(sum(gl.amount),0) amount,
3903: NVL(sum(gl.acctd_amount),0) acctd_amount,
3904: NVL(sum(gl.percent),0) percent
3905: FROM ra_customer_trx_lines l,
3906: ra_cust_trx_line_gl_dist gl
3907: WHERE l.customer_trx_line_id = p_customer_trx_line_id
3908: AND l.customer_trx_id = p_customer_trx_id
3909: AND l.line_type = 'LINE'

Line 4206: ,ra_customer_trx_lines l

4202: CURSOR c_lines_from_total IS
4203: SELECT NVL(SUM(d.amount),0)
4204: FROM ra_cust_trx_line_gl_dist d
4205: ,mtl_item_categories mic
4206: ,ra_customer_trx_lines l
4207: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4208: AND d.account_class = 'REV'
4209: AND l.line_type = 'LINE'
4210: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4235: ,ra_customer_trx_lines l

4231: ,l.accounting_rule_id
4232: ,NVL(SUM(d.amount),0) amount
4233: FROM ra_cust_trx_line_gl_dist d
4234: ,mtl_item_categories mic
4235: ,ra_customer_trx_lines l
4236: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4237: AND d.account_class = 'REV'
4238: AND l.line_type = 'LINE'
4239: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4271: FROM ra_customer_trx_lines line

4267: CURSOR c_tax_rate_count IS
4268: SELECT NVL(COUNT(DISTINCT tax.item_exception_rate_id||
4269: tax.tax_exemption_id|| tax.vat_tax_id||
4270: tax.sales_tax_id|| tax.tax_rate|| tax.tax_precedence),0)
4271: FROM ra_customer_trx_lines line
4272: ,mtl_item_categories mic
4273: ,ra_customer_trx_lines tax
4274: WHERE line.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4275: AND tax.line_type = 'TAX'

Line 4273: ,ra_customer_trx_lines tax

4269: tax.tax_exemption_id|| tax.vat_tax_id||
4270: tax.sales_tax_id|| tax.tax_rate|| tax.tax_precedence),0)
4271: FROM ra_customer_trx_lines line
4272: ,mtl_item_categories mic
4273: ,ra_customer_trx_lines tax
4274: WHERE line.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4275: AND tax.line_type = 'TAX'
4276: AND line.customer_trx_line_id = tax.link_to_cust_trx_line_id
4277: AND line.customer_trx_line_id IN

Line 4295: ,ra_customer_trx_lines l

4291: CURSOR c_lines_to_total IS
4292: SELECT NVL(SUM(d.amount),0) amount
4293: FROM ra_cust_trx_line_gl_dist d
4294: ,mtl_item_categories mic
4295: ,ra_customer_trx_lines l
4296: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4297: AND d.account_class = 'REV'
4298: AND l.line_type = 'LINE'
4299: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4317: ,ra_customer_trx_lines l

4313:
4314: CURSOR c_line_to_count IS
4315: SELECT COUNT(*)
4316: FROM mtl_item_categories mic
4317: ,ra_customer_trx_lines l
4318: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4319: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_to_cust_trx_line_id,
4320: l.customer_trx_line_id)
4321: AND NVL(l.inventory_item_id,0) =

Line 4344: ,ra_customer_trx_lines l

4340: ,l.accounting_rule_duration
4341: ,SUM(d.amount) amount
4342: FROM ra_cust_trx_line_gl_dist d
4343: ,mtl_item_categories mic
4344: ,ra_customer_trx_lines l
4345: WHERE d.customer_trx_line_id = l.customer_trx_line_id
4346: AND d.account_class = 'REV'
4347: AND l.line_type = 'LINE'
4348: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id

Line 4989: FROM ra_customer_trx_lines

4985: HAVING SUM(NVL(revenue_percent_split,0)) <> 0);
4986:
4987: CURSOR c_line IS
4988: SELECT extended_amount, warehouse_id
4989: FROM ra_customer_trx_lines
4990: WHERE customer_trx_line_id = p_customer_trx_line_id;
4991:
4992: CURSOR c_salesrep IS
4993: SELECT salesrep_id,

Line 5178: FROM ra_customer_trx_lines

5174: l_user_id NUMBER;
5175:
5176: CURSOR cu_trx IS
5177: SELECT customer_trx_id
5178: FROM ra_customer_trx_lines
5179: WHERE customer_trx_line_id = p_customer_trx_line_id;
5180:
5181: l_trx_id NUMBER;
5182: l_xla_event arp_xla_events.xla_events_type;

Line 5432: FROM RA_CUSTOMER_TRX_LINES

5428: ELSE
5429: /* fetch warehouse, etc for this line */
5430: SELECT inventory_item_id, memo_line_id, warehouse_id
5431: INTO g_inventory_item_id, g_memo_line_id, g_warehouse_id
5432: FROM RA_CUSTOMER_TRX_LINES
5433: WHERE customer_trx_line_id = p_cust_trx_line_id;
5434:
5435: g_line_id := p_cust_trx_line_id;
5436:

Line 5615: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,

5611: PROCEDURE Record_Acceptance
5612: (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
5613: p_category_id IN mtl_categories.category_id%TYPE,
5614: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
5615: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
5616: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,
5617: p_comments IN ar_revenue_adjustments.comments%TYPE,
5618: p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
5619: x_scenario OUT NOCOPY NUMBER,

Line 5638: ,ra_customer_trx_lines l

5634: CURSOR c_line IS
5635: SELECT l.customer_trx_line_id
5636: FROM mtl_item_categories mic
5637: ,ra_rules r
5638: ,ra_customer_trx_lines l
5639: WHERE l.customer_trx_id = p_customer_trx_id
5640: AND l.accounting_rule_id = r.rule_id(+)
5641: AND NVL(l.inventory_item_id,0) =
5642: NVL(p_inventory_item_id,NVL(l.inventory_item_id,0))