eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_XLA_UPGRADE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 285: AP_Invoice_Distributions_All AID,

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
289: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date

Line 371: AP_Invoice_Distributions_All AID,

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
375: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date

Line 478: AP_Invoice_Distributions_All AID,

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
481: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
482: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date

Line 651: AP_Invoice_Distributions_All AID

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
655: AND AID.Invoice_ID = AI.Invoice_ID

Line 776: AP_Invoice_Distributions_All AID,

772: XLA_Transaction_Entities_upg XTE,
773: XLA_Events XLE,
774: -- AP_Accounting_Events_All AAE,
775: AP_Prepay_History_All APH,
776: AP_Invoice_Distributions_All AID,
777: AP_Inv_Dists_Source AID1,
778: XLA_AE_Headers AEH,
779: XLA_AE_Lines AEL,
780: AP_Invoice_Distributions_All AIDP

Line 780: AP_Invoice_Distributions_All AIDP

776: AP_Invoice_Distributions_All AID,
777: AP_Inv_Dists_Source AID1,
778: XLA_AE_Headers AEH,
779: XLA_AE_Lines AEL,
780: AP_Invoice_Distributions_All AIDP
781: WHERE AI.rowid between p_start_rowid and p_end_rowid
782: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
783: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date
784: AND AI.Org_ID = ASP.Org_ID

Line 917: AP_Invoice_Distributions_All AID,

913: XLA_Transaction_Entities_upg XTE,
914: XLA_Events XLE,
915: -- AP_Accounting_Events_All AAE,
916: AP_Prepay_App_Dists APAD,
917: AP_Invoice_Distributions_All AID,
918: XLA_AE_Headers AEH,
919: XLA_AE_Lines AEL
920: WHERE AI.rowid between p_start_rowid and p_end_rowid
921: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date and UPG.End_Date

Line 1188: AP_Invoice_Distributions_All AID_a

1184: AP_Invoices_All AI,
1185: AP_Payment_History_All APH,
1186: XLA_AE_Headers AEH,
1187: XLA_AE_Lines AEL,
1188: AP_Invoice_Distributions_All AID_a
1189: WHERE AC.rowid BETWEEN p_start_rowid AND p_end_rowid
1190: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date
1191: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
1192: AND AC.Org_ID = ASP.Org_ID

Line 1252: AP_Invoice_Distributions_All AID_b

1248: OR (ael.accounting_class_code IN ('AWT','DISCOUNT','BANK_CHG','BANK_ERROR')))
1249: /* AWT changes - above line, we added AWT in the list */
1250: AND FC.Currency_Code = ASP.Base_Currency_Code
1251: ) v1,
1252: AP_Invoice_Distributions_All AID_b
1253: WHERE DECODE(v1.Old_Distribution_ID, to_number(NULL), v1.invoice_id_aip, to_number(NULL)) = AID_b.Invoice_ID (+)
1254: /* AWT changes start - this condtion is to exclude the AWT lines which are inserting as CASH lines */
1255: AND nvl(AID_B.line_type_lookup_code, 1) <> 'AWT'
1256: /* AWT changes end */

Line 1582: AP_Invoice_Distributions_All AID,

1578: XLA_Events XLE,
1579: AP_Payment_History_All APH,
1580: XLA_AE_Headers AEH,
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

Line 1858: AP_Invoice_Distributions_All AID,

1854: AP_Payment_History_All APH,
1855: XLA_AE_Headers AEH,
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