[Home] [Help]
280: -- AP_Accounting_Events_All AAE,
281: XLA_AE_Headers AEH,
282: XLA_AE_Lines AEL,
283: GL_Ledgers GL, /* bug8370714, bug 13040251 */
284: FND_Currencies FC, /* bug#6660487 changed the position for FND_Currencies */
285: AP_Invoice_Distributions_All AID,
286: ZX_Rec_Nrec_Dist ZRD -- 7289100 changes
287: WHERE AI.rowid between p_start_rowid and p_end_rowid
288: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
366: -- AP_Accounting_Events_All AAE,
367: XLA_AE_Headers AEH,
368: XLA_AE_Lines AEL,
369: GL_Ledgers GL, /* bug8370714, bug 13040251 */
370: FND_Currencies FC, /* bug#6660487 changed the position for FND_Currencies */
371: AP_Invoice_Distributions_All AID,
372: ZX_Rec_Nrec_Dist ZRD -- 7289100 changes
373: WHERE AI.rowid between p_start_rowid and p_end_rowid
374: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
472: -- AP_Accounting_Events_All AAE,
473: XLA_AE_Headers AEH,
474: XLA_AE_Lines AEL,
475: GL_Ledgers GL, /* bug8370714, bug 13040251 */
476: FND_Currencies FC, /* bug#6660487 changed the position for FC */
477: AP_Inv_Dists_Source AID1,
478: AP_Invoice_Distributions_All AID,
479: ZX_Rec_Nrec_Dist ZRD -- 7289100 changes
480: WHERE AI.rowid between p_start_rowid and p_end_rowid
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,
775: AP_Prepay_History_All APH,
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,
1184: AP_Invoices_All AI,