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

Line 54: FROM ap_invoice_distributions_all aid

50: , SUM( NVL( aphd.invoice_dist_base_amount, 0 ) ) inv_amt
51: , SUM( NVL( aphd.cleared_base_amount, 0 ) ) inv_clr_amt
52: , SUM( NVL( aphd.matured_base_amount, 0 ) ) inv_mat_amt
53: , aid.invoice_id
54: FROM ap_invoice_distributions_all aid
55: , ap_payment_hist_dists aphd
56: WHERE aid.invoice_distribution_id = aphd.invoice_distribution_id
57: AND aphd.payment_history_id = p_payment_history_id
58: AND aphd.accounting_event_id = p_accounting_event_id

Line 115: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID

111: , NULL)
112: WHERE APHD.ACCOUNTING_EVENT_ID =P_XLA_EVENT_REC.EVENT_ID
113: AND APHD.INVOICE_DISTRIBUTION_ID IN
114: (SELECT INVOICE_DISTRIBUTION_ID
115: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
116: WHERE AID.INVOICE_ID=GAIN_LOSS_TBL(I).INVOICE_ID) ;
117:
118: /*Commented code removed*/
119: ELSIF P_XLA_Event_Rec.Event_Type_Code IN ('PAYMENT MATURED'

Line 138: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID

134: , NULL)
135: WHERE APHD.ACCOUNTING_EVENT_ID =P_XLA_EVENT_REC.EVENT_ID
136: AND APHD.INVOICE_DISTRIBUTION_ID IN
137: (SELECT INVOICE_DISTRIBUTION_ID
138: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
139: WHERE AID.INVOICE_ID=GAIN_LOSS_TBL(I).INVOICE_ID) ;
140:
141: /*Commented code removed*/
142: ELSIF P_XLA_Event_Rec.Event_Type_Code IN ('PAYMENT CLEARED',

Line 185: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID

181: , NULL)
182: WHERE APHD.ACCOUNTING_EVENT_ID =P_XLA_EVENT_REC.EVENT_ID
183: AND APHD.INVOICE_DISTRIBUTION_ID IN
184: (SELECT INVOICE_DISTRIBUTION_ID
185: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
186: WHERE AID.INVOICE_ID=GAIN_LOSS_TBL(I).INVOICE_ID
187: ) ;
188: /*Commented code removed*/
189: ELSE

Line 225: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID

221: , NULL)
222: WHERE APHD.ACCOUNTING_EVENT_ID=P_XLA_EVENT_REC.EVENT_ID
223: AND APHD.INVOICE_DISTRIBUTION_ID IN
224: (SELECT INVOICE_DISTRIBUTION_ID
225: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
226: WHERE AID.INVOICE_ID=GAIN_LOSS_TBL(I).INVOICE_ID) ;
227: /*Commented code removed*/
228: ELSE
229:

Line 245: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID

241: , NULL)
242: WHERE APHD.ACCOUNTING_EVENT_ID =P_XLA_EVENT_REC.EVENT_ID
243: AND APHD.INVOICE_DISTRIBUTION_ID IN
244: (SELECT INVOICE_DISTRIBUTION_ID
245: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
246: WHERE AID.INVOICE_ID=GAIN_LOSS_TBL(I).INVOICE_ID) ;
247: /*Commented code removed*/
248: END IF;
249: END IF;

Line 269: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID

265: , NULL)
266: WHERE APHD.ACCOUNTING_EVENT_ID =P_XLA_EVENT_REC.EVENT_ID
267: AND APHD.INVOICE_DISTRIBUTION_ID IN
268: (SELECT INVOICE_DISTRIBUTION_ID
269: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
270: WHERE AID.INVOICE_ID=GAIN_LOSS_TBL(I).INVOICE_ID);
271:
272: END IF;
273: /*Commented code removed*/

Line 351: FROM ap_invoice_distributions_all aid,

347: -- and sum of the distributions in the invoice adjustment event is 0
348:
349: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
350: SELECT SUM(amount), count(1)
351: FROM ap_invoice_distributions_all aid,
352: xla_events evnt,
353: ap_system_parameters_all asp
354: WHERE aid.accounting_event_id = p_acct_event_id
355: AND aid.accounting_event_id = evnt.event_id

Line 708: -- FROM AP_Invoice_Distributions_ALL AID,

704: --
705: -- commented below for bug10183934
706: --SELECT count(*)
707: -- INTO l_upg_prepay_app
708: -- FROM AP_Invoice_Distributions_ALL AID,
709: -- XLA_AE_Headers XAH
710: -- WHERE AID.accounting_event_id = XAH.Event_ID
711: -- AND XAH.Application_ID = 200
712: -- AND XAH.Event_type_Code IN ('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')

Line 830: FROM ap_invoice_distributions_all aid

826: G_Proration_Divisor,
827: l_inv_time_dist_total,
828: l_curr_pay_awt_tot,
829: l_inv_time_awt_tot
830: FROM ap_invoice_distributions_all aid
831: WHERE aid.invoice_id = l_inv_pay_rec.invoice_id
832: AND aid.line_type_lookup_code <> 'PREPAY'
833: AND aid.prepay_distribution_id IS NULL
834: AND (aid.awt_invoice_payment_id IS NULL OR

Line 878: FROM AP_Invoice_Distributions_All AID,

874:
875: SELECT Sub.Invoice_Distribution_ID
876: INTO G_Last_NonExcluded_Dist_ID
877: FROM (SELECT AID.Invoice_Distribution_ID
878: FROM AP_Invoice_Distributions_All AID,
879: Financials_System_Params_All FSP,
880: AP_Invoices_All AI,
881: AP_System_Parameters_All ASP
882: WHERE AID.Invoice_ID = l_inv_rec.Invoice_ID

Line 1336: FROM ap_invoice_distributions_all aid

1332: G_Proration_Divisor,
1333: l_inv_time_dist_total,
1334: l_curr_pay_awt_tot,
1335: l_inv_time_awt_tot
1336: FROM ap_invoice_distributions_all aid
1337: WHERE aid.invoice_id = l_inv_pay_rec.invoice_id
1338: AND aid.line_type_lookup_code <> 'PREPAY'
1339: AND aid.prepay_distribution_id IS NULL
1340: AND (aid.awt_invoice_payment_id IS NULL OR

Line 1710: FROM AP_Invoice_Distributions_All AID,

1706: AID.Amount_Variance,
1707: AID.Base_Amount_Variance,
1708: AID.historical_flag, -- bug fix 6674279
1709: AID.accounting_event_id -- bug fix 6674279
1710: FROM AP_Invoice_Distributions_All AID,
1711: AP_Payment_History_All APH,
1712: AP_Payment_Hist_Dists APHD
1713: WHERE AID.Invoice_ID = P_Invoice_ID
1714: AND NVL(AID.Reversal_Flag,'N') <> 'Y'

Line 1907: FROM AP_Invoice_Distributions_All AID

1903:
1904: BEGIN
1905: SELECT AID.Invoice_ID
1906: INTO l_invoice_id
1907: FROM AP_Invoice_Distributions_All AID
1908: WHERE AID.Accounting_Event_ID = l_pay_hist_rec.invoice_adjustment_event_id
1909: AND Rownum = 1;
1910: EXCEPTION
1911: WHEN NO_DATA_FOUND THEN

Line 1953: FROM ap_invoice_distributions_all aid

1949: G_Proration_Divisor,
1950: l_inv_time_dist_total,
1951: l_curr_pay_awt_tot,
1952: l_inv_time_awt_tot
1953: FROM ap_invoice_distributions_all aid
1954: WHERE aid.invoice_id = l_inv_pay_rec.invoice_id
1955: AND aid.line_type_lookup_code <> 'PREPAY'
1956: AND aid.prepay_distribution_id IS NULL
1957: AND (aid.awt_invoice_payment_id IS NULL OR

Line 2021: FROM AP_Invoice_Distributions_All AID

2017: END IF;
2018:
2019: SELECT SUM(AID.Amount)
2020: INTO l_inv_adj_amount
2021: FROM AP_Invoice_Distributions_All AID
2022: WHERE AID.Accounting_Event_ID = l_pay_hist_rec.invoice_adjustment_event_id;
2023:
2024: G_Inv_Adj_Amount := l_inv_adj_amount;
2025: --bug 9495429 end

Line 2210: FROM ap_invoice_distributions_all d

2206: AND aph2.posted_flag <> 'Y'
2207: AND aph1.posted_flag <> 'Y'
2208: AND aph1.transaction_type = aph2.transaction_type
2209: AND l_invoice_id = (SELECT invoice_id
2210: FROM ap_invoice_distributions_all d
2211: WHERE d.accounting_event_id = aph2.invoice_adjustment_event_id
2212: AND rownum = 1);
2213:
2214: IF ( l_do_round = l_pay_hist_rec.payment_history_id ) Then

Line 2226: AP_Invoice_Distributions_All AID,

2222: l_sum_disc_amount,
2223: l_sum_error_amount,
2224: l_sum_charge_amount
2225: FROM AP_Payment_Hist_Dists APHD,
2226: AP_Invoice_Distributions_All AID,
2227: AP_Payment_History_All APH
2228: WHERE APH.Related_Event_ID = l_pay_hist_rec.related_event_id
2229: AND APHD.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
2230: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 3202: FROM ap_invoice_distributions_all aid

3198: )
3199: + nvl
3200: (
3201: (SELECT sum(amount)
3202: FROM ap_invoice_distributions_all aid
3203: WHERE aid.invoice_id =p_inv_pay_rec.invoice_id
3204: AND aid.awt_invoice_payment_id =p_inv_pay_rec.invoice_payment_id
3205: AND aid.line_type_lookup_code ='AWT'
3206: AND aid.awt_related_id =p_inv_dist_rec.invoice_distribution_id

Line 3213: FROM ap_invoice_distributions_all aid

3209: )
3210: + nvl
3211: (
3212: (SELECT sum(amount) / g_proration_divisor * (l_pay_amount_inv_curr - g_pay_awt_total_amt)
3213: FROM ap_invoice_distributions_all aid
3214: WHERE aid.invoice_id =p_inv_pay_rec.invoice_id
3215: AND aid.line_type_lookup_code ='AWT'
3216: AND awt_invoice_payment_id is null
3217: AND awt_related_id =p_inv_dist_rec.invoice_distribution_id

Line 3296: FROM ap_invoice_distributions_all aid

3292: l_bank_curr_amount
3293: FROM ap_payment_hist_dists aphd
3294: WHERE aphd.invoice_distribution_id IN
3295: (SELECT invoice_distribution_id
3296: FROM ap_invoice_distributions_all aid
3297: WHERE aid.invoice_id = p_inv_rec.invoice_id
3298: )
3299: AND aphd.payment_history_id IN
3300: (SELECT aph.payment_history_id

Line 3302: ap_invoice_distributions_all aid

3298: )
3299: AND aphd.payment_history_id IN
3300: (SELECT aph.payment_history_id
3301: FROM ap_payment_history_all aph,
3302: ap_invoice_distributions_all aid
3303: WHERE aph.check_id = p_xla_event_rec.source_id_int_1
3304: AND aid.invoice_id = p_inv_rec.invoice_id
3305: AND aph.invoice_adjustment_event_id = aid.accounting_event_id
3306: AND aph.transaction_type =

Line 3393: FROM ap_invoice_distributions_all aid

3389: )
3390: + nvl
3391: (
3392: (SELECT sum(amount)
3393: FROM ap_invoice_distributions_all aid
3394: WHERE aid.invoice_id =p_inv_pay_rec.invoice_id
3395: AND aid.awt_invoice_payment_id =p_inv_pay_rec.invoice_payment_id
3396: AND aid.line_type_lookup_code ='AWT'
3397: AND aid.awt_related_id =p_inv_dist_rec.invoice_distribution_id

Line 3404: FROM ap_invoice_distributions_all aid

3400: )
3401: + nvl
3402: (
3403: (SELECT sum(amount) / g_proration_divisor * (l_pay_amount_inv_curr - g_pay_awt_total_amt)
3404: FROM ap_invoice_distributions_all aid
3405: WHERE aid.invoice_id =p_inv_pay_rec.invoice_id
3406: AND aid.line_type_lookup_code ='AWT'
3407: AND awt_invoice_payment_id is null
3408: AND awt_related_id =p_inv_dist_rec.invoice_distribution_id

Line 3865: FROM AP_Invoice_Distributions_All AID

3861: p_inv_rec.payment_cross_rate_date,
3862: 'EMU FIXED',
3863: SUM(NVL(AID.Amount,0)))
3864: INTO l_invoice_amount
3865: FROM AP_Invoice_Distributions_All AID
3866: WHERE AID.Invoice_ID = p_inv_pay_rec.Invoice_ID
3867: AND AID.Line_Type_Lookup_Code NOT IN ('PREPAY', 'AWT')
3868: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
3869: AND AID.Prepay_Distribution_ID IS NULL

Line 4765: AP_Invoice_Distributions_All AID

4761: SYSDATE,
4762: FND_GLOBAL.Conc_Request_ID
4763: FROM AP_Payment_Hist_Dists APHD,
4764: AP_Invoice_Payments_All AIP,
4765: AP_Invoice_Distributions_All AID
4766: WHERE AIP.Invoice_Payment_ID = p_reversal_inv_pmt_id
4767: AND AIP.Accounting_Event_ID = APHD.Accounting_Event_ID
4768: AND AIP.Invoice_ID = AID.Invoice_ID
4769: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID;

Line 4857: AP_Invoice_Distributions_All AID -- 6804379

4853: APHD.Gain_Loss_Indicator --11681786
4854: FROM AP_Payment_Hist_Dists APHD,
4855: AP_Payment_History_All APH,
4856: AP_Invoice_Payments_All AIP,
4857: AP_Invoice_Distributions_All AID -- 6804379
4858: WHERE nvl(APH.Related_Event_ID, APH.Accounting_Event_ID) = p_related_event_id
4859: AND APHD.Payment_History_ID = APH.Payment_History_ID
4860: AND NVL(APHD.Reversal_Flag,'N') <> 'Y'
4861: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 4868: AP_Invoice_Distributions_ALL AID1 --Bug11681786

4864: AND AIP.Check_ID = APH.Check_ID -- Bug 6856694
4865: AND AIP.Invoice_ID = AID.Invoice_ID
4866: AND NOT EXISTS (SELECT 'Reversal Payment Dists'
4867: FROM AP_Payment_Hist_Dists APHD1,
4868: AP_Invoice_Distributions_ALL AID1 --Bug11681786
4869: WHERE APHD1.Reversed_Pay_Hist_Dist_ID = APHD.Payment_Hist_Dist_ID -- Bug 6856694
4870: AND APHD1.Invoice_Distribution_ID IN (AID1.Invoice_Distribution_id, APHD.Invoice_Distribution_ID)
4871: AND AID1.Parent_Reversal_ID (+) = APHD.Invoice_Distribution_ID );
4872:

Line 4948: AP_Invoice_Distributions_ALL AID1 --Bug11681786

4944: AND APHD.Payment_History_ID = APH.Payment_History_ID
4945: AND NVL(APHD.Reversal_Flag,'N') <> 'Y'
4946: AND NOT EXISTS (SELECT 'Reversal Payment Dists'
4947: FROM AP_Payment_Hist_Dists APHD1,
4948: AP_Invoice_Distributions_ALL AID1 --Bug11681786
4949: WHERE APHD1.Reversed_Pay_Hist_Dist_ID = APHD.Payment_Hist_Dist_ID -- Bug 6856694
4950: AND APHD1.Invoice_Distribution_ID IN (AID1.Invoice_Distribution_id, APHD.Invoice_Distribution_ID)
4951: AND AID1.Parent_Reversal_ID (+) = APHD.Invoice_Distribution_ID );
4952:

Line 5441: -- ap_invoice_distributions_all

5437:
5438: -- Bug 8708433 This insert is for primary ledger id , hence the new join condition
5439: -- AND AEH.ledger_id = ASP.Set_Of_Books_ID
5440: -- In this insert, we are prorating the amounts on the basis of the table
5441: -- ap_invoice_distributions_all
5442:
5443: INSERT INTO XLA_Distribution_Links t1
5444: (APPLICATION_ID,
5445: EVENT_ID,

Line 5676: AP_Invoice_Distributions_All AID,

5672: XLA_AE_Headers AEH,
5673: XLA_AE_Lines AEL,
5674: AP_Inv_Dists_Source AID1,
5675: AP_Invoices_All AI,
5676: AP_Invoice_Distributions_All AID,
5677: AP_Payment_Hist_Dists APHD,
5678: XLA_Transaction_Entities_Upg XTE_INV --Bug7169843 Bug11071399
5679: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
5680: AND AC.Org_ID = ASP.Org_ID

Line 5793: AP_Invoice_Distributions_All AID,

5789: AP_Payment_History_All APH,
5790: XLA_AE_Headers AEH,
5791: XLA_AE_Lines AEL,
5792: AP_Payment_Hist_Dists APHD,
5793: AP_Invoice_Distributions_All AID,
5794: AP_Invoices_All AI,
5795: XLA_Transaction_Entities_Upg XTE_INV --Bug7169843 Bug11071399
5796: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
5797: AND AC.Org_ID = ASP.Org_ID

Line 5872: -- basis of the amounts in ap_invoice_distributions_all, which is in another

5868: -- while inserting into xla_distribution_links should happen on the basis of
5869: -- the amounts in the table ap_mc_invoice_dists, this is required becasue
5870: -- if the primary ledger and the secondary ledger have a different currency,
5871: -- then doing the proration for accounting entries of secondary ledger on the
5872: -- basis of the amounts in ap_invoice_distributions_all, which is in another
5873: -- currency would be wrong.
5874:
5875: INSERT INTO XLA_Distribution_Links t1
5876: (APPLICATION_ID,

Line 6109: AP_Invoice_Distributions_All AID,

6105: XLA_AE_Headers AEH,
6106: XLA_AE_Lines AEL,
6107: AP_Inv_Dists_Source AID1,
6108: AP_Invoices_All AI,
6109: AP_Invoice_Distributions_All AID,
6110: AP_Payment_Hist_Dists APHD,
6111: XLA_Transaction_Entities_Upg XTE_INV, --Bug7169843 Bug11071399
6112: AP_MC_Invoice_Dists AID_MC
6113: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1

Line 6209: AP_Invoice_Distributions_All AID,

6205: AP_Payment_Hist_Dists APHD,
6206: ap_mc_invoice_dists AID_MC,
6207: AP_Invoices_All AI,
6208: XLA_Transaction_Entities_Upg XTE_INV, --Bug7169843 Bug11071399
6209: AP_Invoice_Distributions_All AID,
6210: AP_Inv_Dists_Source AID1 --13520870
6211: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
6212: AND AC.Org_ID = ASP.Org_ID
6213: AND XLE.Event_ID = p_accounting_event_id