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.ARP_XLA_UPGRADE dependencies on XLA_DISTRIBUTION_LINKS

Line 562: INTO XLA_DISTRIBUTION_LINKS

558: gain_or_loss_flag,
559: accounting_date,
560: ledger_id)
561: WHEN 1 = 1 THEN
562: INTO XLA_DISTRIBUTION_LINKS
563: (APPLICATION_ID,
564: EVENT_ID,
565: AE_HEADER_ID,
566: AE_LINE_NUM,

Line 1312: INTO XLA_DISTRIBUTION_LINKS

1308: gain_or_loss_flag,
1309: accounting_date,
1310: ledger_id)
1311: WHEN 1 = 1 THEN
1312: INTO XLA_DISTRIBUTION_LINKS
1313: (APPLICATION_ID,
1314: EVENT_ID,
1315: AE_HEADER_ID,
1316: AE_LINE_NUM,

Line 2180: INTO XLA_DISTRIBUTION_LINKS

2176: gain_or_loss_flag,
2177: accounting_date,
2178: ledger_id)
2179: WHEN 1 = 1 THEN
2180: INTO XLA_DISTRIBUTION_LINKS
2181: (APPLICATION_ID,
2182: EVENT_ID,
2183: AE_HEADER_ID,
2184: AE_LINE_NUM,

Line 2939: INTO XLA_DISTRIBUTION_LINKS

2935: 'N',
2936: accounting_date,
2937: ledger_id)
2938: WHEN 1 = 1 THEN
2939: INTO XLA_DISTRIBUTION_LINKS
2940: (APPLICATION_ID,
2941: EVENT_ID,
2942: AE_HEADER_ID,
2943: AE_LINE_NUM,

Line 3223: xla_distribution_links xdl,

3219: xla_ae_headers xah,
3220: xla_transaction_entities_upg xte,
3221: ar_cash_receipts_all cr,
3222: ar_system_parameters_all asp,
3223: xla_distribution_links xdl,
3224: ar_cash_receipt_history_all crh,
3225: xla_upgrade_dates gps,
3226: ar_distributions_all ard,
3227: gl_je_lines gjl

Line 3274: xla_distribution_links xdl,

3270: xla_ae_headers xah,
3271: xla_transaction_entities_upg xte,
3272: ar_cash_receipts_all cr,
3273: ar_system_parameters_all asp,
3274: xla_distribution_links xdl,
3275: ar_receivable_applications_all unapp,
3276: xla_upgrade_dates gps,
3277: ar_distributions_all ard,
3278: gl_je_lines gjl

Line 3328: USE_NL_WITH_INDEX(lnk XLA_DISTRIBUTION_LINKS_N1)

3324: (SELECT /*+
3325: NO_EXPAND leading(ghd,periods,gld,gps,lnk,ln)
3326: use_nl(ghd,gld,gps)
3327: USE_NL_WITH_INDEX(ln XLA_AE_LINES_U1)
3328: USE_NL_WITH_INDEX(lnk XLA_DISTRIBUTION_LINKS_N1)
3329: */
3330: LN.GL_SL_LINK_ID, 'XLAJEL'
3331: FROM GL_JE_HEADERS GHD,
3332: GL_JE_LINES GLD,

Line 3334: XLA_DISTRIBUTION_LINKS LNK,

3330: LN.GL_SL_LINK_ID, 'XLAJEL'
3331: FROM GL_JE_HEADERS GHD,
3332: GL_JE_LINES GLD,
3333: XLA_UPGRADE_DATES GPS,
3334: XLA_DISTRIBUTION_LINKS LNK,
3335: XLA_AE_LINES LN
3336: WHERE EXISTS
3337: (select /*+ PUSH_SUBQ */ null
3338: from ar120gir_periods periods

Line 3382: USE_NL_WITH_INDEX(lnk XLA_DISTRIBUTION_LINKS_N1)

3378: (SELECT /*+
3379: NO_EXPAND leading(ghd,periods,gld,gps,lnk,ln)
3380: use_nl(ghd,gld,gps)
3381: USE_NL_WITH_INDEX(ln XLA_AE_LINES_U1)
3382: USE_NL_WITH_INDEX(lnk XLA_DISTRIBUTION_LINKS_N1)
3383: */
3384: LN.GL_SL_LINK_ID, 'XLAJEL'
3385: FROM GL_JE_HEADERS GHD,
3386: GL_JE_LINES GLD,

Line 3388: XLA_DISTRIBUTION_LINKS LNK,

3384: LN.GL_SL_LINK_ID, 'XLAJEL'
3385: FROM GL_JE_HEADERS GHD,
3386: GL_JE_LINES GLD,
3387: XLA_UPGRADE_DATES GPS,
3388: XLA_DISTRIBUTION_LINKS LNK,
3389: XLA_AE_LINES LN
3390: WHERE EXISTS
3391: (select /*+ PUSH_SUBQ */ null
3392: from ar120gir_periods periods

Line 3592: INTO XLA_DISTRIBUTION_LINKS

3588: 'N',
3589: accounting_date,
3590: ledger_id)
3591: WHEN 1 = 1 THEN
3592: INTO XLA_DISTRIBUTION_LINKS
3593: (APPLICATION_ID,
3594: EVENT_ID,
3595: AE_HEADER_ID,
3596: AE_LINE_NUM,

Line 4497: INTO XLA_DISTRIBUTION_LINKS

4493: gain_or_loss_flag,
4494: accounting_date,
4495: ledger_id)
4496: WHEN 1 = 1 THEN
4497: INTO XLA_DISTRIBUTION_LINKS
4498: (APPLICATION_ID,
4499: EVENT_ID,
4500: AE_HEADER_ID,
4501: AE_LINE_NUM,

Line 4629: select 'x' from XLA_DISTRIBUTION_LINKS xdl

4625: where nvl(cr.ax_accounted_flag,'N') = 'N'
4626: and cr.cash_receipt_id = crh.cash_receipt_id
4627: and cr.cash_receipt_id = p_cash_receipt_id
4628: and not exists (
4629: select 'x' from XLA_DISTRIBUTION_LINKS xdl
4630: where xdl.application_id = 222
4631: and xdl.source_distribution_id_num_1 = ard.line_id
4632: and xdl.ae_header_id = hdr.ae_header_id
4633: and xdl.event_id = hdr.event_id

Line 4737: select 'x' from XLA_DISTRIBUTION_LINKS xdl

4733: and ( sys.accounting_method = 'ACCRUAL' or ( sys.accounting_method = 'CASH' and app.status in ('UNAPP', 'UNID', 'ACC') ) )
4734: and cr.cash_receipt_id = app.cash_receipt_id
4735: and cr.cash_receipt_id = p_cash_receipt_id
4736: and not exists (
4737: select 'x' from XLA_DISTRIBUTION_LINKS xdl
4738: where xdl.application_id = 222
4739: and xdl.source_distribution_id_num_1 = ard.line_id
4740: and xdl.ae_header_id = hdr.ae_header_id
4741: and xdl.event_id = hdr.event_id

Line 4823: select 'x' from XLA_DISTRIBUTION_LINKS xdl

4819: -- and trunc(mcd.gl_date) between gps.start_date and gps.end_date
4820: -- and gps.ledger_id = cr.set_of_books_id
4821: and cr.cash_receipt_id = crh.cash_receipt_id
4822: and not exists (
4823: select 'x' from XLA_DISTRIBUTION_LINKS xdl
4824: where xdl.application_id = 222
4825: and xdl.source_distribution_id_num_1 = ard.line_id
4826: and xdl.ae_header_id = hdr.ae_header_id
4827: and xdl.event_id = hdr.event_id

Line 4939: INTO XLA_DISTRIBUTION_LINKS

4935: 'N',
4936: accounting_date,
4937: ledger_id)
4938: WHEN 1 = 1 THEN
4939: INTO XLA_DISTRIBUTION_LINKS
4940: (APPLICATION_ID,
4941: EVENT_ID,
4942: AE_HEADER_ID,
4943: AE_LINE_NUM,

Line 5148: select 'x' from xla_distribution_links xdl

5144: and cbs.receivable_application_id = app.receivable_application_id
5145: and cbs.source_id = ctlgd.cust_trx_line_gl_dist_id (+)
5146: and cr.cash_receipt_id = p_cash_receipt_id
5147: and not exists (
5148: select 'x' from xla_distribution_links xdl
5149: where xdl.application_id = 222
5150: and xdl.source_distribution_id_num_1 = cbs.cash_basis_distribution_id
5151: and xdl.ae_header_id = hdr.ae_header_id
5152: and xdl.event_id = hdr.event_id