[Home] [Help]
766: NVL2(AEL.Account_Overlay_Source_ID, DECODE(AID1.Amount,0,1,AID1.Amount),
767: DECODE(AI.Invoice_Amount,0,1,AI.Invoice_Amount)) Entered_Amt
768: FROM AP_Invoices_All AI,
769: XLA_Upgrade_Dates UPG,
770: AP_System_Parameters_All ASP,
771: FND_Currencies FC,/* bug#6660487 changed the order of FC */
772: XLA_Transaction_Entities_upg XTE,
773: XLA_Events XLE,
774: -- AP_Accounting_Events_All AAE,
1174: AI.Base_Amount Base_Amount_ai,
1175: AI.Invoice_Amount Invoice_Amount_ai,
1176: AIP.invoice_ID invoice_id_aip
1177: FROM AP_Checks_All AC,
1178: AP_System_Parameters_All ASP,
1179: XLA_Upgrade_Dates UPG,
1180: FND_Currencies FC,
1181: XLA_Transaction_Entities_Upg XTE,
1182: XLA_Events XLE,
1571: AID.Summary_Tax_Line_ID,
1572: AID.Detail_Tax_Dist_ID
1573: /* 7360647 changes end */
1574: FROM AP_Checks_All AC,
1575: AP_System_Parameters_All ASP,
1576: XLA_Upgrade_Dates UPG,
1577: XLA_Transaction_Entities_Upg XTE,
1578: XLA_Events XLE,
1579: AP_Payment_History_All APH,
1846: AID.Summary_Tax_Line_ID,
1847: AID.Detail_Tax_Dist_ID
1848: /* 7360647 changes end */
1849: FROM AP_Checks_All AC,
1850: AP_System_Parameters_All ASP,
1851: XLA_Upgrade_Dates UPG,
1852: XLA_Transaction_Entities_Upg XTE,
1853: XLA_Events XLE,
1854: AP_Payment_History_All APH,
2005: END IF;
2006:
2007: SELECT count(*)
2008: INTO l_org_count
2009: FROM AP_System_Parameters_All
2010: WHERE Set_Of_Books_ID = p_ledger_id
2011: AND Future_Dated_Pmt_Liab_Relief = 'MATURITY';
2012:
2013: IF p_mode = 'UPDATE' THEN
2090: NVL(XEL.Accounted_Cr,0) - NVL(XEL.Accounted_Dr,0) Remaining_Amount
2091: FROM XLA_AE_Lines XEL,
2092: XLA_AE_Headers XEH,
2093: AP_Checks_ALL AC,
2094: AP_System_Parameters_ALL ASP,
2095: XLA_Upgrade_Dates UPG
2096: WHERE XEL.Accounting_Class_Code = 'FUTURE_DATED_PMT'
2097: AND XEL.AE_Header_ID = XEH.AE_Header_ID
2098: AND XEH.GL_Transfer_Status_Code = 'Y'