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

Line 776: from ap_invoice_distributions_all aid_awt,

772: select p_invoice_distribution_id from dual
773: union
774: -- awt distributions which are applied on the p_invoice_distribution_id
775: select distinct aid_awt.invoice_distribution_id
776: from ap_invoice_distributions_all aid_awt,
777: ap_invoice_distributions_all aid_item
778: where 1=1
779: and aid_item.invoice_distribution_id = p_invoice_distribution_id
780: and aid_item.line_type_lookup_code <> 'AWT'

Line 777: ap_invoice_distributions_all aid_item

773: union
774: -- awt distributions which are applied on the p_invoice_distribution_id
775: select distinct aid_awt.invoice_distribution_id
776: from ap_invoice_distributions_all aid_awt,
777: ap_invoice_distributions_all aid_item
778: where 1=1
779: and aid_item.invoice_distribution_id = p_invoice_distribution_id
780: and aid_item.line_type_lookup_code <> 'AWT'
781: and aid_awt.invoice_id = aid_item.invoice_id

Line 821: from ap_invoice_distributions_all aid_awt,

817: select p_invoice_distribution_id from dual
818: union
819: -- awt distributions which are applied on p_invoice_distribution_id
820: select distinct aid_awt.invoice_distribution_id
821: from ap_invoice_distributions_all aid_awt,
822: ap_invoice_distributions_all aid_item
823: where 1=1
824: and aid_item.invoice_distribution_id = p_invoice_distribution_id
825: and aid_item.line_type_lookup_code <> 'AWT'

Line 822: ap_invoice_distributions_all aid_item

818: union
819: -- awt distributions which are applied on p_invoice_distribution_id
820: select distinct aid_awt.invoice_distribution_id
821: from ap_invoice_distributions_all aid_awt,
822: ap_invoice_distributions_all aid_item
823: where 1=1
824: and aid_item.invoice_distribution_id = p_invoice_distribution_id
825: and aid_item.line_type_lookup_code <> 'AWT'
826: and aid_awt.invoice_id = aid_item.invoice_id

Line 865: from ap_invoice_distributions_all aid_awt,

861: select p_invoice_distribution_id from dual
862: union
863: -- awt distributions which are applied on p_invoice_distribution_id
864: select distinct aid_awt.invoice_distribution_id
865: from ap_invoice_distributions_all aid_awt,
866: ap_invoice_distributions_all aid_item
867: where 1=1
868: and aid_item.invoice_distribution_id = p_invoice_distribution_id
869: and aid_item.line_type_lookup_code <> 'AWT'

Line 866: ap_invoice_distributions_all aid_item

862: union
863: -- awt distributions which are applied on p_invoice_distribution_id
864: select distinct aid_awt.invoice_distribution_id
865: from ap_invoice_distributions_all aid_awt,
866: ap_invoice_distributions_all aid_item
867: where 1=1
868: and aid_item.invoice_distribution_id = p_invoice_distribution_id
869: and aid_item.line_type_lookup_code <> 'AWT'
870: and aid_awt.invoice_id = aid_item.invoice_id

Line 955: FROM ap_invoice_distributions_all aid_awt

951: (SELECT p_invoice_distribution_id
952: FROM dual
953: UNION
954: SELECT DISTINCT aid_awt.invoice_distribution_id
955: FROM ap_invoice_distributions_all aid_awt
956: , ap_invoice_distributions_all aid_item
957: WHERE 1 = 1
958: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
959: AND aid_item.line_type_lookup_code <> 'AWT'

Line 956: , ap_invoice_distributions_all aid_item

952: FROM dual
953: UNION
954: SELECT DISTINCT aid_awt.invoice_distribution_id
955: FROM ap_invoice_distributions_all aid_awt
956: , ap_invoice_distributions_all aid_item
957: WHERE 1 = 1
958: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
959: AND aid_item.line_type_lookup_code <> 'AWT'
960: AND aid_awt.invoice_id = aid_item.invoice_id

Line 993: FROM ap_invoice_distributions_all aid_awt

989: (SELECT p_invoice_distribution_id
990: FROM dual
991: UNION
992: SELECT DISTINCT aid_awt.invoice_distribution_id
993: FROM ap_invoice_distributions_all aid_awt
994: , ap_invoice_distributions_all aid_item
995: WHERE 1 = 1
996: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
997: AND aid_item.line_type_lookup_code <> 'AWT'

Line 994: , ap_invoice_distributions_all aid_item

990: FROM dual
991: UNION
992: SELECT DISTINCT aid_awt.invoice_distribution_id
993: FROM ap_invoice_distributions_all aid_awt
994: , ap_invoice_distributions_all aid_item
995: WHERE 1 = 1
996: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
997: AND aid_item.line_type_lookup_code <> 'AWT'
998: AND aid_awt.invoice_id = aid_item.invoice_id

Line 1031: FROM ap_invoice_distributions_all aid_awt

1027: (SELECT p_invoice_distribution_id
1028: FROM dual
1029: UNION
1030: SELECT DISTINCT aid_awt.invoice_distribution_id
1031: FROM ap_invoice_distributions_all aid_awt
1032: , ap_invoice_distributions_all aid_item
1033: WHERE 1 = 1
1034: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
1035: AND aid_item.line_type_lookup_code <> 'AWT'

Line 1032: , ap_invoice_distributions_all aid_item

1028: FROM dual
1029: UNION
1030: SELECT DISTINCT aid_awt.invoice_distribution_id
1031: FROM ap_invoice_distributions_all aid_awt
1032: , ap_invoice_distributions_all aid_item
1033: WHERE 1 = 1
1034: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
1035: AND aid_item.line_type_lookup_code <> 'AWT'
1036: AND aid_awt.invoice_id = aid_item.invoice_id

Line 1098: AP_Invoice_Distributions_All AID

1094:
1095: SELECT SUM(APAD.Amount)
1096: INTO l_prepay_sum
1097: FROM AP_Prepay_App_Dists APAD,
1098: AP_Invoice_Distributions_All AID
1099: WHERE APAD.Invoice_Distribution_ID in ( /*bug 8882706*/
1100: select p_invoice_distribution_id from dual
1101: union
1102: /* awt distributions which are applied on the p_invoice_distribution_id*/

Line 1104: from ap_invoice_distributions_all aid_awt,

1100: select p_invoice_distribution_id from dual
1101: union
1102: /* awt distributions which are applied on the p_invoice_distribution_id*/
1103: select distinct aid_awt.invoice_distribution_id
1104: from ap_invoice_distributions_all aid_awt,
1105: ap_invoice_distributions_all aid_item
1106: where 1=1
1107: and aid_item.invoice_distribution_id = p_invoice_distribution_id
1108: and aid_item.line_type_lookup_code <> 'AWT'

Line 1105: ap_invoice_distributions_all aid_item

1101: union
1102: /* awt distributions which are applied on the p_invoice_distribution_id*/
1103: select distinct aid_awt.invoice_distribution_id
1104: from ap_invoice_distributions_all aid_awt,
1105: ap_invoice_distributions_all aid_item
1106: where 1=1
1107: and aid_item.invoice_distribution_id = p_invoice_distribution_id
1108: and aid_item.line_type_lookup_code <> 'AWT'
1109: and aid_awt.invoice_id = aid_item.invoice_id

Line 1155: FROM ap_invoice_distributions_all aid_awt

1151: WHERE APAD.Invoice_Distribution_ID IN
1152: ( SELECT p_invoice_distribution_id FROM dual
1153: UNION
1154: SELECT DISTINCT aid_awt.invoice_distribution_id
1155: FROM ap_invoice_distributions_all aid_awt
1156: , ap_invoice_distributions_all aid_item
1157: WHERE 1 = 1
1158: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
1159: AND aid_item.line_type_lookup_code <> 'AWT'

Line 1156: , ap_invoice_distributions_all aid_item

1152: ( SELECT p_invoice_distribution_id FROM dual
1153: UNION
1154: SELECT DISTINCT aid_awt.invoice_distribution_id
1155: FROM ap_invoice_distributions_all aid_awt
1156: , ap_invoice_distributions_all aid_item
1157: WHERE 1 = 1
1158: AND aid_item.invoice_distribution_id = p_invoice_distribution_id
1159: AND aid_item.line_type_lookup_code <> 'AWT'
1160: AND aid_awt.invoice_id = aid_item.invoice_id

Line 1264: AP_Invoice_Distributions_All AID,

1260: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
1261: APHD.Amount)
1262: INTO l_paid_acctd_amt
1263: FROM AP_Payment_Hist_Dists APHD,
1264: AP_Invoice_Distributions_All AID,
1265: AP_Payment_History_All APH
1266: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1267: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
1268: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT') --bug 9265516, removed 'AWT'

Line 1295: AP_Invoice_Distributions_All AID,

1291: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
1292: APHD.Amount)
1293: INTO l_paid_acctd_amt
1294: FROM AP_Payment_Hist_Dists APHD,
1295: AP_Invoice_Distributions_All AID,
1296: AP_Payment_History_All APH
1297: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1298: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
1299: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT') --bug 9265516, removed 'AWT'

Line 1326: AP_Invoice_Distributions_All AID,

1322: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
1323: APHD.Amount)
1324: INTO l_paid_acctd_amt
1325: FROM AP_Payment_Hist_Dists APHD,
1326: AP_Invoice_Distributions_All AID,
1327: AP_Payment_History_All APH,
1328: AP_INVOICE_PAYMENTS_ALL AIP
1329: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1330: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 1357: AP_Invoice_Distributions_All AID,

1353: /* events, and checked only for reversal flag on the Prepay Application dists */
1354: SELECT SUM(APAD.Amount)
1355: INTO l_prepaid_acctd_amt
1356: FROM AP_Prepay_App_Dists APAD,
1357: AP_Invoice_Distributions_All AID,
1358: AP_PREPAY_HISTORY_ALL APPH
1359: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1360: AND AID.Invoice_Distribution_ID = APAD.Invoice_Distribution_ID
1361: AND APAD.prepay_history_id = APPH.PREPAY_HISTORY_ID

Line 1365: FROM ap_invoice_distributions_all aidp

1361: AND APAD.prepay_history_id = APPH.PREPAY_HISTORY_ID
1362: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
1363: 'PREPAY APPL NONREC TAX') --bug 9265516, removed 'AWT'
1364: AND NOT EXISTS( SELECT 'reversed prepay application'
1365: FROM ap_invoice_distributions_all aidp
1366: WHERE aidp.invoice_distribution_id = APAD.prepay_app_distribution_id
1367: AND aidp.reversal_flag = 'Y'); --bug 7614480, added not exists
1368:
1369:

Line 1397: FROM ap_invoice_distributions_all AID

1393: -- bug8613795
1394:
1395: SELECT NVL(SUM(AID.amount), 0)
1396: INTO l_inv_inc_prepay_tot
1397: FROM ap_invoice_distributions_all AID
1398: WHERE AID.invoice_id = p_inv_rec.invoice_id
1399: AND AID.line_type_lookup_code IN ('PREPAY','REC_TAX','NONREC_TAX')
1400: AND AID.prepay_distribution_id IS NOT NULL
1401: AND AID.invoice_includes_prepay_flag = 'Y';

Line 1424: FROM ap_invoice_distributions_all aid

1420:
1421: --Bug 9166188
1422:
1423: SELECT nvl(sum(amount),0) into l_total_awt
1424: FROM ap_invoice_distributions_all aid
1425: WHERE aid.invoice_id= p_inv_rec.invoice_id
1426: AND aid.line_type_lookup_code ='AWT';
1427:
1428: IF (p_inv_rec.invoice_currency_code <> p_inv_rec.payment_currency_code) THEN

Line 1586: FROM ap_invoice_distributions_all aid,

1582: PROCEDURE Prorate_Historical_Dists (P_calling_sequence VARCHAR2) IS
1583:
1584: CURSOR Aprvd_UnPrtd_His_Inv IS
1585: SELECT ai.invoice_id
1586: FROM ap_invoice_distributions_all aid,
1587: ap_invoices_all ai,
1588: xla_events_gt xe,
1589: xla_events xle,
1590: financials_system_params_all fsp

Line 1634: FROM ap_invoice_distributions_all aid

1630: -- be reset to the original value
1631: --
1632: CURSOR prepay_dist_encumbered(p_invoice_id NUMBER) IS
1633: SELECT aid.invoice_distribution_id
1634: FROM ap_invoice_distributions_all aid
1635: WHERE aid.invoice_id = p_invoice_id
1636: AND aid.line_type_lookup_code IN ('PREPAY','REC_TAX','NONREC_TAX')
1637: AND (aid.prepay_distribution_id IS NOT NULL OR
1638: aid.prepay_tax_parent_id IS NOT NULL)

Line 1703: UPDATE ap_invoice_distributions_all AID

1699: l_debug_info := 'Updating the encumbered flag on the invoice distributions '||
1700: 'table to ''N'' ';
1701: --bug12686836
1702: FORALL j IN l_prepay_dist_tab.FIRST..l_prepay_dist_tab.LAST
1703: UPDATE ap_invoice_distributions_all AID
1704: SET aid.encumbered_flag = 'N'
1705: WHERE aid.invoice_id = l_invoice_id
1706: AND aid.invoice_distribution_id = l_prepay_dist_tab(j);
1707:

Line 1725: UPDATE ap_invoice_distributions_all AID

1721: 'prepayment application and unapplication distributions';
1722:
1723: --bug12686836
1724: FORALL j IN l_prepay_dist_tab.FIRST..l_prepay_dist_tab.LAST
1725: UPDATE ap_invoice_distributions_all AID
1726: SET aid.encumbered_flag = 'Y'
1727: WHERE aid.invoice_id = l_invoice_id
1728: AND aid.invoice_distribution_id = l_prepay_dist_tab(j);
1729:

Line 1785: ,p_prepay_app_dist_id IN AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE

1781:
1782: FUNCTION Is_Final_Event
1783: (p_inv_rec IN r_invoices_info
1784: ,p_xla_event_rec IN r_xla_event_info
1785: ,p_prepay_app_dist_id IN AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE
1786: ,P_calling_sequence IN VARCHAR2
1787: ) RETURN BOOLEAN IS
1788:
1789: l_final_event BOOLEAN := FALSE;

Line 1791: l_max_prepay_app_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;

1787: ) RETURN BOOLEAN IS
1788:
1789: l_final_event BOOLEAN := FALSE;
1790: l_unacctg_events_exist VARCHAR2(1) := 'Y';
1791: l_max_prepay_app_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
1792: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;
1793:
1794: l_curr_calling_sequence VARCHAR2(2000);
1795:

Line 1842: FROM ap_invoice_distributions_all aid,

1838: AND aph_rev.rev_pmt_hist_id IS NOT NULL)
1839: UNION
1840: -- prepay application
1841: SELECT 'unreversed, unvalidated prepayment application yet to be validated'
1842: FROM ap_invoice_distributions_all aid,
1843: ap_invoices_all ai --added for bug13334090
1844: WHERE aid.invoice_id = p_inv_rec.invoice_id
1845: --AND nvl(aid.match_status_flag, 'N') = 'N' -- commented for bug13334090
1846: AND aid.invoice_id = ai.invoice_id

Line 1866: FROM ap_invoice_distributions_all aid_rel

1862: AND apph.invoice_id = p_inv_rec.invoice_id
1863: AND apph.invoice_adjustment_event_id IS NOT NULL
1864: AND NOT EXISTS(
1865: SELECT 'reversed event'
1866: FROM ap_invoice_distributions_all aid_rel
1867: WHERE aid_rel.invoice_id = apph.invoice_id
1868: AND aid_rel.accounting_event_id = apph.related_prepay_app_event_id
1869: AND aid_rel.reversal_flag = 'Y'));
1870:

Line 1875: FROM ap_invoice_distributions_all aid

1871: IF l_unacctg_events_exist = 'N' THEN
1872: IF p_xla_event_rec.event_id IS NULL THEN -- for prepayment application events
1873: SELECT MAX(AID.INVOICE_DISTRIBUTION_ID)
1874: INTO l_max_prepay_app_dist_id
1875: FROM ap_invoice_distributions_all aid
1876: WHERE aid.invoice_id = p_inv_rec.invoice_id
1877: --bug13334090 - commented below and added conditions on posted_flag and enc flag
1878: --AND aid.match_status_flag = 'S'
1879: AND aid.posted_flag <> 'Y'

Line 1926: FROM ap_invoice_distributions_all aid_rel

1922: AND apph.invoice_id = p_inv_rec.invoice_id
1923: AND apph.invoice_adjustment_event_id IS NOT NULL
1924: AND NOT EXISTS(
1925: SELECT 'reversed event'
1926: FROM ap_invoice_distributions_all aid_rel
1927: WHERE aid_rel.invoice_id = apph.invoice_id
1928: AND aid_rel.accounting_event_id = apph.related_prepay_app_event_id
1929: AND aid_rel.reversal_flag = 'Y'));
1930: END IF;

Line 1996: from ap_invoice_distributions_all aid,

1992:
1993: -- check for non-reversed, upgrade prepay application accounting w.r.t prepay_distribution_id
1994: select count(1)
1995: into l_upg_appl_actg_for_prep_dist
1996: from ap_invoice_distributions_all aid,
1997: xla_ae_headers xah
1998: where aid.prepay_distribution_id = p_prepay_distribution_id
1999: and nvl(aid.reversal_flag, 'N') <> 'Y'
2000: and aid.accounting_event_id = xah.event_id

Line 2134: from ap_invoice_distributions_all aid,

2130:
2131: -- check for non-reversed, upgrade prepay application accounting w.r.t invoice_id
2132: select count(1)
2133: into l_upg_appl_actg_for_inv
2134: from ap_invoice_distributions_all aid,
2135: xla_ae_headers xah
2136: where aid.invoice_id = p_inv_rec.invoice_id
2137: and nvl(aid.reversal_flag, 'N') <> 'Y'
2138: and aid.accounting_event_id = xah.event_id