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_MANAGEMENT_PVT dependencies on AR_DEFERRAL_REASONS

Line 519: ar_deferral_reasons dr,

515: max(interface_line_attribute6),
516: l_request_id
517: FROM ar_deferred_lines dl,
518: ar_line_conts lc,
519: ar_deferral_reasons dr,
520: ra_customer_trx_lines ctl
521: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
522: AND lc.contingency_id = dr.contingency_id
523: AND ctl.customer_trx_line_id = lc.customer_trx_line_id

Line 567: ar_deferral_reasons dr,

563: max(interface_line_attribute6),
564: l_request_id
565: FROM ar_deferred_lines dl,
566: ar_line_conts lc,
567: ar_deferral_reasons dr,
568: ra_customer_trx_lines ctl
569: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
570: AND lc.contingency_id = dr.contingency_id
571: AND ctl.customer_trx_line_id = lc.customer_trx_line_id

Line 739: ar_deferral_reasons dr

735: ra_customer_trx_lines parent_line,
736: ar_deferred_lines child,
737: ra_customer_trx_lines child_line,
738: ar_line_conts lc,
739: ar_deferral_reasons dr
740: WHERE parent.customer_trx_id = parent_line.customer_trx_id
741: AND parent.customer_trx_line_id = parent_line.customer_trx_line_id
742: AND parent_line.interface_line_context = g_om_context
743: AND to_char(child.parent_line_id) = parent.so_line_id

Line 825: ar_deferral_reasons dr

821: l_request_id,
822: max(lc.expiration_date)
823: FROM ar_deferred_lines dl,
824: ar_line_conts lc,
825: ar_deferral_reasons dr
826: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
827: AND lc.contingency_id = dr.contingency_id
828: AND lc.completed_flag = 'N'
829: AND line_collectible_flag = 'N' -- not collectilbe

Line 871: ar_deferral_reasons dr

867: 'UPDATE',
868: l_request_id
869: FROM ar_deferred_lines dl,
870: ar_line_conts lc,
871: ar_deferral_reasons dr
872: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
873: AND lc.contingency_id = dr.contingency_id
874: AND line_collectible_flag = 'N' -- not collectilbe
875: AND manual_override_flag = 'N' -- not manually overridden in

Line 1055: ar_deferral_reasons dr

1051: CURSOR alc (p_req_id NUMBER, p_line_id NUMBER) IS
1052: select lc.customer_trx_line_id, lc.contingency_id,
1053: dr.policy_attached
1054: from ar_line_conts lc,
1055: ar_deferral_reasons dr
1056: where lc.contingency_id = dr.contingency_id
1057: and ((p_req_id IS NULL and p_line_id IS NOT NULL AND
1058: lc.customer_trx_line_id = p_line_id) OR
1059: (p_req_id IS NOT NULL AND lc.request_id = p_req_id));

Line 1097: FROM ar_deferral_reasons dr

1093: AND trunc(expiration_date) - trunc(sysdate) <
1094: NVL(arp_standard.sysparm.standard_refund,0)
1095: AND EXISTS
1096: (SELECT 'its a refund contingency'
1097: FROM ar_deferral_reasons dr
1098: WHERE dr.contingency_id = lrc.contingency_id
1099: AND dr.policy_attached in ('REFUND','REFUND_POLICY'));
1100:
1101: debug('refund contingencies deleted: ' || SQL%ROWCOUNT);

Line 1120: FROM ar_deferral_reasons dr

1116: AND ar_revenue_management_pvt.creditworthy
1117: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 1)
1118: AND EXISTS
1119: (SELECT 'its a CREDIT_CLASSIFICATION'
1120: FROM ar_deferral_reasons dr
1121: WHERE dr.contingency_id = lc.contingency_id
1122: AND dr.policy_attached = 'CREDIT_CLASSIFICATION');
1123:
1124: IF PG_DEBUG IN ('Y','C')

Line 1149: FROM ar_deferral_reasons dr

1145: HAVING NVL(max(due_days),0) <=
1146: NVL(arp_standard.sysparm.payment_threshold,0))
1147: AND EXISTS
1148: (SELECT 'its a PAYMENT_TERM'
1149: FROM ar_deferral_reasons dr
1150: WHERE dr.policy_attached = 'PAYMENT_TERM'
1151: AND dr.contingency_id = lc.contingency_id);
1152:
1153: IF PG_DEBUG IN ('Y','C')

Line 1190: FROM ar_deferral_reasons dr

1186: NVL(arp_standard.sysparm.standard_refund,0)
1187: AND lrc.customer_trx_line_id = p_customer_trx_line_id
1188: AND EXISTS
1189: (SELECT 'a refund contingency'
1190: FROM ar_deferral_reasons dr
1191: WHERE dr.policy_attached in ('REFUND','REFUND_POLICY')
1192: AND dr.contingency_id = lrc.contingency_id);
1193:
1194: debug('refund contingencies deleted: ' || SQL%ROWCOUNT);

Line 1206: FROM ar_deferral_reasons dr

1202: FROM ar_line_conts lc
1203: WHERE lc.customer_trx_line_id = p_customer_trx_line_id
1204: AND EXISTS
1205: (SELECT 'its a credit_classification contingency'
1206: FROM ar_deferral_reasons dr
1207: WHERE dr.contingency_id = lc.contingency_id
1208: AND dr.policy_attached = 'CREDIT_CLASSIFICATION')
1209: AND EXISTS
1210: (SELECT 'customer is not credit worthy'

Line 1233: FROM ar_deferral_reasons dr

1229: FROM ar_line_conts lc
1230: WHERE lc.customer_trx_line_id = p_customer_trx_line_id
1231: AND EXISTS
1232: (SELECT 'it is a term contingency'
1233: FROM ar_deferral_reasons dr
1234: WHERE dr.policy_attached = 'PAYMENT_TERM'
1235: AND dr.contingency_id = lc.contingency_id)
1236: AND EXISTS
1237: (SELECT 'term exceeds threshold'

Line 1324: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;

1320:
1321: /* This function returns the customer_trx_line_id of the parent line
1322: after fetching the attribute values from OM */
1323: FUNCTION get_line_id(p_so_line_id IN NUMBER) RETURN NUMBER IS
1324: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;
1325: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1326: l_msg_count NUMBER;
1327: l_msg_data VARCHAR2(2000);
1328: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

Line 1681: ar_deferral_reasons dr,

1677: sysdate,
1678: l_user_id,
1679: ct.org_id
1680: FROM fun_rule_bulk_result_gt rbr,
1681: ar_deferral_reasons dr,
1682: ra_customer_trx_lines ctl,
1683: ra_customer_trx ct,
1684: ra_cust_trx_types ctt
1685: WHERE rbr.result_value = dr.contingency_id

Line 1753: ar_deferral_reasons dr,

1749: sysdate,
1750: l_user_id,
1751: ct.org_id
1752: FROM fun_rule_bulk_result_gt rbr,
1753: ar_deferral_reasons dr,
1754: ra_customer_trx_lines ctl,
1755: ra_customer_trx ct,
1756: ra_cust_trx_types ctt
1757: WHERE rbr.result_value = dr.contingency_id

Line 1865: ar_deferral_reasons dr

1861: FROM ar_trx_lines_gt tlg,
1862: ar_trx_header_gt thg,
1863: ra_cust_trx_types ctt,
1864: ar_trx_contingencies_gt tcg,
1865: ar_deferral_reasons dr
1866: WHERE tlg.request_id = p_request_id
1867: AND tlg.trx_header_id = thg.trx_header_id
1868: AND thg.batch_source_id NOT IN (20, 21)
1869: AND thg.cust_trx_type_id = ctt.cust_trx_type_id

Line 1971: ar_deferral_reasons dr

1967: FROM ra_customer_trx_lines ctl,
1968: ra_customer_trx ct,
1969: ra_cust_trx_types ctt,
1970: ar_interface_conts ic,
1971: ar_deferral_reasons dr
1972: WHERE ctl.request_id = p_request_id
1973: AND ctl.customer_trx_id = ct.customer_trx_id
1974: AND ct.batch_source_id NOT IN (20, 21)
1975: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 2420: FROM ar_deferral_reasons l

2416: AND cgt.trx_line_id = lgt.trx_line_id
2417: AND NOT EXISTS
2418: (
2419: SELECT 'valid lookup code'
2420: FROM ar_deferral_reasons l
2421: WHERE l.contingency_id = cgt.contingency_id
2422: );
2423:
2424: l_error_count := SQL%ROWCOUNT;

Line 2456: ar_deferral_reasons dr

2452: cgt.contingency_id
2453: FROM ar_trx_lines_gt lgt,
2454: ar_trx_header_gt hgt,
2455: ar_trx_contingencies_gt cgt,
2456: ar_deferral_reasons dr
2457: WHERE lgt.trx_header_id = hgt.trx_header_id
2458: AND cgt.trx_line_id = lgt.trx_line_id
2459: AND cgt.contingency_id = dr.contingency_id
2460: AND cgt.expiration_date IS NOT NULL

Line 2524: FROM ar_deferral_reasons l

2520: AND c.interface_line_id = l.interface_line_id
2521: AND NOT EXISTS
2522: (
2523: SELECT 'valid lookup code'
2524: FROM ar_deferral_reasons l
2525: WHERE l.contingency_id = c.contingency_id
2526: );
2527:
2528: l_error_count := SQL%ROWCOUNT;

Line 2559: ar_deferral_reasons dr

2555: c.contingency_id,
2556: l.org_id
2557: FROM ra_interface_lines l,
2558: ar_interface_conts c,
2559: ar_deferral_reasons dr
2560: WHERE l.request_id = p_request_id
2561: AND c.interface_line_id = l.interface_line_id
2562: AND dr.contingency_id = c.contingency_id
2563: AND c.expiration_date IS NOT NULL

Line 3028: ar_deferral_reasons dr

3024: -- was waiting for this event.
3025: CURSOR conts IS
3026: SELECT dr.contingency_id, revrec_event_code, expiration_event_code
3027: FROM ar_line_conts lc,
3028: ar_deferral_reasons dr
3029: WHERE lc.contingency_id = dr.contingency_id
3030: AND lc.customer_trx_line_id = p_cust_trx_line_id
3031: AND (dr.revrec_event_code = p_event_code OR
3032: dr.expiration_event_code = p_event_code);

Line 4102: ar_deferral_reasons dr

4098: SELECT lc.customer_trx_line_id,
4099: lc.contingency_id,
4100: lc.expiration_date
4101: FROM ar_line_conts lc,
4102: ar_deferral_reasons dr
4103: WHERE lc.customer_trx_line_id = p_customer_trx_line_id
4104: AND lc.contingency_id = dr.contingency_id
4105: AND lc.completed_flag = 'N'
4106: AND lc.expiration_date IS NOT NULL

Line 4160: ar_deferral_reasons dr

4156:
4157: CURSOR cash_based IS
4158: SELECT 1
4159: FROM ar_line_conts lc,
4160: ar_deferral_reasons dr
4161: WHERE lc.contingency_id = dr.contingency_id
4162: AND lc.customer_trx_line_id = p_cust_trx_line_id
4163: AND lc.completed_flag = 'N'
4164: AND dr.revrec_event_code = 'RECEIPT_APPLICATION';

Line 4170: ar_deferral_reasons dr

4166:
4167: CURSOR contingency_based IS
4168: SELECT 1
4169: FROM ar_line_conts lc,
4170: ar_deferral_reasons dr
4171: WHERE lc.contingency_id = dr.contingency_id
4172: AND lc.customer_trx_line_id = p_cust_trx_line_id
4173: AND lc.completed_flag = 'N'
4174: AND dr.revrec_event_code <> 'RECEIPT_APPLICATION';

Line 4848: ar_deferral_reasons dl

4844: CURSOR contingencies IS
4845: SELECT 1
4846: FROM ar_deferred_lines dl,
4847: ar_line_conts lc,
4848: ar_deferral_reasons dl
4849: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
4850: AND lc.contingency_id = dl.contingency_id
4851: AND lc.completed_flag = 'N'
4852: AND dl.customer_trx_id = p_customer_trx_id

Line 4961: ar_deferral_reasons dr

4957: CURSOR contingencies IS
4958: SELECT 1
4959: FROM ar_deferred_lines dl,
4960: ar_line_conts lc,
4961: ar_deferral_reasons dr
4962: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
4963: AND lc.contingency_id = dr.contingency_id
4964: AND lc.completed_flag = 'N'
4965: AND dr.revrec_event_code = 'RECEIPT_APPLICATION'