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_PAYMENT_HISTORY_ALL

Line 153: FROM AP_Payment_History_All APH

149: END IF;
150:
151: SELECT COUNT( * )
152: INTO l_pay_mat_count
153: FROM AP_Payment_History_All APH
154: , AP_Payment_History_All APH1
155: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id
156: AND APH.Check_ID = APH1.Check_ID
157: AND APH.Transaction_Type IN( 'PAYMENT CLEARING', 'PAYMENT CLEARING ADJUSTED' )

Line 154: , AP_Payment_History_All APH1

150:
151: SELECT COUNT( * )
152: INTO l_pay_mat_count
153: FROM AP_Payment_History_All APH
154: , AP_Payment_History_All APH1
155: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id
156: AND APH.Check_ID = APH1.Check_ID
157: AND APH.Transaction_Type IN( 'PAYMENT CLEARING', 'PAYMENT CLEARING ADJUSTED' )
158: AND APH1.Transaction_Type = 'PAYMENT MATURITY';

Line 163: , AP_Payment_History_All APH

159:
160: SELECT ASP.when_to_account_gain_loss
161: INTO l_when_to_account_gain_loss
162: FROM ap_system_parameters_all ASP
163: , AP_Payment_History_All APH
164: WHERE APH.org_id = ASP.org_id
165: AND APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
166:
167:

Line 202: , AP_Payment_History_All APH

198:
199: /* SELECT ASP.when_to_account_gain_loss
200: INTO l_when_to_account_gain_loss
201: FROM ap_system_parameters_all ASP
202: , AP_Payment_History_All APH
203: WHERE APH.org_id = ASP.org_id
204: AND APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
205: */
206:

Line 341: l_txn_curr_code AP_PAYMENT_HISTORY_ALL.PMT_CURRENCY_CODE%TYPE; --11698822

337: l_inv_time_dist_total NUMBER :=0;
338: l_inv_time_awt_tot NUMBER :=0;
339: l_exec_final_pay VARCHAR2(1) := 'Y';--9962345
340: l_cross_txn_amt NUMBER; --bug 9936620
341: l_txn_curr_code AP_PAYMENT_HISTORY_ALL.PMT_CURRENCY_CODE%TYPE; --11698822
342:
343: --Bug 8524600
344: -- condition: historical_flag =Y
345: -- and event is 'INVOICE ADJUSTMENT'

Line 419: FROM AP_Payment_History_All APH

415: INTO l_pay_history_id,
416: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
417: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
418: ap_accounting_pay_pkg.g_pmt_to_base_xrate
419: FROM AP_Payment_History_All APH
420: WHERE APH.Payment_History_ID =
421: (SELECT MAX(APH1.Payment_History_ID)
422: FROM AP_Payment_History_All APH1
423: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1

Line 422: FROM AP_Payment_History_All APH1

418: ap_accounting_pay_pkg.g_pmt_to_base_xrate
419: FROM AP_Payment_History_All APH
420: WHERE APH.Payment_History_ID =
421: (SELECT MAX(APH1.Payment_History_ID)
422: FROM AP_Payment_History_All APH1
423: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1
424: AND APH1.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED'));
425:
426:

Line 479: FROM AP_Payment_History_All APH

475: INTO l_pay_history_id,
476: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
477: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
478: ap_accounting_pay_pkg.g_pmt_to_base_xrate
479: FROM AP_Payment_History_All APH
480: WHERE APH.Payment_History_ID =
481: (SELECT MAX(APH1.Payment_History_ID)
482: FROM AP_Payment_History_All APH1
483: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1

Line 482: FROM AP_Payment_History_All APH1

478: ap_accounting_pay_pkg.g_pmt_to_base_xrate
479: FROM AP_Payment_History_All APH
480: WHERE APH.Payment_History_ID =
481: (SELECT MAX(APH1.Payment_History_ID)
482: FROM AP_Payment_History_All APH1
483: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1
484: AND APH1.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED'));
485:
486: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 496: FROM AP_Payment_History_All APH

492: END IF;
493:
494: SELECT MAX(APH.Payment_History_ID)
495: INTO l_mat_history_id
496: FROM AP_Payment_History_All APH
497: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
498: AND APH.Transaction_Type IN ('PAYMENT MATURITY');
499:
500:

Line 509: FROM AP_Payment_History_All APH

505: APH.Pmt_To_Base_XRate
506: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
507: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
508: ap_accounting_pay_pkg.g_mat_to_base_xrate
509: FROM AP_Payment_History_All APH
510: WHERE APH.Payment_History_ID = l_mat_history_id;
511:
512: END IF;
513:

Line 589: --FROM AP_Payment_History_All APH,

585:
586: -- commenting below for bug10183934
587: --SELECT count(*)
588: --INTO l_upg_pmt_hist
589: --FROM AP_Payment_History_All APH,
590: -- AP_System_Parameters_ALL ASP,
591: -- XLA_AE_Headers XAH
592: --WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
593: --AND APH.Historical_Flag = 'Y'

Line 686: -- FROM AP_Payment_History_All APH,

682: --INTO l_upg_inv_pmts
683: --FROM AP_Invoice_Payments_All AIP
684: --WHERE Invoice_ID = l_inv_pay_rec.invoice_id
685: --AND EXISTS (SELECT 'Upg Payment'
686: -- FROM AP_Payment_History_All APH,
687: -- AP_System_Parameters_All ASP,
688: -- XLA_AE_Headers XAH
689: -- WHERE APH.Check_ID = AIP.Check_ID
690: -- AND APH.Historical_Flag = 'Y'

Line 775: FROM ap_payment_history_all aph,

771: INTO l_exec_final_pay
772: FROM dual
773: WHERE EXISTS(
774: SELECT 'Unreversed clearing txns with different xrates'
775: FROM ap_payment_history_all aph,
776: ap_invoice_payments_all aip
777: WHERE aip.invoice_id = l_inv_pay_rec.invoice_id
778: AND aip.check_id = aph.check_id
779: AND aph.transaction_type = 'PAYMENT CLEARING'

Line 782: FROM ap_payment_history_all aph_sub,

778: AND aip.check_id = aph.check_id
779: AND aph.transaction_type = 'PAYMENT CLEARING'
780: AND EXISTS(
781: SELECT 'Unreversed clearing txn with different xrate'
782: FROM ap_payment_history_all aph_sub,
783: ap_invoice_payments_all aip_sub
784: WHERE aip_sub.invoice_id = aip.invoice_id
785: AND aip_sub.check_id = aph_sub.check_id
786: AND aph_sub.check_id <> aph.check_id

Line 793: FROM ap_payment_history_all aph_rev

789: OR NVL(aph_sub.pmt_to_base_xrate, -1) <> NVL(aph.pmt_to_base_xrate, -1))
790: AND aph_sub.rev_pmt_hist_id IS NULL
791: AND NOT EXISTS(
792: SELECT 'reversal txn'
793: FROM ap_payment_history_all aph_rev
794: WHERE aph_rev.REV_PMT_HIST_ID = aph_sub.payment_history_id)));
795: EXCEPTION
796: WHEN OTHERS THEN
797: l_exec_final_pay := 'Y';

Line 1681: l_txn_curr_code AP_PAYMENT_HISTORY_ALL.PMT_CURRENCY_CODE%TYPE; --11698822

1677: l_do_round NUMBER; --7454170 contains payment_history_id
1678: l_tech_round_amt NUMBER; --9414219
1679: l_tech_disc_rnd_amt NUMBER; --10170636
1680: l_final_payment BOOLEAN := FALSE; -- bug 9495429
1681: l_txn_curr_code AP_PAYMENT_HISTORY_ALL.PMT_CURRENCY_CODE%TYPE; --11698822
1682: --Bug 13081266
1683: l_sum_disc_dist_amount NUMBER;
1684: l_sum_disc_bank_curr_amount NUMBER;
1685: l_sum_disc_dist_base_amount NUMBER;

Line 1711: AP_Payment_History_All APH,

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'
1715: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 1784: FROM AP_Payment_History_All APH

1780: IF (P_XLA_Event_Rec.Event_Type_Code IN ('PAYMENT MATURITY ADJUSTED')) THEN
1781:
1782: SELECT MAX(APH.Payment_History_ID)
1783: INTO l_pay_history_id
1784: FROM AP_Payment_History_All APH
1785: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
1786: AND APH.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED');
1787:
1788: SELECT APH.Pmt_To_Base_XRate_Type,

Line 1794: FROM AP_Payment_History_All APH

1790: APH.Pmt_To_Base_XRate
1791: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1792: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1793: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1794: FROM AP_Payment_History_All APH
1795: WHERE APH.Payment_History_ID = l_pay_history_id;
1796:
1797: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1798: l_log_msg := 'Payment_History_ID for payment = '|| l_pay_history_id;

Line 1824: FROM AP_Payment_History_All APH

1820: ELSIF (P_XLA_Event_Rec.Event_Type_Code IN ('PAYMENT CLEARING ADJUSTED')) THEN
1821:
1822: SELECT MAX(APH.Payment_History_ID)
1823: INTO l_pay_history_id
1824: FROM AP_Payment_History_All APH
1825: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
1826: AND APH.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED');
1827:
1828: SELECT APH.Pmt_To_Base_XRate_Type,

Line 1834: FROM AP_Payment_History_All APH

1830: APH.Pmt_To_Base_XRate
1831: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1832: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1833: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1834: FROM AP_Payment_History_All APH
1835: WHERE APH.Payment_History_ID = l_pay_history_id;
1836:
1837: SELECT MAX(APH.Payment_History_ID)
1838: INTO l_mat_history_id

Line 1839: FROM AP_Payment_History_All APH

1835: WHERE APH.Payment_History_ID = l_pay_history_id;
1836:
1837: SELECT MAX(APH.Payment_History_ID)
1838: INTO l_mat_history_id
1839: FROM AP_Payment_History_All APH
1840: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
1841: AND APH.Transaction_Type IN ('PAYMENT MATURITY');
1842:
1843:

Line 1852: FROM AP_Payment_History_All APH

1848: APH.Pmt_To_Base_XRate
1849: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
1850: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
1851: ap_accounting_pay_pkg.g_mat_to_base_xrate
1852: FROM AP_Payment_History_All APH
1853: WHERE APH.Payment_History_ID = l_mat_history_id;
1854:
1855: END IF;
1856:

Line 2202: FROM ap_payment_history_all aph1,

2198: -- Calling rounding only once for all payment adjsument events
2199: -- for each invoice payment level.
2200:
2201: SELECT max(aph2.payment_history_id) into l_do_round
2202: FROM ap_payment_history_all aph1,
2203: ap_payment_history_all aph2
2204: WHERE aph1.payment_history_id = l_pay_hist_rec.payment_history_id
2205: AND aph2.check_id = aph1.check_id
2206: AND aph2.posted_flag <> 'Y'

Line 2203: ap_payment_history_all aph2

2199: -- for each invoice payment level.
2200:
2201: SELECT max(aph2.payment_history_id) into l_do_round
2202: FROM ap_payment_history_all aph1,
2203: ap_payment_history_all aph2
2204: WHERE aph1.payment_history_id = l_pay_hist_rec.payment_history_id
2205: AND aph2.check_id = aph1.check_id
2206: AND aph2.posted_flag <> 'Y'
2207: AND aph1.posted_flag <> 'Y'

Line 2227: AP_Payment_History_All APH

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
2231: AND APHD.Invoice_Distribution_ID = AID.Invoice_Distribution_ID

Line 3301: FROM ap_payment_history_all aph,

3297: WHERE aid.invoice_id = p_inv_rec.invoice_id
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

Line 3308: FROM ap_payment_history_all aph_evt

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 =
3307: (SELECT transaction_type
3308: FROM ap_payment_history_all aph_evt
3309: WHERE aph_evt.payment_history_id = p_pay_hist_rec.payment_history_id)
3310: AND aph.posted_flag = 'S');
3311:
3312: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4668: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;

4664: -- Logging Infra:
4665: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Reverse';
4666: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4667:
4668: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
4669: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
4670: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
4671: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
4672: l_reversed_in_R12 VARCHAR2(1) := 'N';

Line 4669: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;

4665: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Reverse';
4666: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4667:
4668: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
4669: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
4670: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
4671: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
4672: l_reversed_in_R12 VARCHAR2(1) := 'N';
4673: l_upg_batch_id XLA_AE_HEADERS.UPG_BATCH_ID%TYPE;

Line 4670: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;

4666: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4667:
4668: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
4669: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
4670: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
4671: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
4672: l_reversed_in_R12 VARCHAR2(1) := 'N';
4673: l_upg_batch_id XLA_AE_HEADERS.UPG_BATCH_ID%TYPE;
4674:

Line 4671: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;

4667:
4668: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
4669: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
4670: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
4671: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
4672: l_reversed_in_R12 VARCHAR2(1) := 'N';
4673: l_upg_batch_id XLA_AE_HEADERS.UPG_BATCH_ID%TYPE;
4674:
4675:

Line 4855: AP_Payment_History_All APH,

4851: SYSDATE,
4852: FND_GLOBAL.Conc_Request_ID,
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

Line 4941: AP_Payment_History_All APH -- 6804379

4937: NULL,
4938: SYSDATE,
4939: FND_GLOBAL.Conc_Request_ID
4940: FROM AP_Payment_Hist_Dists APHD,
4941: AP_Payment_History_All APH -- 6804379
4942: WHERE APH.Check_ID = p_xla_event_rec.Source_ID_Int_1 -- Bug 6856694
4943: AND NVL(APH.Related_Event_ID, APH.Accounting_Event_ID) = p_related_event_id
4944: AND APHD.Payment_History_ID = APH.Payment_History_ID
4945: AND NVL(APHD.Reversal_Flag,'N') <> 'Y'

Line 5030: AP_Payment_History_All APH

5026: NULL,
5027: SYSDATE,
5028: FND_GLOBAL.Conc_Request_ID
5029: FROM AP_Payment_Hist_Dists APHD,
5030: AP_Payment_History_All APH
5031: WHERE APHD.Invoice_Distribution_ID = p_invoice_dist_id
5032: AND APHD.Payment_History_ID = APH.Payment_History_ID
5033: AND APH.Check_ID = p_xla_event_rec.source_id_int_1 -- Bug 6887295
5034: AND APH.Related_Event_ID = p_pay_hist_rec.related_event_id

Line 5069: FROM ap_payment_history_all APH,

5065: SELECT Payment_History_ID,
5066: Accounting_Event_ID,
5067: NVL(Historical_Flag, 'N') Historical_Flag,
5068: XAH.upg_batch_id
5069: FROM ap_payment_history_all APH,
5070: xla_ae_headers XAH,
5071: ap_system_parameters_all ASP
5072: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
5073: -- AND APH.rev_pmt_hist_id is null bug9448974

Line 5109: FROM ap_payment_history_all aph,

5105: INTO l_reversed_in_R12
5106: FROM dual
5107: WHERE EXISTS
5108: (SELECT 'reversed in R12'
5109: FROM ap_payment_history_all aph,
5110: xla_ae_headers xah,
5111: ap_system_parameters_all asp
5112: WHERE aph.rev_pmt_hist_id = aph_events.payment_history_id
5113: AND xah.application_id = 200

Line 5179: FROM ap_payment_history_all APH,

5175: INTO l_payment_history_id,
5176: l_accounting_event_id,
5177: l_historical_flag,
5178: l_upg_batch_id
5179: FROM ap_payment_history_all APH,
5180: xla_ae_headers XAH,
5181: ap_system_parameters_all ASP
5182: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
5183: AND APH.Transaction_Type = l_transaction_type

Line 5423: ap_payment_history_all aph

5419: WHERE application_id = 200
5420: AND ae_header_id IN
5421: (SELECT ae_header_id
5422: FROM xla_ae_headers aeh,
5423: ap_payment_history_all aph
5424: WHERE aeh.event_id = aph.accounting_event_id
5425: AND aph.accounting_event_id = p_accounting_event_id
5426: AND aph.check_id = p_xla_event_rec.source_id_int_1
5427: AND aph.historical_flag = 'Y'

Line 5671: AP_Payment_History_All APH,

5667: FROM AP_Checks_All AC,
5668: AP_System_Parameters_All ASP,
5669: XLA_Transaction_Entities_Upg XTE,
5670: XLA_Events XLE,
5671: AP_Payment_History_All APH,
5672: XLA_AE_Headers AEH,
5673: XLA_AE_Lines AEL,
5674: AP_Inv_Dists_Source AID1,
5675: AP_Invoices_All AI,

Line 5789: AP_Payment_History_All APH,

5785: FROM AP_Checks_All AC,
5786: AP_System_Parameters_All ASP,
5787: XLA_Transaction_Entities_Upg XTE,
5788: XLA_Events XLE,
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,

Line 6104: AP_Payment_History_All APH,

6100: FROM AP_Checks_All AC,
6101: AP_System_Parameters_All ASP,
6102: XLA_Transaction_Entities_Upg XTE,
6103: XLA_Events XLE,
6104: AP_Payment_History_All APH,
6105: XLA_AE_Headers AEH,
6106: XLA_AE_Lines AEL,
6107: AP_Inv_Dists_Source AID1,
6108: AP_Invoices_All AI,

Line 6202: AP_Payment_History_All APH,

6198: FROM AP_Checks_All AC,
6199: AP_System_Parameters_All ASP,
6200: XLA_Transaction_Entities_Upg XTE,
6201: XLA_Events XLE,
6202: AP_Payment_History_All APH,
6203: XLA_AE_Headers AEH,
6204: XLA_AE_Lines AEL,
6205: AP_Payment_Hist_Dists APHD,
6206: ap_mc_invoice_dists AID_MC,

Line 6289: ap_payment_history_all aph,

6285: NVL(xdl.unrounded_accounted_cr,0) - NVL(xdl.unrounded_accounted_dr,0) xdl_acctd_amt,
6286: aphd.invoice_dist_amount ,
6287: NVL(xdl.unrounded_entered_cr,0) - NVL(xdl.unrounded_entered_dr,0) xdl_ent_amt
6288: FROM ap_payment_hist_dists aphd,
6289: ap_payment_history_all aph,
6290: xla_ae_headers xh,
6291: ap_system_parameters_all asp,
6292: xla_distribution_links xdl
6293: WHERE aphd.payment_history_id = aph.payment_history_id