[Home] [Help]
605: NVL2(AEL.Account_Overlay_Source_ID, DECODE(AID1.Amount,0,1,AID1.Amount),
606: DECODE(AI.Invoice_Amount,0,1,AI.Invoice_Amount)) Entered_Amt
607: FROM AP_Invoices_All AI,
608: XLA_Upgrade_Dates UPG,
609: AP_System_Parameters_All ASP,
610: AP_Accounting_Events_All AAE,
611: AP_Prepay_History_All APH,
612: AP_Invoice_Distributions_All AID,
613: AP_Inv_Dists_Source AID1,
910: NVL2(AEL.Account_Overlay_Source_ID, AID1.Invoice_Distribution_ID, 1) Partkey,
911: FC.Minimum_Accountable_Unit,
912: FC.Precision
913: FROM AP_Checks_All AC,
914: AP_System_Parameters_All ASP,
915: XLA_Upgrade_Dates UPG,
916: AP_Accounting_Events_All AAE,
917: AP_Invoice_Payments_All AIP,
918: AP_Payment_History_All APH,
1063: 'ACCRUAL_PAYMENTS_ALL' Line_Definition_Code,
1064: 'PAYMENTS' Event_Class_Code,
1065: 'PAYMENTS_ALL' Event_Type_Code
1066: FROM AP_Checks_All AC,
1067: AP_System_Parameters_All ASP,
1068: XLA_Upgrade_Dates UPG,
1069: AP_Accounting_Events_All AAE,
1070: AP_Payment_History_All APH,
1071: XLA_AE_Headers AEH,
1174: END IF;
1175:
1176: SELECT count(*)
1177: INTO l_org_count
1178: FROM AP_System_Parameters_All
1179: WHERE Set_Of_Books_ID = p_ledger_id
1180: AND Future_Dated_Pmt_Liab_Relief = 'MATURITY';
1181:
1182: IF p_mode = 'UPDATE' THEN
1259: NVL(XEL.Accounted_Cr,0) - NVL(XEL.Accounted_Dr,0) Remaining_Amount
1260: FROM XLA_AE_Lines XEL,
1261: XLA_AE_Headers XEH,
1262: AP_Checks_ALL AC,
1263: AP_System_Parameters_ALL ASP,
1264: XLA_Upgrade_Dates UPG
1265: WHERE XEL.Accounting_Class_Code = 'FUTURE_DATED_PMT'
1266: AND XEL.AE_Header_ID = XEH.AE_Header_ID
1267: AND XEH.GL_Transfer_Status_Code = 'Y'
1505:
1506: l_sql_stmt := 'SELECT MIN(AC.CHECK_ID), MAX(AC.CHECK_ID) ' ||
1507: 'FROM AP_CHECKS_ALL AC, ' ||
1508: ' XLA_UPGRADE_DATES GPS, ' ||
1509: ' AP_SYSTEM_PARAMETERS_ALL ASP ' ||
1510: 'WHERE TRUNC(AC.Check_Date) BETWEEN GPS.Start_Date ' ||
1511: ' AND GPS.End_Date ' ||
1512: 'AND GPS.Ledger_ID = ASP.Set_Of_Books_ID ' ||
1513: 'AND ASP.Org_ID = AC.Org_ID ';