[Home] [Help]
249: use_nl_with_index (xle, xla_events_u2)
250: use_nl_with_index (aeh, xla_ae_headers_n2)
251: use_nl_with_index (ael, xla_ae_lines_u1)
252: use_nl_with_index (aid, ap_invoice_distributions_n27)
253: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
254: AEH.Event_ID,
255: AEH.AE_Header_ID,
256: AEL.AE_Line_Num,
257: AID.Invoice_Distribution_ID,
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
289: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date
290: -- AND AI.Invoice_ID = AAE.Source_ID
335: use_nl_with_index (xle, xla_events_u2)
336: use_nl_with_index (aeh, xla_ae_headers_n2)
337: use_nl_with_index (ael, xla_ae_lines_u1)
338: use_nl_with_index (aid, ap_invoice_distributions_n26)
339: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
340: AEH.Event_ID,
341: AEH.AE_Header_ID,
342: AEL.AE_Line_Num,
343: AID.Invoice_Distribution_ID,
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
375: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date
376: -- AND AI.Invoice_ID = AAE.Source_ID
424: use_nl_with_index (aeh, xla_ae_headers_n2)
425: use_nl_with_index (ael, xla_ae_lines_u1)
426: use_nl_with_index (aid1, ap_invoice_dists_arch_u2)
427: use_nl_with_index (aid, ap_invoice_distributions_n26)
428: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
429: AEH.Event_id,
430: AEH.AE_Header_ID,
431: AEL.AE_Line_Num,
432: AID.Invoice_Distribution_ID,
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
481: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
482: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date
483: -- AND AI.Invoice_ID = AAE.Source_ID
1347: use_nl_with_index (ael, xla_ae_lines_u1)
1348: use_nl_with_index (aph, ap_payment_history_n2)
1349: use_nl_with_index (aid, ap_invoice_distributions_n26)
1350: use_nl_with_index (aphd, ap_payment_hist_dists_n2)
1351: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
1352: 200 Application_ID,
1353: AEH.Event_ID Accounting_Event_ID,
1354: AEH.AE_Header_ID AE_Header_ID,
1355: AEL.AE_Line_Num AE_Line_Num,
1581: XLA_AE_Lines AEL,
1582: AP_Invoice_Distributions_All AID,
1583: AP_Payment_Hist_Dists APHD,
1584: XLA_Events XTE_INV, --Bug7169843
1585: ZX_Rec_Nrec_Dist ZRD -- 7360647 changes
1586: WHERE AC.rowid BETWEEN p_start_rowid AND p_end_rowid
1587: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date
1588: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
1589: AND AC.Org_ID = ASP.Org_ID
1626: use_nl_with_index (ael, xla_ae_lines_u1)
1627: use_nl_with_index (aph, ap_payment_history_n2)
1628: use_nl_with_index (aphd, ap_payment_hist_dists_n1)
1629: use_nl_with_index (aid, ap_invoice_distributions_u2)
1630: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
1631: 200 Application_ID,
1632: AEH.Event_ID Accounting_Event_ID,
1633: AEH.AE_Header_ID AE_Header_ID,
1634: AEL.AE_Line_Num AE_Line_Num,
1856: XLA_AE_Lines AEL,
1857: AP_Payment_Hist_Dists APHD,
1858: AP_Invoice_Distributions_All AID,
1859: XLA_Events XTE_INV, --Bug7169843
1860: ZX_Rec_Nrec_Dist ZRD -- 7360647 changes
1861: WHERE AC.rowid BETWEEN p_start_rowid AND p_end_rowid
1862: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date
1863: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
1864: AND AC.Org_ID = ASP.Org_ID