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.AP_PREPAY_UTILS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 13: FROM ap_invoice_distributions_all

9:
10: BEGIN
11: SELECT SUM(NVL(prepay_amount_remaining, total_dist_amount))
12: INTO l_prepay_amount_remaining
13: FROM ap_invoice_distributions_all
14: WHERE invoice_id = p_invoice_id
15: AND invoice_line_number = p_line_number
16: AND line_type_lookup_code IN
17: ('ITEM', 'ACCRUAL',

Line 48: FROM ap_invoice_distributions_all

44: l_prepay_amount_remaining_tax := 0;
45:
46: SELECT NVL(SUM(NVL(prepay_amount_remaining, total_dist_amount)),0)
47: INTO l_prepay_amount_remaining_item
48: FROM ap_invoice_distributions_all
49: WHERE invoice_id = p_invoice_id
50: AND invoice_line_number = p_line_number
51: AND line_type_lookup_code IN
52: ('ITEM', 'ACCRUAL')

Line 60: FROM ap_invoice_distributions_all aid, --Tax line

56: --To get the exclusive tax amount tied to the Item line of Prepayment invoice.
57: /*
58: SELECT NVL(SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount)),0)
59: INTO l_prepay_amount_remaining_tax
60: FROM ap_invoice_distributions_all aid, --Tax line
61: ap_invoice_distributions_all aid1 --Item line
62: WHERE aid1.invoice_id = p_invoice_id
63: AND aid1.invoice_line_number = p_line_number
64: AND aid.invoice_id = aid1.invoice_id

Line 61: ap_invoice_distributions_all aid1 --Item line

57: /*
58: SELECT NVL(SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount)),0)
59: INTO l_prepay_amount_remaining_tax
60: FROM ap_invoice_distributions_all aid, --Tax line
61: ap_invoice_distributions_all aid1 --Item line
62: WHERE aid1.invoice_id = p_invoice_id
63: AND aid1.invoice_line_number = p_line_number
64: AND aid.invoice_id = aid1.invoice_id
65: AND aid.charge_applicable_to_dist_id = aid1.invoice_distribution_id

Line 207: ap_invoice_distributions_all aid

203:
204: CURSOR c_prepay_number IS
205: SELECT invoice_num
206: FROM ap_invoices_all ai,
207: ap_invoice_distributions_all aid
208: WHERE ai.invoice_id = aid.invoice_id
209: AND aid.invoice_distribution_id = l_prepay_dist_id;
210:
211: BEGIN

Line 233: FROM ap_invoice_distributions_all

229: l_prepay_dist_number VARCHAR2(50);
230:
231: CURSOR c_prepay_dist_number IS
232: SELECT distribution_line_number
233: FROM ap_invoice_distributions_all
234: WHERE invoice_distribution_id = l_prepay_dist_id;
235:
236: BEGIN
237:

Line 276: FROM ap_invoice_distributions_all aid,

272: AND nvl(prepay_line_number,-999)<>-999 ; */
273:
274: SELECT (0 - SUM(NVL(aid.amount,0)))
275: INTO l_prepaid_amount
276: FROM ap_invoice_distributions_all aid,
277: ap_invoice_lines_all ail
278: WHERE ail.invoice_id = l_invoice_id
279: AND ail.invoice_id = aid.invoice_id
280: AND ail.line_number = aid.invoice_line_number

Line 392: FROM ap_invoice_distributions_all aid,

388:
389: CURSOR prepay_cursor is
390: SELECT SUM(total_dist_amount -
391: NVL(prepay_amount_remaining, total_dist_amount))
392: FROM ap_invoice_distributions_all aid,
393: ap_invoice_lines_all ail
394: WHERE aid.invoice_id = P_invoice_id
395: AND aid.invoice_id = ail.invoice_id
396: AND aid.invoice_line_number = ail.line_number

Line 446: FROM ap_invoice_distributions_all aid,

442: -- Inclusive tax will be included in the prepay_amount_remaining
443: -- exclusive tax will not.
444: CURSOR c_prepay_amount_remaining IS
445: SELECT SUM(nvl(prepay_amount_remaining, total_dist_amount))
446: FROM ap_invoice_distributions_all aid,
447: ap_invoice_lines_all ail
448: WHERE aid.invoice_id = P_invoice_id
449: AND aid.invoice_id = ail.invoice_id
450: AND aid.invoice_line_number = ail.line_number

Line 540: FROM ap_invoice_distributions_all aid1,

536: -- tax recovery rate
537:
538: SELECT SUM((NVL(aid1.amount, 0) - NVL(aid1.prepay_tax_diff_amount, 0))* -1)
539: INTO l_prepay_amt_applied
540: FROM ap_invoice_distributions_all aid1,
541: ap_invoice_distributions_all aid2,
542: ap_invoice_lines_all ail
543: WHERE aid1.invoice_id = P_invoice_id
544: AND aid1.line_type_lookup_code IN ('PREPAY', 'REC_TAX', 'NONREC_TAX')

Line 541: ap_invoice_distributions_all aid2,

537:
538: SELECT SUM((NVL(aid1.amount, 0) - NVL(aid1.prepay_tax_diff_amount, 0))* -1)
539: INTO l_prepay_amt_applied
540: FROM ap_invoice_distributions_all aid1,
541: ap_invoice_distributions_all aid2,
542: ap_invoice_lines_all ail
543: WHERE aid1.invoice_id = P_invoice_id
544: AND aid1.line_type_lookup_code IN ('PREPAY', 'REC_TAX', 'NONREC_TAX')
545: AND aid1.invoice_id = ail.invoice_id

Line 601: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

597: l_bal_segment VARCHAR2(30);
598:
599: CURSOR c_prepay_dist IS
600: SELECT sum(nvl(prepay_amount_remaining,total_dist_amount)),
601: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
602: aip.dist_code_combination_id, X_Sob_Id)
603: FROM ap_invoice_distributions aip
604: WHERE aip.invoice_id = X_Prepay_Id
605: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')

Line 603: FROM ap_invoice_distributions aip

599: CURSOR c_prepay_dist IS
600: SELECT sum(nvl(prepay_amount_remaining,total_dist_amount)),
601: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
602: aip.dist_code_combination_id, X_Sob_Id)
603: FROM ap_invoice_distributions aip
604: WHERE aip.invoice_id = X_Prepay_Id
605: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
606: AND nvl(aip.reversal_flag,'N') <> 'Y'
607: AND nvl(aip.prepay_amount_remaining,amount) > 0

Line 608: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

604: WHERE aip.invoice_id = X_Prepay_Id
605: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
606: AND nvl(aip.reversal_flag,'N') <> 'Y'
607: AND nvl(aip.prepay_amount_remaining,amount) > 0
608: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
609: aip.dist_code_combination_id, X_Sob_Id) IN
610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
611: aid.dist_code_combination_id, X_Sob_Id)
612: FROM ap_invoice_distributions aid

Line 610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

606: AND nvl(aip.reversal_flag,'N') <> 'Y'
607: AND nvl(aip.prepay_amount_remaining,amount) > 0
608: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
609: aip.dist_code_combination_id, X_Sob_Id) IN
610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
611: aid.dist_code_combination_id, X_Sob_Id)
612: FROM ap_invoice_distributions aid
613: WHERE aid.invoice_id = X_Invoice_ID)
614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 612: FROM ap_invoice_distributions aid

608: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
609: aip.dist_code_combination_id, X_Sob_Id) IN
610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
611: aid.dist_code_combination_id, X_Sob_Id)
612: FROM ap_invoice_distributions aid
613: WHERE aid.invoice_id = X_Invoice_ID)
614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
615: aip.dist_code_combination_id, X_Sob_Id)
616: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
611: aid.dist_code_combination_id, X_Sob_Id)
612: FROM ap_invoice_distributions aid
613: WHERE aid.invoice_id = X_Invoice_ID)
614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
615: aip.dist_code_combination_id, X_Sob_Id)
616: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
617: aip.dist_code_combination_id, X_Sob_Id);
618:

Line 616: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

612: FROM ap_invoice_distributions aid
613: WHERE aid.invoice_id = X_Invoice_ID)
614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
615: aip.dist_code_combination_id, X_Sob_Id)
616: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
617: aip.dist_code_combination_id, X_Sob_Id);
618:
619: BEGIN
620:

Line 631: FROM ap_invoice_distributions

627: EXIT WHEN c_prepay_dist%NOTFOUND;
628:
629: SELECT sum(amount)
630: INTO l_invoice_amount
631: FROM ap_invoice_distributions
632: WHERE invoice_id = X_Invoice_ID
633: AND line_type_lookup_code IN ('ITEM','PREPAY')
634: AND nvl(reversal_flag,'N') <> 'Y'
635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

631: FROM ap_invoice_distributions
632: WHERE invoice_id = X_Invoice_ID
633: AND line_type_lookup_code IN ('ITEM','PREPAY')
634: AND nvl(reversal_flag,'N') <> 'Y'
635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
636: dist_code_combination_id, X_Sob_Id)
637: = l_bal_segment;
638:
639: IF l_invoice_amount <> 0 THEN

Line 663: FROM ap_invoice_distributions_all

659:
660: BEGIN
661: SELECT SUM(nvl(prepay_amount_remaining,total_dist_amount))
662: INTO l_prepay_amount_remaining
663: FROM ap_invoice_distributions_all
664: WHERE invoice_id = p_invoice_id
665: AND invoice_line_number = p_line_number
666: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL')
667: AND NVL(reversal_flag,'N') <> 'Y';

Line 689: FROM ap_invoice_distributions_all

685:
686: BEGIN
687: SELECT SUM(nvl(prepay_amount_remaining, total_dist_amount))
688: INTO l_prepay_amount_remaining
689: FROM ap_invoice_distributions_all
690: WHERE invoice_id = p_invoice_id
691: AND invoice_line_number = p_line_number
692: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX',
693: 'TIPV', 'TRV')

Line 1166: FROM ap_invoice_distributions_all

1162:
1163: BEGIN
1164: SELECT NVL(SUM(NVL(prepay_amount_remaining, total_dist_amount)), 0)
1165: INTO l_remaining_inc_tax_dist
1166: FROM ap_invoice_distributions_all
1167: WHERE invoice_id = X_Invoice_Id
1168: AND invoice_line_number = X_Line_Number
1169: AND charge_applicable_to_dist_id = X_Invoice_Dist_Id
1170: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')