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_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 255: FROM ap_invoice_distributions_all aid,

251: --Bug4539547 Added IF statement
252: If (X_LINE_NUMBER is null) then
253: SELECT NVL(SUM(aid.amount), 0)
254: INTO X_Total
255: FROM ap_invoice_distributions_all aid,
256: ap_invoice_lines_all ail
257: WHERE ail.invoice_id = X_Invoice_Id
258: AND ail.invoice_id = aid.invoice_id
259: AND ail.line_number = aid.invoice_line_number

Line 268: FROM ap_invoice_distributions_all aid,

264: OR NVL(ail.invoice_includes_prepay_flag,'N') = 'Y');
265: else
266: SELECT NVL(SUM(aid.amount), 0)
267: INTO X_Total
268: FROM ap_invoice_distributions_all aid,
269: ap_invoice_lines_all ail
270: WHERE ail.invoice_id = X_Invoice_Id
271: AND ail.invoice_id = aid.invoice_id
272: AND ail.line_number = aid.invoice_line_number

Line 1608: --to ap_invoice_distributions_all

1604: -- Set the exchange rate info, base amount and WHO columns
1605: -- for the distributions
1606:
1607: --Bugfix:4644053 changed ap_invoice_distributions
1608: --to ap_invoice_distributions_all
1609: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS base amounts';
1610:
1611: UPDATE AP_INVOICE_DISTRIBUTIONS_ALL
1612: SET base_amount =

Line 1611: UPDATE AP_INVOICE_DISTRIBUTIONS_ALL

1607: --Bugfix:4644053 changed ap_invoice_distributions
1608: --to ap_invoice_distributions_all
1609: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS base amounts';
1610:
1611: UPDATE AP_INVOICE_DISTRIBUTIONS_ALL
1612: SET base_amount =
1613: DECODE(l_base_currency_code,
1614: l_invoice_currency_code, NULL,
1615: ap_utilities_pkg.ap_round_currency(

Line 3755: FROM ap_invoice_distributions_all d5

3751: WHERE d1.invoice_id = X_Invoice_Id
3752: AND d1.posted_flag = 'N'
3753: AND (d1.invoice_id, d1.distribution_line_number) IN
3754: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3755: FROM ap_invoice_distributions_all d5
3756: WHERE (d5.invoice_id, abs(d5.amount)) IN
3757: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3758: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3759: WHERE i1.invoice_id = X_Invoice_Id

Line 3758: FROM ap_invoices_all i1, ap_invoice_distributions_all d3

3754: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3755: FROM ap_invoice_distributions_all d5
3756: WHERE (d5.invoice_id, abs(d5.amount)) IN
3757: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3758: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3759: WHERE i1.invoice_id = X_Invoice_Id
3760: AND i1.invoice_id = d3.invoice_id
3761: AND d3.line_type_lookup_code NOT IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV','IPV', 'ERV') -- Bug 11654030 <> 'TAX', Bug 12691958: Added excluding 'IPV' and 'ERV' lines
3762: AND d3.related_id IS NULL -- Bug 13864403

Line 3765: FROM ap_invoice_distributions_all d4

3761: AND d3.line_type_lookup_code NOT IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV','IPV', 'ERV') -- Bug 11654030 <> 'TAX', Bug 12691958: Added excluding 'IPV' and 'ERV' lines
3762: AND d3.related_id IS NULL -- Bug 13864403
3763: AND NOT EXISTS
3764: (SELECT d4.invoice_id
3765: FROM ap_invoice_distributions_all d4
3766: WHERE d4.invoice_id = X_Invoice_Id
3767: AND (1 = DECODE(X_Base_Currency_Code,
3768: i1.invoice_currency_code,1,
3769: DECODE(d4.exchange_rate,null,1,0))

Line 5276: from ap_invoice_distributions_all

5272: l_no_dists_exists NUMBER := 0; --bug 9216708
5273:
5274: cursor events_cur(p_invoice_id NUMBER,p_invoice_line_num NUMBER) is
5275: select distinct accounting_event_id
5276: from ap_invoice_distributions_all
5277: where invoice_id = p_invoice_id
5278: and invoice_line_number = p_invoice_line_num
5279: and posted_flag <> 'Y';
5280:

Line 5513: FROM ap_invoice_distributions_all aid

5509:
5510:
5511: SELECT SUM(AMOUNT)
5512: INTO l_dist_total
5513: FROM ap_invoice_distributions_all aid
5514: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id
5515: AND line_type_lookup_code NOT IN('AWT' , 'PREPAY','ERV','TERV')
5516: AND NOT (aid.line_type_lookup_code IN ('REC_TAX' , 'NONREC_TAX', 'TIPV', 'TRV')
5517: AND aid.prepay_distribution_id is not null) /*Bug11937214*/

Line 5529: from ap_invoice_distributions_all

5525: /* commented the following code
5526: -- bug 9216708 start
5527: select count(*)
5528: into l_dists_exists
5529: from ap_invoice_distributions_all
5530: where invoice_id = l_invoice_line_rec.invoice_id
5531: and accounting_event_id is NOT NULL
5532: and line_type_lookup_code = 'AWT'
5533: and awt_flag = 'M'

Line 5539: FROM ap_invoice_distributions_all aid

5535:
5536: IF l_dists_exists > 0 THEN
5537: SELECT nvl(max(aid.accounting_event_id),-1)
5538: INTO l_accounting_event_id
5539: FROM ap_invoice_distributions_all aid
5540: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id
5541: AND aid.line_type_lookup_code = 'AWT'
5542: AND aid.awt_flag = 'M'
5543: AND NVL(posted_flag , 'N') <> 'Y';

Line 5552: DELETE FROM ap_invoice_distributions_all aid

5548: FETCH events_cur BULK COLLECT INTO l_accounting_event_id_list;
5549: CLOSE events_cur;
5550:
5551: /* bug 10201001 end */
5552: DELETE FROM ap_invoice_distributions_all aid
5553: WHERE invoice_id = l_invoice_line_rec.invoice_id
5554: AND invoice_line_number = l_invoice_line_rec.line_number
5555: AND NVL(posted_flag , 'N') <> 'Y';
5556:

Line 5571: FROM ap_invoice_distributions_all aid

5567: FROM ap_self_assessed_tax_dist_all asatd
5568: WHERE asatd.invoice_id = l_invoice_line_rec.invoice_id
5569: AND asatd.accounting_event_id = xe.event_id)
5570: AND NOT EXISTS (SELECT 'No Invoice rows exist for this event'
5571: FROM ap_invoice_distributions_all aid
5572: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id
5573: AND aid.accounting_event_id = xe.event_id)
5574: AND NOT EXISTS (SELECT 'No payment rows exist for this event'
5575: FROM ap_invoice_payments_all aip,

Line 5594: INSERT INTO ap_invoice_distributions_all

5590: END LOOP;
5591: /* bug 10201001 end */
5592: debug_info := ' Before Insert AwT Distributions ';
5593:
5594: INSERT INTO ap_invoice_distributions_all
5595: ( batch_id
5596: , invoice_id
5597: , invoice_line_number
5598: , invoice_distribution_id

Line 5909: FROM ap_invoice_distributions_all aid

5905: , l_invoice_line_rec.primary_intended_use intended_use
5906: , 'N' rcv_charge_addition_flag
5907: , l_invoice_line_rec.pay_awt_group_id pay_awt_group_id
5908: , aid.invoice_distribution_id awt_related_id
5909: FROM ap_invoice_distributions_all aid
5910: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id
5911: AND aid.line_type_lookup_code NOT IN('AWT' , 'PREPAY','ERV','TERV')
5912: AND NOT (aid.line_type_lookup_code IN ('REC_TAX' , 'NONREC_TAX', 'TIPV', 'TRV')
5913: AND aid.prepay_distribution_id is not null) /*Bug11937214*/

Line 5922: UPDATE ap_invoice_distributions_all aid

5918:
5919: debug_info := ' After Insert AwT Distributions ';
5920: end if;
5921:
5922: UPDATE ap_invoice_distributions_all aid
5923: SET aid.amount = aid.amount -
5924: ((
5925: SELECT SUM(aid1.amount)
5926: FROM ap_invoice_distributions_all aid1

Line 5926: FROM ap_invoice_distributions_all aid1

5922: UPDATE ap_invoice_distributions_all aid
5923: SET aid.amount = aid.amount -
5924: ((
5925: SELECT SUM(aid1.amount)
5926: FROM ap_invoice_distributions_all aid1
5927: WHERE aid1.invoice_id = aid.invoice_id
5928: AND aid1.invoice_line_number = aid.invoice_line_number
5929: )- l_invoice_line_rec.amount)
5930: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id

Line 5934: FROM ap_invoice_distributions_all aid1

5930: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id
5931: AND aid.invoice_line_number = l_invoice_line_rec.line_number
5932: AND ABS(aid.amount) =
5933: ( SELECT MAX(ABS(aid1.amount))
5934: FROM ap_invoice_distributions_all aid1
5935: WHERE aid1.invoice_id = aid.invoice_id
5936: AND aid1.invoice_line_number = aid.invoice_line_number)
5937: AND rownum = 1;
5938:

Line 5941: UPDATE ap_invoice_distributions_all aid

5937: AND rownum = 1;
5938:
5939: IF X_exchange_rate_type is not null then
5940:
5941: UPDATE ap_invoice_distributions_all aid
5942: SET aid.base_amount = aid.base_amount -
5943: ((
5944: SELECT SUM(aid1.base_amount)
5945: FROM ap_invoice_distributions_all aid1

Line 5945: FROM ap_invoice_distributions_all aid1

5941: UPDATE ap_invoice_distributions_all aid
5942: SET aid.base_amount = aid.base_amount -
5943: ((
5944: SELECT SUM(aid1.base_amount)
5945: FROM ap_invoice_distributions_all aid1
5946: WHERE aid1.invoice_id = aid.invoice_id
5947: AND aid1.invoice_line_number = aid.invoice_line_number
5948: )- l_invoice_line_rec.base_amount)
5949: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id

Line 5953: FROM ap_invoice_distributions_all aid1

5949: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id
5950: AND aid.invoice_line_number = l_invoice_line_rec.line_number
5951: AND ABS(aid.base_amount) =
5952: ( SELECT MAX(ABS(aid1.base_amount))
5953: FROM ap_invoice_distributions_all aid1
5954: WHERE aid1.invoice_id = aid.invoice_id
5955: AND aid1.invoice_line_number = aid.invoice_line_number)
5956: AND rownum = 1;
5957:

Line 6639: AP_invoice_distributions_all AID

6635: ARL.percentage,
6636: ARL.amount,
6637: Sum(AID.amount)
6638: FROM AP_Allocation_Rule_Lines ARL,
6639: AP_invoice_distributions_all AID
6640: WHERE ARL.invoice_id = X_invoice_id
6641: AND AID.invoice_id = X_invoice_id
6642: AND ARL.chrg_invoice_line_number = X_line_number
6643: AND AID.invoice_line_number = ARL.to_invoice_line_number

Line 6656: AP_invoice_distributions_all AID

6652: SELECT AIL.line_number,
6653: AIL.amount,
6654: sum(AID.amount)
6655: FROM AP_invoice_lines AIL,
6656: AP_invoice_distributions_all AID
6657: WHERE AIL.invoice_id = X_invoice_id
6658: AND nvl(AIL.discarded_flag, 'N') = 'N'
6659: AND nvl(AIL.cancelled_flag, 'N') = 'N'
6660: AND AIL.amount <> 0

Line 6688: FROM ap_invoice_distributions_all AID

6684: AID.assets_tracking_flag,
6685: AID.asset_book_type_code,
6686: AID.asset_category_id,
6687: AID.description
6688: FROM ap_invoice_distributions_all AID
6689: WHERE AID.invoice_id = X_invoice_id
6690: AND AID.invoice_line_number = P_line_number
6691: AND AID.line_type_lookup_code in ('ITEM', 'ACCRUAL')
6692: ORDER BY AID.distribution_line_number;

Line 7107: FROM ap_invoice_distributions_all AID

7103: ('PRICE_CORRECTION', 'QTY_CORRECTION','LINE_CORRECTION','AMOUNT_CORRECTION')
7104: --Bug 5558693
7105: AND amount <>
7106: (SELECT NVL(SUM(NVL(aid.amount,0)),0)
7107: FROM ap_invoice_distributions_all AID
7108: WHERE AID.invoice_id = ail.invoice_id
7109: AND AID.invoice_line_number = AIL.line_number
7110: AND (AID.line_type_lookup_code NOT IN ('RETAINAGE','PREPAY')
7111: OR (AID.prepay_distribution_id IS NOT NULL

Line 8058: ap_invoice_distributions_all aid

8054: AND chrg_invoice_line_number = X_line_number
8055: AND exists
8056: (select 'Line Amount Equals Distribution Total'
8057: from ap_invoice_lines_all ail,
8058: ap_invoice_distributions_all aid
8059: where ail.invoice_id = aid.invoice_id
8060: and ail.line_number = aid.invoice_line_number
8061: and ail.invoice_id = X_invoice_id
8062: and ail.line_number = X_line_number

Line 8102: FROM ap_invoice_distributions_all AID

8098: BEGIN
8099:
8100: SELECT sum(nvl(AID.amount,0))
8101: INTO l_original_amount
8102: FROM ap_invoice_distributions_all AID
8103: WHERE AID.invoice_distribution_id = X_invoice_distribution_id
8104: OR AID.related_id = X_invoice_distribution_id;
8105:
8106:

Line 8892: debug_info := 'Select from ap_invoice_distributions_all';

8888: current_calling_sequence :=
8889: 'AP_INVOICE_DISTRIBUTIONS_PKG.DIST_REFER_ACTIVE_CORR<-'
8890: ||p_Calling_Sequence;
8891:
8892: debug_info := 'Select from ap_invoice_distributions_all';
8893:
8894: Select count(*)
8895: Into dummy
8896: From ap_invoice_distributions_all AID

Line 8896: From ap_invoice_distributions_all AID

8892: debug_info := 'Select from ap_invoice_distributions_all';
8893:
8894: Select count(*)
8895: Into dummy
8896: From ap_invoice_distributions_all AID
8897: Where NVL(AID.cancellation_flag, 'N' ) <> 'Y'
8898: And NVL( AID.reversal_flag, 'N' ) <> 'Y'
8899: And AID.corrected_invoice_dist_id = p_invoice_dist_id
8900: And rownum < 2; --bug 5034678

Line 8955: debug_info := 'Select from ap_invoice_distributions_all';

8951: current_calling_sequence :=
8952: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHRG_REFER_ACTIVE_DIST<-'
8953: ||p_Calling_Sequence;
8954:
8955: debug_info := 'Select from ap_invoice_distributions_all';
8956:
8957: Select count(*)
8958: Into dummy
8959: From ap_invoice_distributions_all AID

Line 8959: From ap_invoice_distributions_all AID

8955: debug_info := 'Select from ap_invoice_distributions_all';
8956:
8957: Select count(*)
8958: Into dummy
8959: From ap_invoice_distributions_all AID
8960: Where AID.charge_applicable_to_dist_id = p_invoice_dist_id
8961: And NVL(AID.cancellation_flag, 'N') <> 'Y'
8962: And NVL(AID.reversal_flag, 'N') <> 'Y';
8963:

Line 9132: UPDATE ap_invoice_distributions_all

9128: ||p_calling_sequence;
9129:
9130: l_debug_info := 'Updating ap_invoice_distributions';
9131:
9132: UPDATE ap_invoice_distributions_all
9133: SET distribution_class = 'PERMANENT'
9134: WHERE invoice_id = p_invoice_id
9135: AND invoice_line_number = NVL(p_invoice_line_number, invoice_line_number)
9136: AND distribution_class = 'CANDIDATE'

Line 9161: FROM ap_invoice_distributions_all aid

9157: AND ail.line_number = l_line_number_tab(uniq_values);
9158:
9159: --Commented below condition for the bug 7483192
9160: /*AND ail.amount = (SELECT SUM(NVL(aid.amount,0))
9161: FROM ap_invoice_distributions_all aid
9162: WHERE aid.invoice_id = ail.invoice_id
9163: AND aid.invoice_line_number = ail.line_number
9164: AND aid.distribution_class = 'PERMANENT'); */
9165: