DBA Data[Home] [Help]

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 419: FROM ap_invoice_distributions_all aid,

415:
416: CURSOR prepay_cursor is
417: SELECT SUM(total_dist_amount -
418: NVL(prepay_amount_remaining, total_dist_amount))
419: FROM ap_invoice_distributions_all aid,
420: ap_invoice_lines_all ail
421: WHERE aid.invoice_id = P_invoice_id
422: AND aid.invoice_id = ail.invoice_id
423: AND aid.invoice_line_number = ail.line_number

Line 473: FROM ap_invoice_distributions_all aid,

469: -- Inclusive tax will be included in the prepay_amount_remaining
470: -- exclusive tax will not.
471: CURSOR c_prepay_amount_remaining IS
472: SELECT SUM(nvl(prepay_amount_remaining, total_dist_amount))
473: FROM ap_invoice_distributions_all aid,
474: ap_invoice_lines_all ail
475: WHERE aid.invoice_id = P_invoice_id
476: AND aid.invoice_id = ail.invoice_id
477: AND aid.invoice_line_number = ail.line_number

Line 567: FROM ap_invoice_distributions_all aid1,

563: -- tax recovery rate
564:
565: SELECT SUM((NVL(aid1.amount, 0) - NVL(aid1.prepay_tax_diff_amount, 0))* -1)
566: INTO l_prepay_amt_applied
567: FROM ap_invoice_distributions_all aid1,
568: ap_invoice_distributions_all aid2,
569: ap_invoice_lines_all ail
570: WHERE aid1.invoice_id = P_invoice_id
571: AND aid1.line_type_lookup_code IN ('PREPAY', 'REC_TAX', 'NONREC_TAX')

Line 568: ap_invoice_distributions_all aid2,

564:
565: SELECT SUM((NVL(aid1.amount, 0) - NVL(aid1.prepay_tax_diff_amount, 0))* -1)
566: INTO l_prepay_amt_applied
567: FROM ap_invoice_distributions_all aid1,
568: ap_invoice_distributions_all aid2,
569: ap_invoice_lines_all ail
570: WHERE aid1.invoice_id = P_invoice_id
571: AND aid1.line_type_lookup_code IN ('PREPAY', 'REC_TAX', 'NONREC_TAX')
572: AND aid1.invoice_id = ail.invoice_id

Line 628: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

624: l_bal_segment VARCHAR2(30);
625:
626: CURSOR c_prepay_dist IS
627: SELECT sum(nvl(prepay_amount_remaining,total_dist_amount)),
628: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
629: aip.dist_code_combination_id, X_Sob_Id)
630: FROM ap_invoice_distributions aip
631: WHERE aip.invoice_id = X_Prepay_Id
632: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')

Line 630: FROM ap_invoice_distributions aip

626: CURSOR c_prepay_dist IS
627: SELECT sum(nvl(prepay_amount_remaining,total_dist_amount)),
628: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
629: aip.dist_code_combination_id, X_Sob_Id)
630: FROM ap_invoice_distributions aip
631: WHERE aip.invoice_id = X_Prepay_Id
632: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
633: AND nvl(aip.reversal_flag,'N') <> 'Y'
634: AND nvl(aip.prepay_amount_remaining,amount) > 0

Line 635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

631: WHERE aip.invoice_id = X_Prepay_Id
632: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
633: AND nvl(aip.reversal_flag,'N') <> 'Y'
634: AND nvl(aip.prepay_amount_remaining,amount) > 0
635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
636: aip.dist_code_combination_id, X_Sob_Id) IN
637: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
638: aid.dist_code_combination_id, X_Sob_Id)
639: FROM ap_invoice_distributions aid

Line 637: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

633: AND nvl(aip.reversal_flag,'N') <> 'Y'
634: AND nvl(aip.prepay_amount_remaining,amount) > 0
635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
636: aip.dist_code_combination_id, X_Sob_Id) IN
637: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
638: aid.dist_code_combination_id, X_Sob_Id)
639: FROM ap_invoice_distributions aid
640: WHERE aid.invoice_id = X_Invoice_ID)
641: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 639: FROM ap_invoice_distributions aid

635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
636: aip.dist_code_combination_id, X_Sob_Id) IN
637: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
638: aid.dist_code_combination_id, X_Sob_Id)
639: FROM ap_invoice_distributions aid
640: WHERE aid.invoice_id = X_Invoice_ID)
641: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
642: aip.dist_code_combination_id, X_Sob_Id)
643: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 641: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

637: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
638: aid.dist_code_combination_id, X_Sob_Id)
639: FROM ap_invoice_distributions aid
640: WHERE aid.invoice_id = X_Invoice_ID)
641: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
642: aip.dist_code_combination_id, X_Sob_Id)
643: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
644: aip.dist_code_combination_id, X_Sob_Id);
645:

Line 643: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

639: FROM ap_invoice_distributions aid
640: WHERE aid.invoice_id = X_Invoice_ID)
641: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
642: aip.dist_code_combination_id, X_Sob_Id)
643: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
644: aip.dist_code_combination_id, X_Sob_Id);
645:
646: BEGIN
647:

Line 658: FROM ap_invoice_distributions

654: EXIT WHEN c_prepay_dist%NOTFOUND;
655:
656: SELECT sum(amount)
657: INTO l_invoice_amount
658: FROM ap_invoice_distributions
659: WHERE invoice_id = X_Invoice_ID
660: AND line_type_lookup_code IN ('ITEM','PREPAY')
661: AND nvl(reversal_flag,'N') <> 'Y'
662: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 662: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

658: FROM ap_invoice_distributions
659: WHERE invoice_id = X_Invoice_ID
660: AND line_type_lookup_code IN ('ITEM','PREPAY')
661: AND nvl(reversal_flag,'N') <> 'Y'
662: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
663: dist_code_combination_id, X_Sob_Id)
664: = l_bal_segment;
665:
666: IF l_invoice_amount <> 0 THEN

Line 690: FROM ap_invoice_distributions_all

686:
687: BEGIN
688: SELECT SUM(nvl(prepay_amount_remaining,total_dist_amount))
689: INTO l_prepay_amount_remaining
690: FROM ap_invoice_distributions_all
691: WHERE invoice_id = p_invoice_id
692: AND invoice_line_number = p_line_number
693: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL')
694: AND NVL(reversal_flag,'N') <> 'Y';

Line 716: FROM ap_invoice_distributions_all

712:
713: BEGIN
714: SELECT SUM(nvl(prepay_amount_remaining, total_dist_amount))
715: INTO l_prepay_amount_remaining
716: FROM ap_invoice_distributions_all
717: WHERE invoice_id = p_invoice_id
718: AND invoice_line_number = p_line_number
719: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX',
720: 'TIPV', 'TRV')

Line 848: from ap_invoice_distributions_all aid,

844: -- commented code above that computes l_prep_applied
845:
846: Select nvl(SUM(aid.amount),0)
847: into l_prep_applied
848: from ap_invoice_distributions_all aid,
849: ap_invoice_lines_all ail
850: Where ail.invoice_id = aid.invoice_id
851: and ail.line_number = aid.invoice_line_number
852: and nvl(ail.invoice_includes_prepay_flag,'N') = 'N'

Line 1270: FROM ap_invoice_distributions_all

1266:
1267: BEGIN
1268: SELECT NVL(SUM(NVL(prepay_amount_remaining, total_dist_amount)), 0)
1269: INTO l_remaining_inc_tax_dist
1270: FROM ap_invoice_distributions_all
1271: WHERE invoice_id = X_Invoice_Id
1272: AND invoice_line_number = X_Line_Number
1273: AND charge_applicable_to_dist_id = X_Invoice_Dist_Id
1274: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')

Line 1310: from ap_invoice_distributions_all aid

1306: and ail.prepay_line_number = nvl(X_prepay_Line_Number,ail.prepay_line_number)
1307: and (ail.discarded_flag is null or ail.discarded_flag = 'N')
1308: and nvl(ail.invoice_includes_prepay_flag, 'N') = 'Y'
1309: and exists (select 'Prepay line dists amt remg exists'
1310: from ap_invoice_distributions_all aid
1311: where aid.invoice_id = ail.prepay_invoice_id
1312: and aid.invoice_line_number = ail.prepay_line_number
1313: and aid.prepay_amount_remaining > 0)) Then
1314: 'Y'