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 555: ar_deferral_reasons dr,

551: max(interface_line_attribute6),
552: l_request_id
553: FROM ar_deferred_lines dl,
554: ar_line_conts lc,
555: ar_deferral_reasons dr,
556: ra_customer_trx_lines ctl
557: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
558: AND lc.contingency_id = dr.contingency_id
559: AND ctl.customer_trx_line_id = lc.customer_trx_line_id

Line 603: ar_deferral_reasons dr,

599: max(interface_line_attribute6),
600: l_request_id
601: FROM ar_deferred_lines dl,
602: ar_line_conts lc,
603: ar_deferral_reasons dr,
604: ra_customer_trx_lines ctl
605: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
606: AND lc.contingency_id = dr.contingency_id
607: AND ctl.customer_trx_line_id = lc.customer_trx_line_id

Line 793: ar_deferral_reasons dr

789: ra_customer_trx_lines parent_line,
790: ar_deferred_lines child,
791: ra_customer_trx_lines child_line,
792: ar_line_conts lc,
793: ar_deferral_reasons dr
794: WHERE parent.customer_trx_id = parent_line.customer_trx_id
795: AND parent.customer_trx_line_id = parent_line.customer_trx_line_id
796: AND parent_line.interface_line_context = g_om_context
797: AND to_char(child.parent_line_id) = parent.so_line_id

Line 879: ar_deferral_reasons dr

875: l_request_id,
876: max(lc.expiration_date)
877: FROM ar_deferred_lines dl,
878: ar_line_conts lc,
879: ar_deferral_reasons dr
880: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
881: AND lc.contingency_id = dr.contingency_id
882: AND lc.completed_flag = 'N'
883: AND line_collectible_flag = 'N' -- not collectilbe

Line 927: ar_deferral_reasons dr

923: 'UPDATE',
924: l_request_id
925: FROM ar_deferred_lines dl,
926: ar_line_conts lc,
927: ar_deferral_reasons dr
928: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
929: AND lc.contingency_id = dr.contingency_id
930: AND line_collectible_flag = 'N' -- not collectilbe
931: AND manual_override_flag = 'N' -- not manually overridden in

Line 1122: ar_deferral_reasons dr

1118: CURSOR alc (p_req_id NUMBER, p_line_id NUMBER) IS
1119: select lc.customer_trx_line_id, lc.contingency_id,
1120: dr.policy_attached
1121: from ar_line_conts lc,
1122: ar_deferral_reasons dr
1123: where lc.contingency_id = dr.contingency_id
1124: and ((p_req_id IS NULL and p_line_id IS NOT NULL AND
1125: lc.customer_trx_line_id = p_line_id) OR
1126: (p_req_id IS NOT NULL AND lc.request_id = p_req_id));

Line 1164: FROM ar_deferral_reasons dr

1160: AND trunc(expiration_date) - trunc(sysdate) <
1161: NVL(arp_standard.sysparm.standard_refund,0)
1162: AND EXISTS
1163: (SELECT 'its a refund contingency'
1164: FROM ar_deferral_reasons dr
1165: WHERE dr.contingency_id = lrc.contingency_id
1166: AND dr.policy_attached in ('REFUND','REFUND_POLICY'));
1167:
1168: debug('refund contingencies deleted: ' || SQL%ROWCOUNT);

Line 1187: FROM ar_deferral_reasons dr

1183: AND ar_revenue_management_pvt.creditworthy
1184: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 1)
1185: AND EXISTS
1186: (SELECT 'its a CREDIT_CLASSIFICATION'
1187: FROM ar_deferral_reasons dr
1188: WHERE dr.contingency_id = lc.contingency_id
1189: AND dr.policy_attached = 'CREDIT_CLASSIFICATION');
1190:
1191: IF PG_DEBUG IN ('Y','C')

Line 1216: FROM ar_deferral_reasons dr

1212: HAVING NVL(max(due_days),0) <=
1213: NVL(arp_standard.sysparm.payment_threshold,0))
1214: AND EXISTS
1215: (SELECT 'its a PAYMENT_TERM'
1216: FROM ar_deferral_reasons dr
1217: WHERE dr.policy_attached = 'PAYMENT_TERM'
1218: AND dr.contingency_id = lc.contingency_id);
1219:
1220: IF PG_DEBUG IN ('Y','C')

Line 1257: FROM ar_deferral_reasons dr

1253: NVL(arp_standard.sysparm.standard_refund,0)
1254: AND lrc.customer_trx_line_id = p_customer_trx_line_id
1255: AND EXISTS
1256: (SELECT 'a refund contingency'
1257: FROM ar_deferral_reasons dr
1258: WHERE dr.policy_attached in ('REFUND','REFUND_POLICY')
1259: AND dr.contingency_id = lrc.contingency_id);
1260:
1261: debug('refund contingencies deleted: ' || SQL%ROWCOUNT);

Line 1273: FROM ar_deferral_reasons dr

1269: FROM ar_line_conts lc
1270: WHERE lc.customer_trx_line_id = p_customer_trx_line_id
1271: AND EXISTS
1272: (SELECT 'its a credit_classification contingency'
1273: FROM ar_deferral_reasons dr
1274: WHERE dr.contingency_id = lc.contingency_id
1275: AND dr.policy_attached = 'CREDIT_CLASSIFICATION')
1276: AND EXISTS
1277: (SELECT 'customer is not credit worthy'

Line 1300: FROM ar_deferral_reasons dr

1296: FROM ar_line_conts lc
1297: WHERE lc.customer_trx_line_id = p_customer_trx_line_id
1298: AND EXISTS
1299: (SELECT 'it is a term contingency'
1300: FROM ar_deferral_reasons dr
1301: WHERE dr.policy_attached = 'PAYMENT_TERM'
1302: AND dr.contingency_id = lc.contingency_id)
1303: AND EXISTS
1304: (SELECT 'term exceeds threshold'

Line 1391: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;

1387:
1388: /* This function returns the customer_trx_line_id of the parent line
1389: after fetching the attribute values from OM */
1390: FUNCTION get_line_id(p_so_line_id IN NUMBER) RETURN NUMBER IS
1391: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;
1392: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1393: l_msg_count NUMBER;
1394: l_msg_data VARCHAR2(2000);
1395: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

Line 1772: ar_deferral_reasons dr,

1768: sysdate,
1769: l_user_id,
1770: ct.org_id
1771: FROM fun_rule_bulk_result_gt rbr,
1772: ar_deferral_reasons dr,
1773: ra_customer_trx_lines ctl,
1774: ra_customer_trx ct,
1775: ra_cust_trx_types ctt,
1776: pa_implementations pa

Line 1849: ar_deferral_reasons dr,

1845: sysdate,
1846: l_user_id,
1847: ct.org_id
1848: FROM fun_rule_bulk_result_gt rbr,
1849: ar_deferral_reasons dr,
1850: ra_customer_trx_lines ctl,
1851: ra_customer_trx ct,
1852: ra_cust_trx_types ctt,
1853: pa_implementations pa

Line 1969: ar_deferral_reasons dr,

1965: FROM ar_trx_lines_gt tlg,
1966: ar_trx_header_gt thg,
1967: ra_cust_trx_types ctt,
1968: ar_trx_contingencies_gt tcg,
1969: ar_deferral_reasons dr,
1970: pa_implementations pa
1971: WHERE tlg.request_id = p_request_id
1972: AND tlg.trx_header_id = thg.trx_header_id
1973: AND thg.batch_source_id NOT IN (20, 21)

Line 2080: ar_deferral_reasons dr,

2076: FROM ra_customer_trx_lines ctl,
2077: ra_customer_trx ct,
2078: ra_cust_trx_types ctt,
2079: ar_interface_conts ic,
2080: ar_deferral_reasons dr,
2081: pa_implementations pa
2082: WHERE ctl.request_id = p_request_id
2083: AND ctl.customer_trx_id = ct.customer_trx_id
2084: AND ct.batch_source_id NOT IN (20, 21)

Line 2475: ar_deferral_reasons dr

2471: and dl.customer_trx_id in
2472: (SELECT ctl.customer_trx_id /* its a pre-billing contingency */
2473: FROM ra_customer_trx_lines_all ctl,
2474: ar_line_conts_all lrc,
2475: ar_deferral_reasons dr
2476: WHERE ctl.customer_trx_line_id = dl.customer_trx_line_id
2477: and ctl.customer_trx_line_id=lrc.customer_trx_line_id
2478: and trunc(nvl(lrc.expiration_date,sysdate)) - trunc(sysdate) <= 0
2479: and dr.contingency_id = lrc.contingency_id

Line 2502: ar_deferral_reasons dr

2498: and dl.customer_trx_id in
2499: (SELECT ctl.customer_trx_id /* its a pre-billing contingency */
2500: FROM ra_customer_trx_lines_all ctl,
2501: ar_line_conts_all lrc,
2502: ar_deferral_reasons dr
2503: WHERE ctl.customer_trx_line_id = dl.customer_trx_line_id
2504: and ctl.customer_trx_line_id=lrc.customer_trx_line_id
2505: and trunc(nvl(lrc.expiration_date,sysdate)) - trunc(sysdate) <= 0
2506: and dr.contingency_id = lrc.contingency_id

Line 2567: FROM ar_deferral_reasons l

2563: AND cgt.trx_line_id = lgt.trx_line_id
2564: AND NOT EXISTS
2565: (
2566: SELECT 'valid lookup code'
2567: FROM ar_deferral_reasons l
2568: WHERE l.contingency_id = cgt.contingency_id
2569: );
2570:
2571: l_error_count := SQL%ROWCOUNT;

Line 2603: ar_deferral_reasons dr

2599: cgt.contingency_id
2600: FROM ar_trx_lines_gt lgt,
2601: ar_trx_header_gt hgt,
2602: ar_trx_contingencies_gt cgt,
2603: ar_deferral_reasons dr
2604: WHERE lgt.trx_header_id = hgt.trx_header_id
2605: AND cgt.trx_line_id = lgt.trx_line_id
2606: AND cgt.contingency_id = dr.contingency_id
2607: AND cgt.expiration_date IS NOT NULL

Line 2671: FROM ar_deferral_reasons l

2667: AND c.interface_line_id = l.interface_line_id
2668: AND NOT EXISTS
2669: (
2670: SELECT 'valid lookup code'
2671: FROM ar_deferral_reasons l
2672: WHERE l.contingency_id = c.contingency_id
2673: );
2674:
2675: l_error_count := SQL%ROWCOUNT;

Line 2706: ar_deferral_reasons dr

2702: c.contingency_id,
2703: l.org_id
2704: FROM ra_interface_lines l,
2705: ar_interface_conts c,
2706: ar_deferral_reasons dr
2707: WHERE l.request_id = p_request_id
2708: AND c.interface_line_id = l.interface_line_id
2709: AND dr.contingency_id = c.contingency_id
2710: AND c.expiration_date IS NOT NULL

Line 3175: ar_deferral_reasons dr

3171: -- was waiting for this event.
3172: CURSOR conts IS
3173: SELECT dr.contingency_id, revrec_event_code, expiration_event_code
3174: FROM ar_line_conts lc,
3175: ar_deferral_reasons dr
3176: WHERE lc.contingency_id = dr.contingency_id
3177: AND lc.customer_trx_line_id = p_cust_trx_line_id
3178: AND (dr.revrec_event_code = p_event_code OR
3179: dr.expiration_event_code = p_event_code);

Line 4242: ar_deferral_reasons dr

4238: SELECT lc.customer_trx_line_id,
4239: lc.contingency_id,
4240: lc.expiration_date
4241: FROM ar_line_conts lc,
4242: ar_deferral_reasons dr
4243: WHERE lc.customer_trx_line_id = p_customer_trx_line_id
4244: AND lc.contingency_id = dr.contingency_id
4245: AND lc.completed_flag = 'N'
4246: AND lc.expiration_date IS NOT NULL

Line 4300: ar_deferral_reasons dr

4296:
4297: CURSOR cash_based IS
4298: SELECT 1
4299: FROM ar_line_conts lc,
4300: ar_deferral_reasons dr
4301: WHERE lc.contingency_id = dr.contingency_id
4302: AND lc.customer_trx_line_id = p_cust_trx_line_id
4303: AND lc.completed_flag = 'N'
4304: AND dr.revrec_event_code = 'RECEIPT_APPLICATION';

Line 4310: ar_deferral_reasons dr

4306:
4307: CURSOR contingency_based IS
4308: SELECT 1
4309: FROM ar_line_conts lc,
4310: ar_deferral_reasons dr
4311: WHERE lc.contingency_id = dr.contingency_id
4312: AND lc.customer_trx_line_id = p_cust_trx_line_id
4313: AND lc.completed_flag = 'N'
4314: AND dr.revrec_event_code <> 'RECEIPT_APPLICATION';

Line 4749: ar_deferral_reasons dr

4745: CURSOR c1 IS
4746: SELECT 'its a pre-billing contingency'
4747: FROM ra_customer_trx_lines_all ctl,
4748: ar_line_conts_all lrc,
4749: ar_deferral_reasons dr
4750: WHERE ctl.customer_trx_id = p_customer_trx_id
4751: and ctl.customer_trx_line_id=lrc.customer_trx_line_id
4752: and trunc(nvl(lrc.expiration_date,sysdate)) - trunc(sysdate) <= 0
4753: and dr.contingency_id = lrc.contingency_id

Line 5015: ar_deferral_reasons dl

5011: CURSOR contingencies IS
5012: SELECT 1
5013: FROM ar_deferred_lines dl,
5014: ar_line_conts lc,
5015: ar_deferral_reasons dl
5016: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
5017: AND lc.contingency_id = dl.contingency_id
5018: AND lc.completed_flag = 'N'
5019: AND dl.customer_trx_id = p_customer_trx_id

Line 5128: ar_deferral_reasons dr

5124: CURSOR contingencies IS
5125: SELECT 1
5126: FROM ar_deferred_lines dl,
5127: ar_line_conts lc,
5128: ar_deferral_reasons dr
5129: WHERE dl.customer_trx_line_id = lc.customer_trx_line_id
5130: AND lc.contingency_id = dr.contingency_id
5131: AND lc.completed_flag = 'N'
5132: AND dr.revrec_event_code = 'RECEIPT_APPLICATION'