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.FA_SLA_EVENTS_UPG_PKG dependencies on FA_ADJUSTMENTS

Line 175: from fa_adjustments adj

171: and userenv('LANG') = lk2.language
172: and exists
173: (
174: select 'x'
175: from fa_adjustments adj
176: where th1.transaction_header_id = adj.transaction_header_id
177: and th1.book_type_code = adj.book_type_code
178: and th1.asset_id = adj.asset_id
179: )

Line 187: from fa_adjustments adj

183: and th2.event_id is null
184: and exists
185: (
186: select 'x'
187: from fa_adjustments adj
188: where th2.transaction_header_id = adj.transaction_header_id
189: and th2.book_type_code = adj.book_type_code
190: and th2.asset_id = adj.asset_id
191: );

Line 233: from fa_adjustments adj,

229: gljh.je_batch_id,
230: adj.je_header_id,
231: nvl(adj.je_line_num, 0),
232: adj.distribution_id
233: from fa_adjustments adj,
234: gl_sets_of_books glsob,
235: fa_book_controls bc,
236: fa_lookups_tl lk,
237: gl_je_headers gljh

Line 291: from fa_adjustments adj,

287: gljh.je_batch_id,
288: dd.je_header_id,
289: nvl(dd.deprn_reserve_je_line_num, 0),
290: adj.distribution_id
291: from fa_adjustments adj,
292: gl_sets_of_books glsob,
293: fa_book_controls bc,
294: fa_lookups_tl lk,
295: gl_je_headers gljh,

Line 366: from fa_adjustments adj,

362: gljh.je_batch_id,
363: dd.je_header_id,
364: nvl(dd.deprn_reserve_je_line_num, 0),
365: adj.distribution_id
366: from fa_adjustments adj,
367: gl_sets_of_books glsob,
368: fa_book_controls bc,
369: fa_lookups_tl lk,
370: gl_je_headers gljh,

Line 2572: from fa_adjustments adj

2568: and userenv('LANG') = lk.language
2569: and exists
2570: (
2571: select 'x'
2572: from fa_adjustments adj
2573: where th.transaction_header_id = adj.transaction_header_id
2574: and th.book_type_code = adj.book_type_code
2575: and th.asset_id = adj.asset_id
2576: )

Line 2649: from fa_adjustments adj

2645: and userenv('LANG') = lk.language
2646: and exists
2647: (
2648: select 'x'
2649: from fa_adjustments adj
2650: where th.transaction_header_id = adj.transaction_header_id
2651: and bc.book_type_code = adj.book_type_code
2652: and th.asset_id = adj.asset_id
2653: );

Line 2695: from fa_adjustments adj,

2691: gljh.je_batch_id,
2692: adj.je_header_id,
2693: nvl(adj.je_line_num, 0),
2694: adj.distribution_id
2695: from fa_adjustments adj,
2696: fa_lookups_tl lk,
2697: gl_je_headers gljh,
2698: fa_book_controls bc,
2699: gl_sets_of_books glsob

Line 2753: from fa_adjustments adj,

2749: gljh.je_batch_id,
2750: dd.je_header_id,
2751: nvl(dd.deprn_reserve_je_line_num, 0),
2752: adj.distribution_id
2753: from fa_adjustments adj,
2754: gl_sets_of_books glsob,
2755: fa_book_controls bc,
2756: fa_lookups_tl lk,
2757: gl_je_headers gljh,

Line 2828: from fa_adjustments adj,

2824: gljh.je_batch_id,
2825: dd.je_header_id,
2826: nvl(dd.deprn_reserve_je_line_num, 0),
2827: adj.distribution_id
2828: from fa_adjustments adj,
2829: gl_sets_of_books glsob,
2830: fa_book_controls bc,
2831: fa_lookups_tl lk,
2832: gl_je_headers gljh,

Line 4562: select /+ index(adj, FA_ADJUSTMENTS_U1) /

4558: and lk.lookup_type = 'FAXOLTRX'
4559: and userenv('LANG') = lk.language
4560: and exists
4561: (
4562: select /*+ index(adj, FA_ADJUSTMENTS_U1) */
4563: 'x'
4564: from fa_adjustments adj
4565: where th.transaction_header_id = adj.transaction_header_id
4566: and bc.book_type_code = adj.book_type_code

Line 4564: from fa_adjustments adj

4560: and exists
4561: (
4562: select /*+ index(adj, FA_ADJUSTMENTS_U1) */
4563: 'x'
4564: from fa_adjustments adj
4565: where th.transaction_header_id = adj.transaction_header_id
4566: and bc.book_type_code = adj.book_type_code
4567: and th.asset_id = adj.asset_id
4568: )

Line 4645: select /+ index(adj, FA_ADJUSTMENTS_U1) /

4641: and lk.lookup_type = 'FAXOLTRX'
4642: and userenv('LANG') = lk.language
4643: and exists
4644: (
4645: select /*+ index(adj, FA_ADJUSTMENTS_U1) */
4646: 'x'
4647: from fa_adjustments adj
4648: where th.transaction_header_id = adj.transaction_header_id
4649: and bc.book_type_code = adj.book_type_code

Line 4647: from fa_adjustments adj

4643: and exists
4644: (
4645: select /*+ index(adj, FA_ADJUSTMENTS_U1) */
4646: 'x'
4647: from fa_adjustments adj
4648: where th.transaction_header_id = adj.transaction_header_id
4649: and bc.book_type_code = adj.book_type_code
4650: and th.asset_id = adj.asset_id
4651: );

Line 5307: select /+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) /

5303: null, -- subledger_doc_seq_value
5304: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5305: 'XLAJEL' -- gl_sl_link_table
5306: )
5307: select /*+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
5308: adj.adjustment_line_id adj_line_id,
5309: decode(adj.debit_credit_flag,
5310: 'DR', adj.adjustment_amount, null) debit_amount,
5311: decode(adj.debit_credit_flag,

Line 5378: fa_adjustments adj,

5374: mult.adj_row adj_row
5375: from
5376: fa_xla_upg_events_gt ev,
5377: fa_xla_upg_headers_gt he,
5378: fa_adjustments adj,
5379: fa_lookups_tl lk,
5380: fa_lookups_tl lk2,
5381: gl_je_headers gljh,
5382: fa_deprn_detail dd,