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

Line 93: AP_Invoice_Distributions_All AID

89: /* Get the prepayment app dists amount that has already been accounted */
90: SELECT SUM(-1 * APAD.Amount)
91: INTO l_prepay_acctg_amt
92: FROM AP_Prepay_App_Dists APAD,
93: AP_Invoice_Distributions_All AID
94: WHERE APAD.Prepay_App_Distribution_ID = AID.Invoice_Distribution_ID
95: AND AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id;
96:
97:

Line 100: FROM AP_Invoice_Distributions_All AID

96:
97:
98: SELECT AID.Amount
99: INTO l_prepay_amt
100: FROM AP_Invoice_Distributions_All AID
101: WHERE AID.Invoice_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id;
102:
103:
104: -- Check for final application rounding only if this prepayment has been

Line 303: FROM AP_Invoice_Distributions_All AID,

299: AID.Base_Amount,
300: AID.Invoice_Id,
301: AID.accounting_event_id,
302: AID.historical_flag
303: FROM AP_Invoice_Distributions_All AID,
304: Financials_System_Params_All FSP
305: WHERE AID.Invoice_ID = p_invoice_id
306: AND AID.Line_Type_Lookup_Code NOT IN ('PREPAY', 'AWT', 'ERV', 'TERV')
307: AND AID.Prepay_Distribution_ID IS NULL

Line 334: FROM ap_invoice_distributions_all aid,

330: -- event is an adjustment event with a net balance 0
331: -- under no liability posting method.
332: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
333: SELECT SUM(amount), count(1)
334: FROM ap_invoice_distributions_all aid,
335: xla_events evnt,
336: ap_system_parameters_all asp
337: WHERE aid.accounting_event_id = p_acct_event_id
338: AND aid.accounting_event_id = evnt.event_id

Line 354: l_erv_base_amount AP_INVOICE_DISTRIBUTIONS_ALL.base_amount%type := 0;

350: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
351: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
352: l_max_pay_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
353: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
354: l_erv_base_amount AP_INVOICE_DISTRIBUTIONS_ALL.base_amount%type := 0;
355:
356: -- Logging Infra:
357: l_procedure_name CONSTANT VARCHAR2(30) := 'Final_Pay';
358: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 540: FROM ap_invoice_distributions_all AID

536: BEGIN
537:
538: SELECT NVL(base_amount, 0)
539: INTO l_erv_base_amount
540: FROM ap_invoice_distributions_all AID
541: WHERE AID.line_type_lookup_code in ('ERV', 'TERV')
542: AND AID.invoice_id = l_inv_dist_rec.invoice_id
543: AND AID.related_id = l_inv_dist_rec.invoice_distribution_id;
544: EXCEPTION

Line 782: FROM AP_Invoice_Distributions_All AID

778: WHERE APHD1.Accounting_Event_ID = p_xla_event_rec.event_id
779: AND APHD1.Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id
780: AND APHD1.Invoice_Distribution_ID IN
781: (SELECT AID.Invoice_Distribution_ID
782: FROM AP_Invoice_Distributions_All AID
783: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)
784: AND ABS(APHD1.Amount) =
785: (SELECT MAX(ABS(APHD2.Amount))
786: FROM AP_Payment_Hist_Dists APHD2

Line 791: FROM AP_Invoice_Distributions_All AID

787: WHERE APHD2.Accounting_Event_ID = p_xla_event_rec.event_id
788: AND APHD2.Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id
789: AND APHD2.Invoice_Distribution_ID IN
790: (SELECT AID.Invoice_Distribution_ID
791: FROM AP_Invoice_Distributions_All AID
792: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)))
793: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id
794: AND APHD.Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id
795: AND Rownum = 1;

Line 839: FROM AP_Invoice_Distributions_All AID

835: AND APHD.Invoice_Payment_ID = p_inv_pay_rec.Invoice_Payment_ID
836: AND APHD.Payment_History_ID = APH.Payment_History_ID
837: AND APHD.Invoice_Distribution_ID IN
838: (SELECT AID.Invoice_Distribution_ID
839: FROM AP_Invoice_Distributions_All AID
840: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
841:
842:
843: /*Bug6600117 used below query to fetch the sum(amount) and sum(base_amount)

Line 860: FROM AP_Invoice_Distributions_All AID

856: APHD.PAYMENT_HISTORY_ID =APH.PAYMENT_HISTORY_ID
857: ANd APHD.INVOICE_PAYMENT_ID =p_inv_pay_rec.Invoice_Payment_ID --6614295
858: AND APHD.Invoice_Distribution_ID IN
859: (SELECT AID.Invoice_Distribution_ID
860: FROM AP_Invoice_Distributions_All AID
861: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
862:
863: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
864: l_log_msg := 'l_inv_rate_sum_full_amt ' || l_inv_rate_sum_full_amt;

Line 968: in ap_invoice_distributions_all to balance them in respect to the header base amount.

964: /* If the exchange rates between the invoice and payment are same then the base
965: amounts and rounding between the invoice and payment should be same */
966: /*Bug6600117
967: The fractional rounding amount is added to the maximun distribution amount
968: in ap_invoice_distributions_all to balance them in respect to the header base amount.
969: Same is not done while calculating invoice_dist_Base_Amount in AP_Payment_Hist_Dists
970: table.This is giving rise to the unbalance accounting entries in accounting journal*/
971:
972: IF (p_pay_hist_rec.pmt_to_base_xrate =

Line 1330: FROM AP_Invoice_Distributions_All AID

1326: FROM AP_Payment_Hist_Dists APHD1
1327: WHERE APHD1.Accounting_Event_ID = p_xla_event_rec.event_id
1328: AND APHD1.Invoice_Distribution_ID IN
1329: (SELECT AID.Invoice_Distribution_ID
1330: FROM AP_Invoice_Distributions_All AID
1331: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)
1332: AND ABS(APHD1.Amount) =
1333: (SELECT MAX(ABS(APHD2.Amount))
1334: FROM AP_Payment_Hist_Dists APHD2

Line 1338: FROM AP_Invoice_Distributions_All AID

1334: FROM AP_Payment_Hist_Dists APHD2
1335: WHERE APHD2.Accounting_Event_ID = p_xla_event_rec.event_id
1336: AND APHD2.Invoice_Distribution_ID IN
1337: (SELECT AID.Invoice_Distribution_ID
1338: FROM AP_Invoice_Distributions_All AID
1339: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)))
1340: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id
1341: AND Rownum = 1;
1342:

Line 1356: FROM AP_Invoice_Distributions_All AID

1352: AND APHD.Payment_History_ID = APH.Payment_History_ID
1353: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')
1354: AND APHD.Invoice_Distribution_ID IN
1355: (SELECT AID.Invoice_Distribution_ID
1356: FROM AP_Invoice_Distributions_All AID
1357: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
1358:
1359:
1360: -- Get the paid base amounts for the payment maturity event

Line 1374: FROM AP_Invoice_Distributions_All AID

1370: AND APHD.Payment_History_ID = APH.Payment_History_ID
1371: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')
1372: AND APHD.Invoice_Distribution_ID IN
1373: (SELECT AID.Invoice_Distribution_ID
1374: FROM AP_Invoice_Distributions_All AID
1375: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
1376:
1377:
1378: -- Get the paid base amounts for the payment clearing event

Line 1397: FROM AP_Invoice_Distributions_All AID

1393: AND APHD.Payment_History_ID = APH.Payment_History_ID
1394: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')
1395: AND APHD.Invoice_Distribution_ID IN
1396: (SELECT AID.Invoice_Distribution_ID
1397: FROM AP_Invoice_Distributions_All AID
1398: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
1399:
1400: /* If there is any difference between the paid and maturity base amounts between
1401: this event and the prior event then we will insert the appropriate rounding

Line 1935: FROM AP_Invoice_Distributions_All AID

1931: WHERE APH.Related_Event_ID = p_pay_hist_rec.Related_Event_ID
1932: AND APHD.Payment_History_ID = APH.Payment_History_ID
1933: AND Invoice_Distribution_ID IN
1934: (SELECT AID.Invoice_Distribution_ID
1935: FROM AP_Invoice_Distributions_All AID
1936: WHERE AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id)
1937: AND Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT', 'TOTAL PAYMENT ROUNDING',
1938: 'FINAL PAYMENT ROUNDING');
1939:

Line 1950: FROM AP_Invoice_Distributions_All AID

1946: WHERE APH.Related_Event_ID = p_clr_hist_rec.related_event_id
1947: AND APHD.Payment_History_ID = APH.Payment_History_ID
1948: AND Invoice_Distribution_ID IN
1949: (SELECT AID.Invoice_Distribution_ID
1950: FROM AP_Invoice_Distributions_All AID
1951: WHERE AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id)
1952: AND Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT', 'TOTAL CLEARING ROUNDING',
1953: 'FINAL PAYMENT ROUNDING');
1954:

Line 1966: FROM AP_Invoice_Distributions_All AID

1962: l_sum_prepay_clr_rate_amt
1963: FROM AP_Prepay_App_Dists
1964: WHERE Prepay_App_Distribution_ID IN
1965: (SELECT AID.Invoice_Distribution_ID
1966: FROM AP_Invoice_Distributions_All AID
1967: WHERE AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id);
1968:
1969:
1970: SELECT AID.Base_Amount

Line 1972: FROM AP_Invoice_Distributions_All AID

1968:
1969:
1970: SELECT AID.Base_Amount
1971: INTO l_sum_pay_base_amt
1972: FROM AP_Invoice_Distributions_All AID
1973: WHERE AID.Invoice_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id;
1974:
1975:
1976: l_diff_prepay_rate_amt := l_sum_pay_base_amt + l_sum_prepay_rate_amt;