[Home] [Help]
246: AID.Distribution_Line_Number,
247: FC.Minimum_Accountable_Unit Min_Acct_Unit,
248: FC.Precision Precision
249: FROM AP_Invoices_All AI,
250: XLA_Upgrade_Dates UPG,
251: AP_Accounting_Events_All AAE,
252: XLA_AE_Headers AEH,
253: XLA_AE_Lines AEL,
254: AP_Invoice_Distributions_All AID,
298: AID.Distribution_Line_Number,
299: FC.Minimum_Accountable_Unit Min_Acct_Unit,
300: FC.Precision Precision
301: FROM AP_Invoices_All AI,
302: XLA_Upgrade_Dates UPG,
303: AP_Accounting_Events_All AAE,
304: XLA_AE_Headers AEH,
305: XLA_AE_Lines AEL,
306: AP_Invoice_Distributions_All AID,
358: AID.Distribution_Line_Number,
359: FC.Minimum_Accountable_Unit Min_Acct_Unit,
360: FC.Precision Precision
361: FROM AP_Invoices_All AI,
362: XLA_Upgrade_Dates UPG,
363: AP_Accounting_Events_All AAE,
364: XLA_AE_Headers AEH,
365: XLA_AE_Lines AEL,
366: AP_Invoice_Distributions_All AID,
491: AID.Accounting_Date,
492: Row_Number() OVER (PARTITION BY AID.Accounting_Event_ID, AID.Invoice_ID
493: ORDER BY Invoice_Line_Number) RNum
494: FROM AP_Invoices_All AI,
495: XLA_Upgrade_Dates UPG,
496: AP_Invoice_Distributions_All AID
497: WHERE AI.Invoice_ID BETWEEN p_start_id and p_end_id
498: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date and UPG.End_Date
499: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
604: (NVL(AEL.Entered_Cr, 0) - NVL(AEL.Entered_Dr, 0)) * AID.Amount /
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,
717: 'ACCRUAL_INVOICES_ALL' Line_Definition_Code,
718: 'INVOICES' Event_Class_Code,
719: 'INVOICES_ALL' Event_Type_Code
720: FROM AP_Invoices_All AI,
721: XLA_Upgrade_Dates UPG,
722: AP_Accounting_Events_All AAE,
723: AP_Prepay_App_Dists APAD,
724: AP_Invoice_Distributions_All AID,
725: XLA_AE_Headers AEH,
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,
919: XLA_AE_Headers AEH,
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,
1072: XLA_AE_Lines AEL,
1185: SELECT Start_Date,
1186: End_Date
1187: INTO l_gl_date_from,
1188: l_gl_date_to
1189: FROM XLA_Upgrade_Dates
1190: WHERE Ledger_ID = p_ledger_id;
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: l_gl_date_from := NULL;
1217: FROM (SELECT APL.Code_Combination_ID Code_Combination_ID,
1218: UPG.Start_Date Balance_Date,
1219: SUM(NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0)) Balance_Amount
1220: FROM AP_Liability_Balance APL,
1221: XLA_Upgrade_Dates UPG
1222: WHERE APL.Set_Of_Books_ID = p_ledger_id
1223: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
1224: AND APL.Accounting_Date < UPG.Start_Date
1225: HAVING SUM(NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0)) <> 0
1247: APL.Code_Combination_ID Code_Combination_ID,
1248: UPG.Start_Date Balance_Date,
1249: NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0) Remaining_Amount
1250: FROM AP_Liability_Balance APL,
1251: XLA_Upgrade_Dates UPG
1252: WHERE APL.Set_Of_Books_ID = p_ledger_id
1253: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
1254: AND APL.Accounting_Date < UPG.Start_Date
1255: UNION ALL
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'
1268: AND TRUNC(XEH.Accounting_Date) < UPG.Start_Date
1408:
1409: l_sql_stmt := 'SELECT /*+ parallel(AI) parallel(GPS) use_merge(AI,GPS) */ '
1410: || ' MIN(INVOICE_ID), MAX(INVOICE_ID) '
1411: || 'FROM AP_INVOICES_ALL AI, '
1412: || 'XLA_UPGRADE_DATES GPS '
1413: || 'WHERE TRUNC(AI.GL_DATE) BETWEEN GPS.Start_Date AND GPS.End_Date '
1414: || 'AND GPS.Ledger_ID = AI.Set_Of_Books_ID';
1415:
1416: ad_parallel_updates_pkg.initialize_id_range(
1504: l_id_column := 'CHECK_ID';
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 ' ||
1769: 5,
1770: Sysdate,
1771: 5
1772: FROM AP_Liability_Balance
1773: WHERE Set_Of_Books_ID IN (SELECT Ledger_ID FROM XLA_Upgrade_Dates);
1774:
1775: SELECT xla_upg_batches_s.nextval
1776: INTO l_batch_id
1777: FROM DUAL;