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 224: ra_customer_trx_lines_all lines

220: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
221: FROM ar_receivable_applications_all app,
222: ar_payment_schedules_all sch,
223: ar_distributions_all ad,
224: ra_customer_trx_lines_all lines
225: WHERE app.status = 'APP'
226: AND app.applied_payment_schedule_id = sch.payment_schedule_id
227: AND sch.class = 'INV'
228: AND sch.customer_trx_id = p_header_id

Line 361: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN

357: FUNCTION LINE_ID_APPLIED(p_cash_receipt_id IN NUMBER,
358: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
359: CURSOR invoice_lines(p_cash_receipt_id IN NUMBER,p_customer_trx_id IN NUMBER) IS
360: SELECT RACTRXLN.customer_trx_line_id
361: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN
362: WHERE RACTRXLN.LINE_TYPE = 'LINE'
363: AND RACTRXLN.interface_line_context = 'OKL_CONTRACTS'
364: AND RACTRXLN.CUSTOMER_TRX_ID = p_customer_trx_id;
365: l_inv_ln_id NUMBER := NULL;

Line 384: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN

380: FUNCTION LINE_NUMBER_APPLIED(p_cash_receipt_id IN NUMBER,
381: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
382: CURSOR invoice_lines(p_cash_receipt_id IN NUMBER,p_customer_trx_id IN NUMBER) IS
383: SELECT RACTRXLN.line_number
384: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRXLN
385: WHERE RACTRXLN.LINE_TYPE = 'LINE'
386: AND RACTRXLN.interface_line_context = 'OKL_CONTRACTS'
387: AND RACTRXLN.CUSTOMER_TRX_ID = p_customer_trx_id;
388: l_inv_ln_num NUMBER := NULL;

Line 416: FROM RA_CUSTOMER_TRX_LINES_ALL

412:
413: FUNCTION get_tld_amount_orig( p_tld_id IN NUMBER ) RETURN NUMBER IS
414: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
415: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
416: FROM RA_CUSTOMER_TRX_LINES_ALL
417: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
418: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
419:
420: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 422: FROM RA_CUSTOMER_TRX_LINES_ALL

418: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
419:
420: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
421: SELECT COUNT(1) LINE_COUNT
422: FROM RA_CUSTOMER_TRX_LINES_ALL
423: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
424: AND LINE_TYPE = 'LINE';
425:
426: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 426: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

422: FROM RA_CUSTOMER_TRX_LINES_ALL
423: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
424: AND LINE_TYPE = 'LINE';
425:
426: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
427: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
428: l_line_count NUMBER;
429: l_amount_orig NUMBER := 0;
430: BEGIN

Line 427: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

423: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
424: AND LINE_TYPE = 'LINE';
425:
426: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
427: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
428: l_line_count NUMBER;
429: l_amount_orig NUMBER := 0;
430: BEGIN
431: NULL;

Line 459: FROM RA_CUSTOMER_TRX_LINES_ALL

455:
456: FUNCTION get_tld_amount_applied( p_tld_id IN NUMBER ) RETURN NUMBER IS
457: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
458: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
459: FROM RA_CUSTOMER_TRX_LINES_ALL
460: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
461: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
462:
463: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 465: FROM RA_CUSTOMER_TRX_LINES_ALL

461: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
462:
463: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
464: SELECT COUNT(1) LINE_COUNT
465: FROM RA_CUSTOMER_TRX_LINES_ALL
466: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
467: AND LINE_TYPE = 'LINE';
468:
469: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 469: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

465: FROM RA_CUSTOMER_TRX_LINES_ALL
466: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
467: AND LINE_TYPE = 'LINE';
468:
469: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
470: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
471: l_line_count NUMBER;
472: l_amount_applied NUMBER := 0;
473: BEGIN

Line 470: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

466: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
467: AND LINE_TYPE = 'LINE';
468:
469: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
470: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
471: l_line_count NUMBER;
472: l_amount_applied NUMBER := 0;
473: BEGIN
474: NULL;

Line 502: FROM RA_CUSTOMER_TRX_LINES_ALL

498:
499: FUNCTION get_tld_amount_credited( p_tld_id IN NUMBER ) RETURN NUMBER IS
500: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
501: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
502: FROM RA_CUSTOMER_TRX_LINES_ALL
503: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
504: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
505:
506: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 508: FROM RA_CUSTOMER_TRX_LINES_ALL

504: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
505:
506: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
507: SELECT COUNT(1) LINE_COUNT
508: FROM RA_CUSTOMER_TRX_LINES_ALL
509: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
510: AND LINE_TYPE = 'LINE';
511:
512: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 512: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

508: FROM RA_CUSTOMER_TRX_LINES_ALL
509: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
510: AND LINE_TYPE = 'LINE';
511:
512: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
513: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
514: l_line_count NUMBER;
515: l_amount_credited NUMBER := 0;
516: BEGIN

Line 513: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

509: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
510: AND LINE_TYPE = 'LINE';
511:
512: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
513: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
514: l_line_count NUMBER;
515: l_amount_credited NUMBER := 0;
516: BEGIN
517: NULL;

Line 545: FROM RA_CUSTOMER_TRX_LINES_ALL

541:
542: FUNCTION get_tld_amount_remaining( p_tld_id IN NUMBER ) RETURN NUMBER IS
543: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
544: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
545: FROM RA_CUSTOMER_TRX_LINES_ALL
546: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
547: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
548:
549: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 551: FROM RA_CUSTOMER_TRX_LINES_ALL

547: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
548:
549: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
550: SELECT COUNT(1) LINE_COUNT
551: FROM RA_CUSTOMER_TRX_LINES_ALL
552: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
553: AND LINE_TYPE = 'LINE';
554:
555: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 555: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

551: FROM RA_CUSTOMER_TRX_LINES_ALL
552: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
553: AND LINE_TYPE = 'LINE';
554:
555: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
556: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
557: l_line_count NUMBER;
558: l_amount_remaining NUMBER := 0;
559: BEGIN

Line 556: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

552: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
553: AND LINE_TYPE = 'LINE';
554:
555: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
556: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
557: l_line_count NUMBER;
558: l_amount_remaining NUMBER := 0;
559: BEGIN
560: NULL;

Line 602: FROM RA_CUSTOMER_TRX_LINES_ALL

598: IS
599:
600: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
601: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
602: FROM RA_CUSTOMER_TRX_LINES_ALL
603: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
604: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
605:
606: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 608: FROM RA_CUSTOMER_TRX_LINES_ALL

604: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
605:
606: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
607: SELECT COUNT(1) LINE_COUNT
608: FROM RA_CUSTOMER_TRX_LINES_ALL
609: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
610: AND LINE_TYPE = 'LINE';
611:
612: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS

Line 614: FROM RA_CUSTOMER_TRX_LINES_ALL

610: AND LINE_TYPE = 'LINE';
611:
612: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS
613: SELECT SUM(NVL(EXTENDED_AMOUNT, 0)) LINE_TAX_AMOUNT
614: FROM RA_CUSTOMER_TRX_LINES_ALL
615: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
616: AND LINE_TYPE='TAX';
617:
618: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 618: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

614: FROM RA_CUSTOMER_TRX_LINES_ALL
615: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
616: AND LINE_TYPE='TAX';
617:
618: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
619: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
620: l_line_count NUMBER;
621: l_amount_remaining NUMBER := 0;
622:

Line 619: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

615: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
616: AND LINE_TYPE='TAX';
617:
618: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
619: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
620: l_line_count NUMBER;
621: l_amount_remaining NUMBER := 0;
622:
623: l_api_name VARCHAR2(60) := 'Get TLD Balance';

Line 698: FROM RA_CUSTOMER_TRX_LINES_ALL LNS,

694:
695:
696: CURSOR cust_trx_csr(p_cust_trx_number VARCHAR2, p_contract_number VARCHAR2) IS
697: SELECT LNS.CUSTOMER_TRX_ID
698: FROM RA_CUSTOMER_TRX_LINES_ALL LNS,
699: RA_CUSTOMER_TRX_ALL HDR
700: WHERE LNS.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number
701: AND HDR.TRX_NUMBER = p_cust_trx_number
702: AND HDR.CUSTOMER_TRX_ID = LNS.CUSTOMER_TRX_ID;

Line 705: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

701: AND HDR.TRX_NUMBER = p_cust_trx_number
702: AND HDR.CUSTOMER_TRX_ID = LNS.CUSTOMER_TRX_ID;
703:
704:
705: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
706: l_amount_remaining NUMBER := 0;
707:
708: l_api_name VARCHAR2(60) := 'get_contract_invoice_balance';
709:

Line 737: FROM RA_CUSTOMER_TRX_LINES_ALL

733:
734: FUNCTION INVOICE_LINE_TAX_AMOUNT(p_customer_trx_line_id NUMBER) RETURN NUMBER IS
735: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS
736: SELECT SUM(NVL(EXTENDED_AMOUNT, 0)) LINE_TAX_AMOUNT
737: FROM RA_CUSTOMER_TRX_LINES_ALL
738: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
739: AND LINE_TYPE='TAX';
740:
741: l_tax_amount NUMBER;

Line 1089: FROM RA_CUSTOMER_TRX_LINES_ALL

1085:
1086: FUNCTION get_tld_amt_remaining_WOTAX( p_tld_id IN NUMBER ) RETURN NUMBER IS
1087: CURSOR cust_trx_csr(p_interface_line_attribute14 VARCHAR2) IS
1088: SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
1089: FROM RA_CUSTOMER_TRX_LINES_ALL
1090: WHERE INTERFACE_LINE_ATTRIBUTE14 = p_interface_line_attribute14
1091: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
1092:
1093: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS

Line 1095: FROM RA_CUSTOMER_TRX_LINES_ALL

1091: AND INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS';
1092:
1093: CURSOR line_count_csr(p_customer_trx_id NUMBER) IS
1094: SELECT COUNT(1) LINE_COUNT
1095: FROM RA_CUSTOMER_TRX_LINES_ALL
1096: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
1097: AND LINE_TYPE = 'LINE';
1098:
1099: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

Line 1099: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;

1095: FROM RA_CUSTOMER_TRX_LINES_ALL
1096: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
1097: AND LINE_TYPE = 'LINE';
1098:
1099: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
1100: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1101: l_line_count NUMBER;
1102: l_amount_remaining NUMBER := 0;
1103: BEGIN

Line 1100: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

1096: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
1097: AND LINE_TYPE = 'LINE';
1098:
1099: l_customer_trx_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID%TYPE;
1100: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1101: l_line_count NUMBER;
1102: l_amount_remaining NUMBER := 0;
1103: BEGIN
1104: NULL;

Line 1184: FROM RA_CUSTOMER_TRX_LINES_ALL

1180: p_customer_trx_id IN NUMBER,
1181: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1182: CURSOR invoice_line_amount(p_header_id NUMBER, p_line_id NUMBER) IS
1183: SELECT NVL(EXTENDED_AMOUNT, 0) LINE_AMOUNT
1184: FROM RA_CUSTOMER_TRX_LINES_ALL
1185: WHERE CUSTOMER_TRX_ID = p_header_id
1186: AND CUSTOMER_TRX_LINE_ID = p_line_id;
1187:
1188: l_line_amount NUMBER;

Line 1283: ra_customer_trx_lines_all lines

1279: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1280: FROM ar_adjustments_all adj,
1281: ar_payment_schedules_all sch,
1282: ar_distributions_all dist,
1283: ra_customer_trx_lines_all lines
1284: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1285: AND sch.class = 'INV'
1286: AND sch.customer_trx_id = p_header_id
1287: AND adj.ADJUSTMENT_ID = dist.source_id

Line 1347: FROM RA_CUSTOMER_TRX_LINES_ALL

1343: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1344:
1345: CURSOR invoice_line_tax_amount(p_line_id NUMBER) IS
1346: SELECT SUM(NVL(EXTENDED_AMOUNT, 0)) LINE_TAX_AMOUNT
1347: FROM RA_CUSTOMER_TRX_LINES_ALL
1348: WHERE LINK_TO_CUST_TRX_LINE_ID = p_line_id
1349: AND AMOUNT_INCLUDES_TAX_FLAG = 'Y';
1350:
1351: l_line_amount NUMBER;

Line 1378: ra_customer_trx_lines_all lines

1374: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
1375: FROM ar_receivable_applications_all app,
1376: ar_payment_schedules_all sch,
1377: ar_distributions_all ad,
1378: ra_customer_trx_lines_all lines
1379: WHERE app.status = 'APP'
1380: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1381: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo
1382: AND sch.customer_trx_id = p_header_id

Line 1414: ra_customer_trx_lines_all lines

1410: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1411: FROM ar_receivable_applications_all app,
1412: ar_payment_schedules_all sch,
1413: ar_distributions_all ad,
1414: ra_customer_trx_lines_all lines
1415: WHERE app.status = 'APP'
1416: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1417: AND sch.class = 'INV'
1418: AND sch.customer_trx_id = p_header_id

Line 1451: ra_customer_trx_lines_all lines

1447: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1448: FROM ar_adjustments_all adj,
1449: ar_payment_schedules_all sch,
1450: ar_distributions_all dist,
1451: ra_customer_trx_lines_all lines
1452: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1453: AND sch.class = 'INV'
1454: AND sch.customer_trx_id = p_header_id
1455: AND adj.ADJUSTMENT_ID = dist.source_id