[Home] [Help]
273: FC.Minimum_Accountable_Unit Min_Acct_Unit,
274: FC.Precision Precision,
275: 'A' Merge_Duplicate_Code --added by abhsaxen for bug#9073033
276: FROM AP_Invoices_All AI,
277: XLA_Upgrade_Dates UPG,
278: XLA_Transaction_Entities_upg XTE,
279: XLA_Events XLE,
280: -- AP_Accounting_Events_All AAE,
281: XLA_AE_Headers AEH,
359: FC.Minimum_Accountable_Unit Min_Acct_Unit,
360: FC.Precision Precision,
361: 'A' Merge_Duplicate_Code --added by abhsaxen for bug#9073033
362: FROM AP_Invoices_All AI,
363: XLA_Upgrade_Dates UPG,
364: XLA_Transaction_Entities_upg XTE,
365: XLA_Events XLE,
366: -- AP_Accounting_Events_All AAE,
367: XLA_AE_Headers AEH,
465: 'A'
466: END
467: MERGE_DUPLICATE_CODE -- changed by abhsaxen for bug 9073033
468: FROM AP_Invoices_All AI,
469: XLA_Upgrade_Dates UPG,
470: XLA_Transaction_Entities_upg XTE,
471: XLA_Events XLE,
472: -- AP_Accounting_Events_All AAE,
473: XLA_AE_Headers AEH,
646: AID.Accounting_Date,
647: Row_Number() OVER (PARTITION BY AID.Accounting_Event_ID, AID.Invoice_ID
648: ORDER BY Invoice_Line_Number) RNum
649: FROM AP_Invoices_All AI,
650: XLA_Upgrade_Dates UPG,
651: AP_Invoice_Distributions_All AID
652: WHERE AI.rowid between p_start_rowid and p_end_rowid
653: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date and UPG.End_Date
654: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
765: (NVL(AEL.Entered_Cr, 0) - NVL(AEL.Entered_Dr, 0)) * AID.Amount /
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,
908: DECODE(AEL.Accounting_Class_Code, 'LIABILITY' ,AID.Invoice_Distribution_ID, null)
909: APPLIED_TO_DIST_ID_NUM_1,
910: '-2222' GAIN_OR_LOSS_REF --Bug7169843 ends
911: FROM AP_Invoices_All AI,
912: XLA_Upgrade_Dates UPG,
913: XLA_Transaction_Entities_upg XTE,
914: XLA_Events XLE,
915: -- AP_Accounting_Events_All AAE,
916: AP_Prepay_App_Dists APAD,
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,
1183: AP_Invoice_Payments_All AIP,
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,
1580: XLA_AE_Headers AEH,
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,
1855: XLA_AE_Headers AEH,
2016: SELECT Start_Date,
2017: End_Date
2018: INTO l_gl_date_from,
2019: l_gl_date_to
2020: FROM XLA_Upgrade_Dates
2021: WHERE Ledger_ID = p_ledger_id;
2022: EXCEPTION
2023: WHEN OTHERS THEN
2024: l_gl_date_from := NULL;
2048: FROM (SELECT APL.Code_Combination_ID Code_Combination_ID,
2049: UPG.Start_Date Balance_Date,
2050: SUM(NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0)) Balance_Amount
2051: FROM AP_Liability_Balance APL,
2052: XLA_Upgrade_Dates UPG
2053: WHERE APL.Set_Of_Books_ID = p_ledger_id
2054: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
2055: AND APL.Accounting_Date < UPG.Start_Date
2056: HAVING SUM(NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0)) <> 0
2078: APL.Code_Combination_ID Code_Combination_ID,
2079: UPG.Start_Date Balance_Date,
2080: NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0) Remaining_Amount
2081: FROM AP_Liability_Balance APL,
2082: XLA_Upgrade_Dates UPG
2083: WHERE APL.Set_Of_Books_ID = p_ledger_id
2084: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
2085: AND APL.Accounting_Date < UPG.Start_Date
2086: UNION ALL
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'
2099: AND TRUNC(XEH.Accounting_Date) < UPG.Start_Date