[Home] [Help]
103: l_user_id,
104: sysdate,
105: l_user_id,
106: max(ctl.org_id)
107: FROM ra_customer_trx_lines ctl,
108: ra_customer_trx ct,
109: ra_terms_lines tl,
110: ra_cust_trx_types ctt
111: WHERE ctl.request_id = p_request_id
104: sysdate,
105: l_user_id,
106: max(ctl.org_id)
107: FROM ra_customer_trx_lines ctl,
108: ra_customer_trx ct,
109: ra_terms_lines tl,
110: ra_cust_trx_types ctt
111: WHERE ctl.request_id = p_request_id
112: AND ctl.customer_trx_id = ct.customer_trx_id
167: l_user_id,
168: sysdate,
169: l_user_id,
170: max(ctl.org_id)
171: FROM ra_customer_trx_lines ctl,
172: ra_customer_trx ct,
173: ra_terms_lines tl,
174: ra_cust_trx_types ctt
175: WHERE ctl.request_id = p_request_id
168: sysdate,
169: l_user_id,
170: max(ctl.org_id)
171: FROM ra_customer_trx_lines ctl,
172: ra_customer_trx ct,
173: ra_terms_lines tl,
174: ra_cust_trx_types ctt
175: WHERE ctl.request_id = p_request_id
176: AND ctl.customer_trx_id = ct.customer_trx_id
228: l_user_id,
229: sysdate,
230: l_user_id,
231: ctl.org_id
232: FROM ra_customer_trx_lines ctl,
233: ra_customer_trx ct,
234: ra_terms_lines tl,
235: ra_cust_trx_types ctt
236: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
229: sysdate,
230: l_user_id,
231: ctl.org_id
232: FROM ra_customer_trx_lines ctl,
233: ra_customer_trx ct,
234: ra_terms_lines tl,
235: ra_cust_trx_types ctt
236: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
237: AND ctl.customer_trx_id = ct.customer_trx_id
321: l_user_id,
322: sysdate,
323: l_user_id,
324: ctl.org_id
325: FROM ra_customer_trx_lines ctl,
326: ra_customer_trx ct,
327: ra_cust_trx_types ctt
328: WHERE ctl.request_id = p_request_id
329: AND ctl.customer_trx_id = ct.customer_trx_id
322: sysdate,
323: l_user_id,
324: ctl.org_id
325: FROM ra_customer_trx_lines ctl,
326: ra_customer_trx ct,
327: ra_cust_trx_types ctt
328: WHERE ctl.request_id = p_request_id
329: AND ctl.customer_trx_id = ct.customer_trx_id
330: AND ct.batch_source_id NOT IN (20, 21)
383: l_user_id,
384: sysdate,
385: l_user_id,
386: ctl.org_id
387: FROM ra_customer_trx_lines ctl,
388: ra_customer_trx ct,
389: ra_cust_trx_types ctt
390: WHERE ctl.request_id = p_request_id
391: AND ctl.customer_trx_id = ct.customer_trx_id
384: sysdate,
385: l_user_id,
386: ctl.org_id
387: FROM ra_customer_trx_lines ctl,
388: ra_customer_trx ct,
389: ra_cust_trx_types ctt
390: WHERE ctl.request_id = p_request_id
391: AND ctl.customer_trx_id = ct.customer_trx_id
392: AND ct.batch_source_id NOT IN (20, 21)
442: l_user_id,
443: sysdate,
444: l_user_id,
445: ctl.org_id
446: FROM ra_customer_trx_lines ctl,
447: ra_customer_trx ct,
448: ra_cust_trx_types ctt
449: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
450: AND ctl.customer_trx_id = ct.customer_trx_id
443: sysdate,
444: l_user_id,
445: ctl.org_id
446: FROM ra_customer_trx_lines ctl,
447: ra_customer_trx ct,
448: ra_cust_trx_types ctt
449: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
450: AND ctl.customer_trx_id = ct.customer_trx_id
451: AND ct.batch_source_id NOT IN (20, 21)
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
524: AND dr.revrec_event_code = 'CUSTOMER_ACCEPTANCE'
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
572: AND dr.revrec_event_code = 'CUSTOMER_ACCEPTANCE'
642: 'PARENT',
643: interface_line_attribute6,
644: l_request_id
645: FROM ar_deferred_lines dl,
646: ra_customer_trx_lines ctl
647: WHERE dl.customer_trx_line_id = ctl.customer_trx_line_id
648: AND dl.customer_trx_id = nvl(p_customer_trx_id, dl.customer_trx_id)
649: AND dl.customer_trx_line_id = nvl(p_customer_trx_line_id,
650: dl.customer_trx_line_id)
692: so that acceptance picks up the parent lines and any child lines
693: associated with that parent */
694:
695: /* 5043785 - The sql below contains an ORDERED hint because it must
696: join to RA_CUSTOMER_TRX_LINES before it attempts to join to the
697: child lines via so_line_id. In cases where the line is not from OM,
698: this join will fail with an invalid number (if it is attempted).
699:
700: So the ORDERED hint along with the table order prevents the failure
731: l_request_id,
732: child_line.interface_line_attribute6,
733: max(lc.expiration_date)
734: FROM ar_reviewed_lines_gt parent,
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
733: max(lc.expiration_date)
734: FROM ar_reviewed_lines_gt parent,
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
911: SELECT rl.customer_trx_line_id,
912: rl.customer_trx_id,
913: rl.so_line_id
914: FROM ar_reviewed_lines_gt rl,
915: ra_customer_trx_lines tl
916: WHERE rl.request_id = p_req_id
917: AND tl.customer_trx_line_id = rl.customer_trx_line_id
918: AND tl.customer_trx_id = rl.customer_trx_id
919: AND tl.interface_line_context = g_om_context;
1044: the logic for removing unnecessary contingencies. Note that
1045: REFUND is used on the seeded contingency and REFUND_POLICY
1046: is assigned to new ones. */
1047: PROCEDURE delete_unwanted_contingencies (p_request_id NUMBER
1048: ,p_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE) IS
1049:
1050: /* debug cursor */
1051: CURSOR alc (p_req_id NUMBER, p_line_id NUMBER) IS
1052: select lc.customer_trx_line_id, lc.contingency_id,
1087: DELETE
1088: FROM ar_line_conts lrc
1089: WHERE customer_trx_line_id IN
1090: (SELECT customer_trx_line_id
1091: FROM ra_customer_trx_lines ctl
1092: WHERE ctl.request_id = p_request_id)
1093: AND trunc(expiration_date) - trunc(sysdate) <
1094: NVL(arp_standard.sysparm.standard_refund,0)
1095: AND EXISTS
1108: DELETE
1109: FROM ar_line_conts lc
1110: WHERE lc.customer_trx_line_id IN
1111: (SELECT customer_trx_line_id
1112: FROM ra_customer_trx_lines ctl,
1113: ra_customer_trx ct
1114: WHERE ctl.customer_trx_id = ct.customer_trx_id
1115: AND ctl.request_id = p_request_id
1116: AND ar_revenue_management_pvt.creditworthy
1109: FROM ar_line_conts lc
1110: WHERE lc.customer_trx_line_id IN
1111: (SELECT customer_trx_line_id
1112: FROM ra_customer_trx_lines ctl,
1113: ra_customer_trx ct
1114: WHERE ctl.customer_trx_id = ct.customer_trx_id
1115: AND ctl.request_id = p_request_id
1116: AND ar_revenue_management_pvt.creditworthy
1117: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 1)
1134: DELETE
1135: FROM ar_line_conts lc
1136: WHERE lc.customer_trx_line_id IN
1137: (SELECT customer_trx_line_id
1138: FROM ra_customer_trx_lines ctl,
1139: ra_customer_trx ct,
1140: ra_terms_lines tl
1141: WHERE ctl.customer_trx_id = ct.customer_trx_id
1142: AND ct.term_id = tl.term_id
1135: FROM ar_line_conts lc
1136: WHERE lc.customer_trx_line_id IN
1137: (SELECT customer_trx_line_id
1138: FROM ra_customer_trx_lines ctl,
1139: ra_customer_trx ct,
1140: ra_terms_lines tl
1141: WHERE ctl.customer_trx_id = ct.customer_trx_id
1142: AND ct.term_id = tl.term_id
1143: AND ctl.request_id = p_request_id
1165: and batch processing */
1166: DELETE from ar_line_conts
1167: WHERE customer_trx_line_id IN
1168: (SELECT customer_trx_line_id
1169: FROM ra_customer_trx_lines ctl,
1170: ra_rules r
1171: WHERE ctl.request_id = p_request_id
1172: AND ctl.accounting_rule_id IS NOT NULL
1173: AND ctl.accounting_rule_id = r.rule_id
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'
1211: FROM ra_customer_trx_lines ctl,
1212: ra_customer_trx ct
1213: WHERE ctl.customer_trx_id = ct.customer_trx_id
1214: AND ctl.customer_trx_line_id = p_customer_trx_line_id
1215: AND ar_revenue_management_pvt.creditworthy
1208: AND dr.policy_attached = 'CREDIT_CLASSIFICATION')
1209: AND EXISTS
1210: (SELECT 'customer is not credit worthy'
1211: FROM ra_customer_trx_lines ctl,
1212: ra_customer_trx ct
1213: WHERE ctl.customer_trx_id = ct.customer_trx_id
1214: AND ctl.customer_trx_line_id = p_customer_trx_line_id
1215: AND ar_revenue_management_pvt.creditworthy
1216: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 1);
1234: WHERE dr.policy_attached = 'PAYMENT_TERM'
1235: AND dr.contingency_id = lc.contingency_id)
1236: AND EXISTS
1237: (SELECT 'term exceeds threshold'
1238: FROM ra_customer_trx_lines ctl,
1239: ra_customer_trx ct,
1240: ra_terms_lines tl
1241: WHERE ctl.customer_trx_id = ct.customer_trx_id
1242: AND ct.term_id = tl.term_id
1235: AND dr.contingency_id = lc.contingency_id)
1236: AND EXISTS
1237: (SELECT 'term exceeds threshold'
1238: FROM ra_customer_trx_lines ctl,
1239: ra_customer_trx ct,
1240: ra_terms_lines tl
1241: WHERE ctl.customer_trx_id = ct.customer_trx_id
1242: AND ct.term_id = tl.term_id
1243: AND ctl.customer_trx_line_id = lc.customer_trx_line_id
1260: and batch processing */
1261: DELETE FROM AR_LINE_CONTS A
1262: WHERE A.customer_trx_line_id = p_customer_trx_line_id
1263: AND EXISTS (SELECT 'DEFERRED RULE'
1264: FROM ra_customer_trx_lines ctl,
1265: ra_rules r
1266: WHERE ctl.customer_trx_line_id = A.customer_trx_line_id
1267: AND ctl.accounting_rule_id = r.rule_id
1268: AND r.deferred_revenue_flag = 'Y');
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;
1329: BEGIN
1330: /* Call OM to get the DFF attributes for the parent line */
1331: OE_AR_Acceptance_GRP.Get_interface_attributes
1332: (p_line_id => p_so_line_id,
1348: interface_line_attribute11 = '0'. */
1349: BEGIN
1350: SELECT customer_trx_line_id
1351: INTO l_customer_trx_line_id
1352: FROM RA_CUSTOMER_TRX_LINES
1353: WHERE interface_line_context = l_line_flex_rec.interface_line_context
1354: AND interface_line_attribute1 = l_line_flex_rec.interface_line_attribute1
1355: AND interface_line_attribute2 = l_line_flex_rec.interface_line_attribute2
1356: AND interface_line_attribute3 = l_line_flex_rec.interface_line_attribute3
1360: AND interface_line_attribute11 = '0';
1361:
1362: EXCEPTION
1363: WHEN NO_DATA_FOUND THEN
1364: debug('unable to locate matching line in ra_customer_trx_lines');
1365: l_customer_trx_line_id := -98;
1366: END;
1367: ELSE
1368: /* OM responded with an error
1434: l_user_id,
1435: sysdate,
1436: l_user_id,
1437: plc.org_id
1438: FROM ra_customer_trx ct,
1439: ra_customer_trx_lines ctl,
1440: ra_cust_trx_types ctt,
1441: ra_interface_lines il,
1442: ar_line_conts plc
1435: sysdate,
1436: l_user_id,
1437: plc.org_id
1438: FROM ra_customer_trx ct,
1439: ra_customer_trx_lines ctl,
1440: ra_cust_trx_types ctt,
1441: ra_interface_lines il,
1442: ar_line_conts plc
1443: WHERE ct.request_id = p_request_id
1476: /* Bug 4693399 - added customer_trx_line_id for manual invoices */
1477: /* 5236506 - Do not default post or pre billing customer acceptance
1478: contingencies on OM lines */
1479: PROCEDURE default_contingencies (p_request_id NUMBER
1480: ,p_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE) IS
1481:
1482: l_user_id NUMBER;
1483:
1484: BEGIN
1528: ctl.accounting_rule_id,
1529: NVL(ctl.ship_to_customer_id,ct.ship_to_customer_id),
1530: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1531: FROM
1532: ra_customer_trx ct,
1533: ra_customer_trx_lines ctl,
1534: hz_customer_profiles hcp,
1535: ra_cust_trx_types ctt
1536: WHERE (ctl.customer_trx_line_id = p_customer_trx_line_id)
1529: NVL(ctl.ship_to_customer_id,ct.ship_to_customer_id),
1530: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1531: FROM
1532: ra_customer_trx ct,
1533: ra_customer_trx_lines ctl,
1534: hz_customer_profiles hcp,
1535: ra_cust_trx_types ctt
1536: WHERE (ctl.customer_trx_line_id = p_customer_trx_line_id)
1537: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1577: ctl.accounting_rule_id,
1578: NVL(ctl.ship_to_customer_id,ct.ship_to_customer_id),
1579: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1580: FROM
1581: ra_customer_trx ct,
1582: ra_customer_trx_lines ctl,
1583: hz_customer_profiles hcp,
1584: ra_cust_trx_types ctt
1585: WHERE ct.request_id = p_request_id
1578: NVL(ctl.ship_to_customer_id,ct.ship_to_customer_id),
1579: NVL(ctl.ship_to_site_use_id,ct.ship_to_site_use_id)
1580: FROM
1581: ra_customer_trx ct,
1582: ra_customer_trx_lines ctl,
1583: hz_customer_profiles hcp,
1584: ra_cust_trx_types ctt
1585: WHERE ct.request_id = p_request_id
1586: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1651: last_update_login,
1652: org_id
1653: )
1654: SELECT /*+ leading(rbr,ctl) use_hash(ctl)
1655: index(ctl,RA_CUSTOMER_TRX_LINES_N4) */
1656: rbr.id,
1657: dr.contingency_id,
1658: dr.contingency_id,
1659: decode(dr.expiration_event_code,
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
1686: AND rbr.id = ctl.customer_trx_line_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
1686: AND rbr.id = ctl.customer_trx_line_id
1687: AND ctl.customer_trx_id = ct.customer_trx_id
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
1758: AND rbr.id = ctl.customer_trx_line_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
1758: AND rbr.id = ctl.customer_trx_line_id
1759: AND ctl.customer_trx_id = ct.customer_trx_id
1963: sysdate,
1964: l_user_id,
1965: sysdate,
1966: ct.org_id
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
1964: l_user_id,
1965: sysdate,
1966: ct.org_id
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
1999: END insert_contingencies_from_itf;
2000:
2001: /* Bug 4693399 - added customer_trx_line_id for manual invoices */
2002: PROCEDURE insert_deferred_lines (p_request_id NUMBER
2003: ,p_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE) IS
2004:
2005: l_user_id NUMBER;
2006: l_insert_stmt VARCHAR2(4000);
2007: l_where_clause VARCHAR2(4000);
2245: l_user_id,
2246: sysdate,
2247: ct.org_id,
2248: MAX(il.parent_line_id)
2249: FROM ra_customer_trx ct,
2250: ra_customer_trx_lines ctl,
2251: ar_line_conts lrc,
2252: ar_interface_conts ic,
2253: ra_interface_lines il
2246: sysdate,
2247: ct.org_id,
2248: MAX(il.parent_line_id)
2249: FROM ra_customer_trx ct,
2250: ra_customer_trx_lines ctl,
2251: ar_line_conts lrc,
2252: ar_interface_conts ic,
2253: ra_interface_lines il
2254: WHERE ctl.request_id = p_request_id
2312: l_user_id,
2313: sysdate,
2314: ct.org_id,
2315: MAX(il.parent_line_id)
2316: FROM ra_customer_trx ct,
2317: ra_customer_trx_lines ctl,
2318: ar_line_conts lrc,
2319: ra_interface_lines il
2320: WHERE ((p_request_id IS NULL AND p_customer_trx_line_id IS NOT NULL AND
2313: sysdate,
2314: ct.org_id,
2315: MAX(il.parent_line_id)
2316: FROM ra_customer_trx ct,
2317: ra_customer_trx_lines ctl,
2318: ar_line_conts lrc,
2319: ra_interface_lines il
2320: WHERE ((p_request_id IS NULL AND p_customer_trx_line_id IS NOT NULL AND
2321: ctl.customer_trx_line_id = p_customer_trx_line_id) OR
2766: -- for the invoice.
2767:
2768: CURSOR c IS
2769: SELECT 1
2770: FROM ra_customer_trx rctl
2771: WHERE rctl.customer_trx_id = p_customer_trx_id
2772: AND invoicing_rule_id IS NOT NULL;
2773:
2774: l_dummy_flag NUMBER;
3759: p_running_allocated_balance IN OUT NOCOPY NUMBER)
3760: RETURN NUMBER IS
3761:
3762: l_total_amount ar_deferred_lines.amount_recognized%TYPE;
3763: l_computed_line_amount ra_customer_trx_lines.extended_amount%TYPE;
3764:
3765: BEGIN
3766:
3767: /*------------------------------------------------------------------------
3994:
3995: CURSOR invoice (p_trx_id IN NUMBER) IS
3996: SELECT invoice_currency_code,
3997: exchange_rate
3998: FROM ra_customer_trx
3999: WHERE customer_trx_id = p_trx_id;
4000:
4001: BEGIN
4002:
4003: /*------------------------------------------------------------------------
4004: | If this procedure is being called from receipt reversal then
4005: | the only thing we have is the receivable application id. As a result,
4006: | query the details from ar_receivable_applications_all table. and then
4007: | from the ra_customer_trx_all.
4008: | If this is being called from receipt application then simply copy the
4009: | passed variable into the local variables.
4010: +------------------------------------------------------------------------*/
4011:
6210: ---------
6211: -- Misc
6212: ---------
6213:
6214: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
6215: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
6216: l_invoice_currency_code fnd_currencies.currency_code%TYPE;
6217: l_return_status VARCHAR2(30);
6218: l_msg_count NUMBER;
6211: -- Misc
6212: ---------
6213:
6214: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
6215: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
6216: l_invoice_currency_code fnd_currencies.currency_code%TYPE;
6217: l_return_status VARCHAR2(30);
6218: l_msg_count NUMBER;
6219: l_msg_data VARCHAR2(150);
6834: rct.invoice_currency_code,
6835: rct.exchange_rate,
6836: ara.gl_date
6837: FROM ar_receivable_applications ara,
6838: ra_customer_trx rct
6839: WHERE ara.request_id = p_request_id
6840: AND ara.applied_customer_trx_id = rct.customer_trx_id;
6841:
6842: l_last_fetch BOOLEAN;
7041: FUNCTION line_collectibility (
7042: p_request_id NUMBER,
7043: p_source VARCHAR2 DEFAULT NULL,
7044: x_error_count OUT NOCOPY NUMBER,
7045: p_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE )
7046: RETURN number_table IS
7047:
7048: /*-----------------------------------------------------------------------+
7049: | Cursor Declarations |
7052: -- This cursor retrieves the revenue management verdicts for each line
7053: CURSOR verdicts IS
7054: SELECT ctl.customer_trx_line_id,
7055: decode(lrs.line_collectible_flag, NULL, 1, 'Y', 1, 'N', 0) verdict
7056: FROM ra_customer_trx_lines ctl,
7057: ar_deferred_lines lrs
7058: WHERE ((p_request_id IS NULL AND
7059: p_customer_trx_line_id IS NOT NULL AND
7060: ctl.customer_trx_line_id = p_customer_trx_line_id) OR