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.OKL_BILLING_UTIL_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 28: --1. need to tune the sql for the cursor, gives full scan for ra_customer_trx_lines_all

24: -- Version : 1.0
25: -- End of comments
26: -------------------------------------------------------------------------------
27: --Comments:
28: --1. need to tune the sql for the cursor, gives full scan for ra_customer_trx_lines_all
29:
30: PROCEDURE Last_Invoice_Date(
31: p_api_version IN NUMBER
32: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

Line 47: FROM ra_customer_trx_lines_all ractrl

43: SELECT max(ractrx.trx_date)
44: FROM ra_customer_trx_all ractrx
45: WHERE EXISTS (
46: SELECT 'x'
47: FROM ra_customer_trx_lines_all ractrl
48: WHERE ractrl.customer_trx_id = ractrx.customer_trx_id
49: AND ractrl.interface_line_attribute6 = (SELECT contract_number
50: FROM okc_k_headers_b
51: WHERE ID = p_contract_id)

Line 114: FROM ra_customer_trx_lines_all ractrl,

110: IS
111: CURSOR c_strm_invoice_amt(p_stream_purpose IN VARCHAR2) IS
112: SELECT chr.id,
113: SUM(ractrl.amount_due_original) amount
114: FROM ra_customer_trx_lines_all ractrl,
115: okc_k_headers_b chr
116: WHERE chr.contract_number = ractrl.interface_line_attribute6
117: AND EXISTS(SELECT sty.code
118: FROM OKL_STRM_TYPE_B sty

Line 157: FROM RA_CUSTOMER_TRX_LINES_ALL

153: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
154:
155: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS
156: SELECT SUM(NVL(EXTENDED_AMOUNT, 0)) LINE_TAX_AMOUNT
157: FROM RA_CUSTOMER_TRX_LINES_ALL
158: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id;
159:
160: l_line_amount NUMBER;
161: l_line_tax_amount NUMBER;

Line 188: ra_customer_trx_lines_all lines

184: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
185: FROM ar_receivable_applications_all app,
186: ar_payment_schedules_all sch,
187: ar_distributions_all ad,
188: ra_customer_trx_lines_all lines
189: WHERE app.status = 'APP'
190: AND app.applied_payment_schedule_id = sch.payment_schedule_id
191: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo
192: AND sch.customer_trx_id = p_header_id

Line 206: FROM RA_CUSTOMER_TRX_LINES_ALL

202:
203: --Bug# 9116332
204: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
205: SELECT COUNT(1) LINE_COUNT
206: FROM RA_CUSTOMER_TRX_LINES_ALL
207: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
208: AND LINE_TYPE = 'LINE';
209:
210: l_line_count NUMBER;

Line 254: ra_customer_trx_lines_all lines

250: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
251: FROM ar_receivable_applications_all app,
252: ar_payment_schedules_all sch,
253: ar_distributions_all ad,
254: ra_customer_trx_lines_all lines
255: WHERE app.status = 'APP'
256: AND app.applied_payment_schedule_id = sch.payment_schedule_id
257: AND sch.class = 'INV'
258: AND sch.customer_trx_id = p_header_id

Line 272: FROM RA_CUSTOMER_TRX_LINES_ALL

268:
269: --Bug# 9116332
270: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
271: SELECT COUNT(1) LINE_COUNT
272: FROM RA_CUSTOMER_TRX_LINES_ALL
273: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
274: AND LINE_TYPE = 'LINE';
275:
276: l_line_count NUMBER;

Line 339: ra_customer_trx_lines_all lines

335: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
336: FROM ar_receivable_applications_all app,
337: ar_payment_schedules_all sch,
338: ar_distributions_all ad,
339: ra_customer_trx_lines_all lines
340: WHERE app.status = 'APP'
341: AND app.payment_schedule_id = sch.payment_schedule_id
342: AND sch.class IN ('CM')
343: AND sch.customer_trx_id = p_header_id

Line 357: FROM RA_CUSTOMER_TRX_LINES_ALL

353:
354:
355: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
356: SELECT COUNT(1) LINE_COUNT
357: FROM RA_CUSTOMER_TRX_LINES_ALL
358: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
359: AND LINE_TYPE = 'LINE';
360:
361: l_line_count NUMBER;

Line 514: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN

510: FUNCTION LINE_ID_APPLIED(p_cash_receipt_id IN NUMBER,
511: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
512: CURSOR invoice_lines(p_cash_receipt_id IN NUMBER,p_customer_trx_id IN NUMBER) IS
513: SELECT RACTRXLN.customer_trx_line_id
514: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN
515: WHERE RACTRXLN.LINE_TYPE = 'LINE'
516: AND RACTRXLN.interface_line_context = 'OKL_CONTRACTS'
517: AND RACTRXLN.CUSTOMER_TRX_ID = p_customer_trx_id;
518: l_inv_ln_id NUMBER := NULL;

Line 537: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN

533: FUNCTION LINE_NUMBER_APPLIED(p_cash_receipt_id IN NUMBER,
534: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
535: CURSOR invoice_lines(p_cash_receipt_id IN NUMBER,p_customer_trx_id IN NUMBER) IS
536: SELECT RACTRXLN.line_number
537: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN
538: WHERE RACTRXLN.LINE_TYPE = 'LINE'
539: AND RACTRXLN.interface_line_context = 'OKL_CONTRACTS'
540: AND RACTRXLN.CUSTOMER_TRX_ID = p_customer_trx_id;
541: l_inv_ln_num NUMBER := NULL;

Line 569: FROM RA_CUSTOMER_TRX_LINES_ALL

565:
566: FUNCTION get_tld_amount_orig( p_tld_id IN NUMBER ) RETURN NUMBER IS
567: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
568: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
569: FROM RA_CUSTOMER_TRX_LINES_ALL
570: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
571: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
572:
573: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 575: FROM RA_CUSTOMER_TRX_LINES_ALL

571: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
572:
573: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
574: SELECT COUNT(1) LINE_COUNT
575: FROM RA_CUSTOMER_TRX_LINES_ALL
576: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
577: AND LINE_TYPE = 'LINE';
578:
579: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 579: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

575: FROM RA_CUSTOMER_TRX_LINES_ALL
576: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
577: AND LINE_TYPE = 'LINE';
578:
579: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
580: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
581: l_line_count NUMBER;
582: l_amount_orig NUMBER := 0;
583: BEGIN

Line 580: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

576: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
577: AND LINE_TYPE = 'LINE';
578:
579: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
580: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
581: l_line_count NUMBER;
582: l_amount_orig NUMBER := 0;
583: BEGIN
584: NULL;

Line 612: FROM RA_CUSTOMER_TRX_LINES_ALL

608:
609: FUNCTION get_tld_amount_applied( p_tld_id IN NUMBER ) RETURN NUMBER IS
610: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
611: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
612: FROM RA_CUSTOMER_TRX_LINES_ALL
613: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
614: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
615:
616: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 618: FROM RA_CUSTOMER_TRX_LINES_ALL

614: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
615:
616: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
617: SELECT COUNT(1) LINE_COUNT
618: FROM RA_CUSTOMER_TRX_LINES_ALL
619: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
620: AND LINE_TYPE = 'LINE';
621:
622: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 622: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

618: FROM RA_CUSTOMER_TRX_LINES_ALL
619: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
620: AND LINE_TYPE = 'LINE';
621:
622: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
623: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
624: l_line_count NUMBER;
625: l_amount_applied NUMBER := 0;
626: BEGIN

Line 623: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

619: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
620: AND LINE_TYPE = 'LINE';
621:
622: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
623: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
624: l_line_count NUMBER;
625: l_amount_applied NUMBER := 0;
626: BEGIN
627: NULL;

Line 655: FROM RA_CUSTOMER_TRX_LINES_ALL

651:
652: FUNCTION get_tld_amount_credited( p_tld_id IN NUMBER ) RETURN NUMBER IS
653: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
654: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
655: FROM RA_CUSTOMER_TRX_LINES_ALL
656: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
657: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
658:
659: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 661: FROM RA_CUSTOMER_TRX_LINES_ALL

657: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
658:
659: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
660: SELECT COUNT(1) LINE_COUNT
661: FROM RA_CUSTOMER_TRX_LINES_ALL
662: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
663: AND LINE_TYPE = 'LINE';
664:
665: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 665: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

661: FROM RA_CUSTOMER_TRX_LINES_ALL
662: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
663: AND LINE_TYPE = 'LINE';
664:
665: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
666: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
667: l_line_count NUMBER;
668: l_amount_credited NUMBER := 0;
669: BEGIN

Line 666: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

662: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
663: AND LINE_TYPE = 'LINE';
664:
665: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
666: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
667: l_line_count NUMBER;
668: l_amount_credited NUMBER := 0;
669: BEGIN
670: NULL;

Line 698: FROM RA_CUSTOMER_TRX_LINES_ALL

694:
695: FUNCTION get_tld_amount_remaining( p_tld_id IN NUMBER ) RETURN NUMBER IS
696: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
697: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
698: FROM RA_CUSTOMER_TRX_LINES_ALL
699: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
700: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
701:
702: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 704: FROM RA_CUSTOMER_TRX_LINES_ALL

700: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
701:
702: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
703: SELECT COUNT(1) LINE_COUNT
704: FROM RA_CUSTOMER_TRX_LINES_ALL
705: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
706: AND LINE_TYPE = 'LINE';
707:
708: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 708: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

704: FROM RA_CUSTOMER_TRX_LINES_ALL
705: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
706: AND LINE_TYPE = 'LINE';
707:
708: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
709: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
710: l_line_count NUMBER;
711: l_amount_remaining NUMBER := 0;
712: BEGIN

Line 709: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

705: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
706: AND LINE_TYPE = 'LINE';
707:
708: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
709: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
710: l_line_count NUMBER;
711: l_amount_remaining NUMBER := 0;
712: BEGIN
713: NULL;

Line 755: FROM RA_CUSTOMER_TRX_LINES_ALL

751: IS
752:
753: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
754: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
755: FROM RA_CUSTOMER_TRX_LINES_ALL
756: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
757: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
758:
759: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 761: FROM RA_CUSTOMER_TRX_LINES_ALL

757: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
758:
759: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
760: SELECT COUNT(1) LINE_COUNT
761: FROM RA_CUSTOMER_TRX_LINES_ALL
762: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
763: AND LINE_TYPE = 'LINE';
764:
765: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS

Line 767: FROM RA_CUSTOMER_TRX_LINES_ALL

763: AND LINE_TYPE = 'LINE';
764:
765: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS
766: SELECT SUM(NVL(EXTENDED_AMOUNT, 0)) LINE_TAX_AMOUNT
767: FROM RA_CUSTOMER_TRX_LINES_ALL
768: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
769: AND LINE_TYPE='TAX';
770:
771: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 771: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

767: FROM RA_CUSTOMER_TRX_LINES_ALL
768: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
769: AND LINE_TYPE='TAX';
770:
771: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
772: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
773: l_line_count NUMBER;
774: l_amount_remaining NUMBER := 0;
775:

Line 772: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

768: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
769: AND LINE_TYPE='TAX';
770:
771: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
772: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
773: l_line_count NUMBER;
774: l_amount_remaining NUMBER := 0;
775:
776: l_api_name VARCHAR2(60) := 'Get TLD Balance';

Line 851: FROM RA_CUSTOMER_TRX_LINES_ALL LNS,

847:
848:
849: CURSOR cust_trx_csr(p_cust_trx_number VARCHAR2, p_contract_number VARCHAR2) IS
850: SELECT LNS.CUSTOMER_TRX_ID
851: FROM RA_CUSTOMER_TRX_LINES_ALL LNS,
852: RA_CUSTOMER_TRX_ALL HDR
853: WHERE LNS.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number
854: AND HDR.TRX_NUMBER = p_cust_trx_number
855: AND HDR.CUSTOMER_TRX_ID = LNS.CUSTOMER_TRX_ID;

Line 858: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

854: AND HDR.TRX_NUMBER = p_cust_trx_number
855: AND HDR.CUSTOMER_TRX_ID = LNS.CUSTOMER_TRX_ID;
856:
857:
858: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
859: l_amount_remaining NUMBER := 0;
860:
861: l_api_name VARCHAR2(60) := 'get_contract_invoice_balance';
862:

Line 890: FROM RA_CUSTOMER_TRX_LINES_ALL

886:
887: FUNCTION INVOICE_LINE_TAX_AMOUNT(p_customer_trx_line_id NUMBER) RETURN NUMBER IS
888: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS
889: SELECT SUM(NVL(EXTENDED_AMOUNT, 0)) LINE_TAX_AMOUNT
890: FROM RA_CUSTOMER_TRX_LINES_ALL
891: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
892: AND LINE_TYPE='TAX';
893:
894: l_tax_amount NUMBER;

Line 1242: FROM RA_CUSTOMER_TRX_LINES_ALL

1238:
1239: FUNCTION get_tld_amt_remaining_WOTAX( p_tld_id IN NUMBER ) RETURN NUMBER IS
1240: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
1241: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
1242: FROM RA_CUSTOMER_TRX_LINES_ALL
1243: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
1244: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
1245:
1246: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 1248: FROM RA_CUSTOMER_TRX_LINES_ALL

1244: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
1245:
1246: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
1247: SELECT COUNT(1) LINE_COUNT
1248: FROM RA_CUSTOMER_TRX_LINES_ALL
1249: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
1250: AND LINE_TYPE = 'LINE';
1251:
1252: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 1252: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

1248: FROM RA_CUSTOMER_TRX_LINES_ALL
1249: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
1250: AND LINE_TYPE = 'LINE';
1251:
1252: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
1253: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1254: l_line_count NUMBER;
1255: l_amount_remaining NUMBER := 0;
1256: BEGIN

Line 1253: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

1249: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
1250: AND LINE_TYPE = 'LINE';
1251:
1252: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
1253: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1254: l_line_count NUMBER;
1255: l_amount_remaining NUMBER := 0;
1256: BEGIN
1257: NULL;

Line 1337: FROM RA_CUSTOMER_TRX_LINES_ALL

1333: p_customer_trx_id IN NUMBER,
1334: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1335: CURSOR invoice_line_amount(p_header_id NUMBER, p_line_id NUMBER) IS
1336: SELECT NVL(EXTENDED_AMOUNT, 0) LINE_AMOUNT
1337: FROM RA_CUSTOMER_TRX_LINES_ALL
1338: WHERE CUSTOMER_TRX_ID = p_header_id
1339: AND CUSTOMER_TRX_LINE_ID = p_line_id;
1340:
1341: l_line_amount NUMBER;

Line 1438: ra_customer_trx_lines_all lines

1434: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1435: FROM ar_adjustments_all adj,
1436: ar_payment_schedules_all sch,
1437: ar_distributions_all dist,
1438: ra_customer_trx_lines_all lines
1439: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1440: AND sch.class = 'INV'
1441: AND sch.customer_trx_id = p_header_id
1442: AND adj.ADJUSTMENT_ID = dist.source_id

Line 1454: FROM RA_CUSTOMER_TRX_LINES_ALL

1450:
1451: --Bug# 9116332
1452: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
1453: SELECT COUNT(1) LINE_COUNT
1454: FROM RA_CUSTOMER_TRX_LINES_ALL
1455: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
1456: AND LINE_TYPE = 'LINE';
1457:
1458: l_line_count NUMBER;

Line 1532: FROM RA_CUSTOMER_TRX_LINES_ALL

1528: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1529:
1530: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS
1531: SELECT SUM(NVL(EXTENDED_AMOUNT, 0)) LINE_TAX_AMOUNT
1532: FROM RA_CUSTOMER_TRX_LINES_ALL
1533: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
1534: AND AMOUNT_INCLUDES_TAX_FLAG = 'Y';
1535:
1536: l_line_amount NUMBER;

Line 1563: ra_customer_trx_lines_all lines

1559: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
1560: FROM ar_receivable_applications_all app,
1561: ar_payment_schedules_all sch,
1562: ar_distributions_all ad,
1563: ra_customer_trx_lines_all lines
1564: WHERE app.status = 'APP'
1565: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1566: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo
1567: AND sch.customer_trx_id = p_header_id

Line 1599: ra_customer_trx_lines_all lines

1595: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1596: FROM ar_receivable_applications_all app,
1597: ar_payment_schedules_all sch,
1598: ar_distributions_all ad,
1599: ra_customer_trx_lines_all lines
1600: WHERE app.status = 'APP'
1601: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1602: AND sch.class = 'INV'
1603: AND sch.customer_trx_id = p_header_id

Line 1636: ra_customer_trx_lines_all lines

1632: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1633: FROM ar_adjustments_all adj,
1634: ar_payment_schedules_all sch,
1635: ar_distributions_all dist,
1636: ra_customer_trx_lines_all lines
1637: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1638: AND sch.class = 'INV'
1639: AND sch.customer_trx_id = p_header_id
1640: AND adj.ADJUSTMENT_ID = dist.source_id

Line 1710: FROM ra_customer_trx_lines_all ractrl

1706: IS
1707:
1708: CURSOR c_strm_invoice_amt IS
1709: SELECT SUM(ractrl.amount_due_original) amount
1710: FROM ra_customer_trx_lines_all ractrl
1711: WHERE ractrl.interface_line_attribute6 IN
1712: (select chr.contract_number
1713: from okc_k_headers_b chr,
1714: okc_governances gv,