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 XLA_AE_HEADERS

Line 250: use_nl_with_index (aeh, xla_ae_headers_n2)

246: SELECT /*+ ordered rowid(ai) swap_join_inputs (upg) swap_join_inputs(FC)
247: no_expand use_hash(FC,upg)
248: use_nl_with_index (xte, xla_transaction_entities_n1)
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,

Line 281: XLA_AE_Headers AEH,

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,
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,

Line 336: use_nl_with_index (aeh, xla_ae_headers_n2)

332: SELECT /*+ ordered rowid(ai) swap_join_inputs (upg) swap_join_inputs(FC)
333: no_expand use_hash(FC,upg)
334: use_nl_with_index (xte, xla_transaction_entities_n1)
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,

Line 367: XLA_AE_Headers AEH,

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,
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,

Line 424: use_nl_with_index (aeh, xla_ae_headers_n2)

420: /* bug#7289100 added hit for zrd */
421: SELECT /*+ ordered rowid(ai) swap_join_inputs (upg) swap_join_inputs(FC)
422: use_nl_with_index (xte, xla_transaction_entities_n1)
423: use_nl_with_index (xle, xla_events_u2)
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) */

Line 473: XLA_AE_Headers AEH,

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,
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,

Line 739: use_nl_with_index (aeh, xla_ae_headers_n2)

735: use_nl_with_index (xle, xla_events_u2)
736: use_nl_with_index (aph, ap_prepay_history_n1)
737: use_nl_with_index (aid, ap_invoice_distributions_n27)
738: use_nl_with_index (aid1, ap_invoice_dists_arch_u2)
739: use_nl_with_index (aeh, xla_ae_headers_n2)
740: use_nl_with_index (ael, xla_ae_lines_u1)
741: use_nl_with_index (aidp, ap_invoice_distributions_n26) */
742: DECODE(AEL.Accounting_Class_Code, 'RTAX',
743: 'PREPAY APPL REC TAX', 'NRTAX', 'PREPAY APPL NONREC TAX',

Line 778: XLA_AE_Headers AEH,

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
781: WHERE AI.rowid between p_start_rowid and p_end_rowid
782: AND AI.Set_Of_Books_ID = UPG.Ledger_ID

Line 863: use_nl_with_index (aeh, xla_ae_headers_n2)

859: use_nl_with_index (xte, xla_transaction_entities_n1)
860: use_nl_with_index (xle, xla_events_u2)
861: use_nl_with_index (apad, ap_prepay_app_dists_n3)
862: use_nl_with_index (aid, ap_invoice_distributions_u2)
863: use_nl_with_index (aeh, xla_ae_headers_n2)
864: use_nl_with_index (ael, xla_ae_lines_u1) */
865: 200 Application_ID,
866: AEH.Event_ID Accounting_Event_ID,
867: AEH.AE_Header_ID AE_Header_ID,

Line 918: XLA_AE_Headers AEH,

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
922: AND AI.Set_Of_Books_ID = UPG.Ledger_ID

Line 1141: use_nl_with_index (aeh, xla_ae_headers_n2)

1137: (SELECT /*+ ordered use_hash(asp, upg) rowid(ac) no_merge
1138: swap_join_inputs (upg) swap_join_inputs (asp) swap_join_inputs(fc)
1139: use_nl_with_index (xte, xla_transaction_entities_n1)
1140: use_nl_with_index (xle, xla_events_u2)
1141: use_nl_with_index (aeh, xla_ae_headers_n2)
1142: use_nl_with_index (ael, xla_ae_lines_u1)
1143: use_nl_with_index (aip, ap_invoice_payments_n2)
1144: use_nl_with_index (aph, ap_payment_history_n2)
1145: use_nl_with_index (aid_a, ap_invoice_distributions_n26) */

Line 1186: XLA_AE_Headers AEH,

1182: XLA_Events XLE,
1183: AP_Invoice_Payments_All AIP,
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

Line 1346: use_nl_with_index (aeh, xla_ae_headers_n2)

1342: SELECT /*+ ordered use_hash(asp, upg) rowid(ac)
1343: swap_join_inputs (upg) swap_join_inputs (asp)
1344: use_nl_with_index (xte, xla_transaction_entities_n1)
1345: use_nl_with_index (xle, xla_events_u2)
1346: use_nl_with_index (aeh, xla_ae_headers_n2)
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)

Line 1580: XLA_AE_Headers AEH,

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,
1581: XLA_AE_Lines AEL,
1582: AP_Invoice_Distributions_All AID,
1583: AP_Payment_Hist_Dists APHD,
1584: XLA_Events XTE_INV, --Bug7169843

Line 1625: use_nl_with_index (aeh, xla_ae_headers_n2)

1621: SELECT /*+ ordered use_hash(asp, upg) rowid(ac)
1622: swap_join_inputs (upg) swap_join_inputs (asp)
1623: use_nl_with_index (xte, xla_transaction_entities_n1)
1624: use_nl_with_index (xle, xla_events_u2)
1625: use_nl_with_index (aeh, xla_ae_headers_n2)
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)

Line 1855: XLA_AE_Headers AEH,

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,
1856: XLA_AE_Lines AEL,
1857: AP_Payment_Hist_Dists APHD,
1858: AP_Invoice_Distributions_All AID,
1859: XLA_Events XTE_INV, --Bug7169843

Line 2092: XLA_AE_Headers XEH,

2088: XEL.Code_Combination_ID Code_Combination_ID,
2089: UPG.Start_Date Balance_Date,
2090: NVL(XEL.Accounted_Cr,0) - NVL(XEL.Accounted_Dr,0) Remaining_Amount
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'

Line 2109: XLA_AE_Headers XEH1

2105: AND ASP.Future_Dated_Pmt_Liab_Relief = 'MATURITY'
2106: AND NOT EXISTS (SELECT 'Payment Maturity'
2107: FROM AP_Payment_History_All APH,
2108: XLA_Events XLE,
2109: XLA_AE_Headers XEH1
2110: WHERE APH.Accounting_Event_ID = XLE.Event_ID
2111: AND XLE.Event_ID = XEH1.Event_ID
2112: AND APH.Check_ID = AC.Check_ID
2113: AND APH.Transaction_Type = 'PAYMENT MATURITY'