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_LINES

Line 251: use_nl_with_index (ael, xla_ae_lines_u1)

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,
255: AEH.AE_Header_ID,

Line 282: XLA_AE_Lines AEL,

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,
286: ZX_Rec_Nrec_Dist ZRD -- 7289100 changes

Line 337: use_nl_with_index (ael, xla_ae_lines_u1)

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,
341: AEH.AE_Header_ID,

Line 368: XLA_AE_Lines AEL,

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,
372: ZX_Rec_Nrec_Dist ZRD -- 7289100 changes

Line 425: use_nl_with_index (ael, xla_ae_lines_u1)

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) */
429: AEH.Event_id,

Line 474: XLA_AE_Lines AEL,

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,
478: AP_Invoice_Distributions_All AID,

Line 740: use_nl_with_index (ael, xla_ae_lines_u1)

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',
744: 'PREPAY APPL') Prepay_Dist_Lookup_Code,

Line 779: XLA_AE_Lines AEL,

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

Line 864: use_nl_with_index (ael, xla_ae_lines_u1) */

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,
868: AEL.AE_Line_Num AE_Line_Num,

Line 919: XLA_AE_Lines AEL

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

Line 1142: use_nl_with_index (ael, xla_ae_lines_u1)

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) */
1146: AID_a.Invoice_ID,

Line 1187: XLA_AE_Lines AEL,

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
1191: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID

Line 1347: use_nl_with_index (ael, xla_ae_lines_u1)

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)
1351: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */

Line 1581: XLA_AE_Lines AEL,

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
1585: ZX_Rec_Nrec_Dist ZRD -- 7360647 changes

Line 1626: use_nl_with_index (ael, xla_ae_lines_u1)

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)
1630: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */

Line 1856: XLA_AE_Lines AEL,

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
1860: ZX_Rec_Nrec_Dist ZRD -- 7360647 changes

Line 2091: FROM XLA_AE_Lines XEL,

2087: SELECT XEH.Ledger_ID Ledger_ID,
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