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

295: -- and sum of the distributions in the invoice adjustment event is 0
296:
297: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
298: SELECT SUM(amount), count(1)
299: FROM ap_invoice_distributions_all aid,
300: xla_events evnt,
301: ap_system_parameters_all asp
302: WHERE aid.accounting_event_id = p_acct_event_id
303: AND aid.accounting_event_id = evnt.event_id

Line 628: FROM ap_invoice_distributions_all aid

624: -- ever the query is modified pls do the same in reamining 2 places.
625: SELECT SUM(decode(aid.prepay_tax_parent_id, NULL, nvl(aid.amount, 0), 0)),
626: SUM(decode(aid.line_type_lookup_code, 'AWT', 0, nvl(aid.amount, 0)))
627: INTO G_Total_Dist_Amount , G_Proration_Divisor
628: FROM ap_invoice_distributions_all aid
629: WHERE aid.invoice_id = l_inv_pay_rec.invoice_id
630: AND aid.line_type_lookup_code <> 'PREPAY'
631: AND aid.prepay_distribution_id IS NULL
632: AND (aid.awt_invoice_payment_id IS NULL OR

Line 988: FROM ap_invoice_distributions_all aid

984: -- Perfomance Fix 7308385
985: SELECT SUM(decode(aid.prepay_tax_parent_id, NULL, nvl(aid.amount, 0), 0)),
986: SUM(decode(aid.line_type_lookup_code, 'AWT', 0, nvl(aid.amount, 0)))
987: INTO G_Total_Dist_Amount , G_Proration_Divisor
988: FROM ap_invoice_distributions_all aid
989: WHERE aid.invoice_id = l_inv_pay_rec.invoice_id
990: AND aid.line_type_lookup_code <> 'PREPAY'
991: AND aid.prepay_distribution_id IS NULL
992: AND (aid.awt_invoice_payment_id IS NULL OR

Line 1317: FROM AP_Invoice_Distributions_All AID,

1313: AID.Amount_Variance,
1314: AID.Base_Amount_Variance,
1315: AID.historical_flag, -- bug fix 6674279
1316: AID.accounting_event_id -- bug fix 6674279
1317: FROM AP_Invoice_Distributions_All AID,
1318: AP_Payment_History_All APH,
1319: AP_Payment_Hist_Dists APHD
1320: WHERE AID.Invoice_ID = P_Invoice_ID
1321: AND NVL(AID.Reversal_Flag,'N') <> 'Y'

Line 1508: FROM AP_Invoice_Distributions_All AID

1504:
1505:
1506: SELECT AID.Invoice_ID
1507: INTO l_invoice_id
1508: FROM AP_Invoice_Distributions_All AID
1509: WHERE AID.Accounting_Event_ID = l_pay_hist_rec.invoice_adjustment_event_id
1510: AND Rownum = 1;
1511:
1512: OPEN Invoice_Header(l_invoice_id);

Line 1544: FROM ap_invoice_distributions_all aid

1540: -- Perfomance Fix 7308385
1541: SELECT SUM(decode(aid.prepay_tax_parent_id, NULL, nvl(aid.amount, 0), 0)),
1542: SUM(decode(aid.line_type_lookup_code, 'AWT', 0, nvl(aid.amount, 0)))
1543: INTO G_Total_Dist_Amount , G_Proration_Divisor
1544: FROM ap_invoice_distributions_all aid
1545: WHERE aid.invoice_id = l_inv_pay_rec.invoice_id
1546: AND aid.line_type_lookup_code <> 'PREPAY'
1547: AND aid.prepay_distribution_id IS NULL
1548: AND (aid.awt_invoice_payment_id IS NULL OR

Line 1654: FROM AP_Invoice_Distributions_All AID

1650:
1651:
1652: SELECT SUM(AID.Amount)
1653: INTO l_inv_adj_amount
1654: FROM AP_Invoice_Distributions_All AID
1655: WHERE AID.Accounting_Event_ID = l_pay_hist_rec.invoice_adjustment_event_id;
1656:
1657:
1658: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1736: FROM ap_invoice_distributions_all d

1732: AND aph2.posted_flag <> 'Y'
1733: AND aph1.posted_flag <> 'Y'
1734: AND aph1.transaction_type = aph2.transaction_type
1735: AND l_invoice_id = (SELECT invoice_id
1736: FROM ap_invoice_distributions_all d
1737: WHERE d.accounting_event_id = aph2.invoice_adjustment_event_id
1738: AND rownum = 1);
1739:
1740: IF ( l_do_round = l_pay_hist_rec.payment_history_id ) Then

Line 1752: AP_Invoice_Distributions_All AID,

1748: l_sum_disc_amount,
1749: l_sum_error_amount,
1750: l_sum_charge_amount
1751: FROM AP_Payment_Hist_Dists APHD,
1752: AP_Invoice_Distributions_All AID,
1753: AP_Payment_History_All APH
1754: WHERE APH.Related_Event_ID = l_pay_hist_rec.related_event_id
1755: AND APHD.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1756: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 2064: FROM AP_Invoice_Distributions_All AID

2060: -- Selecting the distribution amount including the AWT distributions for
2061: -- prorating the AWT distributions.
2062: SELECT SUM(NVL(AID.Amount,0))
2063: INTO l_total_dist_amount
2064: FROM AP_Invoice_Distributions_All AID
2065: WHERE AID.Invoice_ID = p_inv_pay_rec.invoice_id
2066: AND AID.Line_Type_Lookup_Code <> 'PREPAY'
2067: AND AID.Prepay_Distribution_ID IS NULL
2068: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5

Line 2106: FROM ap_invoice_distributions_all AID

2102: -- line_type not in 'PREPAY' and 'AWT'
2103: /* Performance Fix 7308385 starts
2104: SELECT SUM(AID.amount)
2105: INTO l_proration_divisor
2106: FROM ap_invoice_distributions_all AID
2107: WHERE AID.invoice_id = p_inv_rec.invoice_id
2108: AND AID.Line_Type_Lookup_Code NOT IN ('PREPAY', 'AWT')
2109: AND AID.Prepay_Distribution_ID IS NULL
2110: AND NOT EXISTS (SELECT 1

Line 3001: FROM AP_Invoice_Distributions_All AID

2997: p_inv_rec.payment_cross_rate_date,
2998: 'EMU FIXED',
2999: SUM(NVL(AID.Amount,0)))
3000: INTO l_invoice_amount
3001: FROM AP_Invoice_Distributions_All AID
3002: WHERE AID.Invoice_ID = p_inv_pay_rec.Invoice_ID
3003: AND AID.Line_Type_Lookup_Code NOT IN ('PREPAY', 'AWT')
3004: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
3005: AND AID.Prepay_Distribution_ID IS NULL

Line 3885: AP_Invoice_Distributions_All AID

3881: SYSDATE,
3882: FND_GLOBAL.Conc_Request_ID
3883: FROM AP_Payment_Hist_Dists APHD,
3884: AP_Invoice_Payments_All AIP,
3885: AP_Invoice_Distributions_All AID
3886: WHERE AIP.Invoice_Payment_ID = p_reversal_inv_pmt_id
3887: AND AIP.Accounting_Event_ID = APHD.Accounting_Event_ID
3888: AND AIP.Invoice_ID = AID.Invoice_ID
3889: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID;

Line 3975: AP_Invoice_Distributions_All AID -- 6804379

3971: FND_GLOBAL.Conc_Request_ID
3972: FROM AP_Payment_Hist_Dists APHD,
3973: AP_Payment_History_All APH,
3974: AP_Invoice_Payments_All AIP,
3975: AP_Invoice_Distributions_All AID -- 6804379
3976: WHERE nvl(APH.Related_Event_ID, APH.Accounting_Event_ID) = p_related_event_id
3977: AND APHD.Payment_History_ID = APH.Payment_History_ID
3978: AND NVL(APHD.Reversal_Flag,'N') <> 'Y'
3979: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 4664: AP_Invoice_Distributions_All AID,

4660: XLA_AE_Headers AEH,
4661: XLA_AE_Lines AEL,
4662: AP_Inv_Dists_Source AID1,
4663: AP_Invoices_All AI,
4664: AP_Invoice_Distributions_All AID,
4665: AP_Payment_Hist_Dists APHD,
4666: xla_events aid_xe -- changed for bug#7293021
4667: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
4668: AND AC.Org_ID = ASP.Org_ID

Line 4742: AP_Invoice_Distributions_All AID,

4738: AP_Payment_History_All APH,
4739: XLA_AE_Headers AEH,
4740: XLA_AE_Lines AEL,
4741: AP_Payment_Hist_Dists APHD,
4742: AP_Invoice_Distributions_All AID,
4743: AP_Invoices_All AI,
4744: xla_events aid_xe -- changed for bug#7293021
4745: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
4746: AND AC.Org_ID = ASP.Org_ID