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_LOOKUPS

Line 141: fa_lookups_tl lk1,

137: fa_transaction_headers th2,
138: fa_book_controls bc,
139: fa_deprn_periods dp,
140: fa_trx_references tr,
141: fa_lookups_tl lk1,
142: fa_lookups_tl lk2,
143: gl_period_statuses ps
144: where tr.rowid between p_start_rowid and p_end_rowid
145: and ps.application_id = 101

Line 142: fa_lookups_tl lk2,

138: fa_book_controls bc,
139: fa_deprn_periods dp,
140: fa_trx_references tr,
141: fa_lookups_tl lk1,
142: fa_lookups_tl lk2,
143: gl_period_statuses ps
144: where tr.rowid between p_start_rowid and p_end_rowid
145: and ps.application_id = 101
146: and ((ps.migration_status_code in ('P', 'U')) or

Line 236: fa_lookups_tl lk,

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
238: where bc.book_type_code = l_book_type_code
239: and bc.set_of_books_id = glsob.set_of_books_id
240: and bc.book_type_code = adj.book_type_code

Line 294: fa_lookups_tl lk,

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,
296: fa_deprn_detail dd,
297: gl_je_lines gljl,
298: fa_distribution_accounts da,

Line 369: fa_lookups_tl lk,

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,
371: fa_deprn_detail dd,
372: gl_je_lines gljl,
373: fa_distribution_accounts da,

Line 453: fa_lookups_tl lk,

449: adj.distribution_id
450: from fa_mc_adjustments adj,
451: gl_sets_of_books glsob,
452: fa_mc_book_controls bc,
453: fa_lookups_tl lk,
454: gl_je_headers gljh
455: where bc.book_type_code = l_book_type_code
456: and bc.set_of_books_id = l_set_of_books_id
457: and bc.enabled_flag = 'Y'

Line 514: fa_lookups_tl lk,

510: adj.distribution_id
511: from fa_mc_adjustments adj,
512: gl_sets_of_books glsob,
513: fa_mc_book_controls bc,
514: fa_lookups_tl lk,
515: gl_je_headers gljh,
516: fa_mc_deprn_detail dd,
517: gl_je_lines gljl,
518: fa_distribution_accounts da,

Line 593: fa_lookups_tl lk,

589: adj.distribution_id
590: from fa_mc_adjustments adj,
591: gl_sets_of_books glsob,
592: fa_mc_book_controls bc,
593: fa_lookups_tl lk,
594: gl_je_headers gljh,
595: fa_mc_deprn_detail dd,
596: gl_je_lines gljl,
597: fa_distribution_accounts da,

Line 2543: fa_lookups_tl lk,

2539: fa_asset_history ah,
2540: fa_deprn_periods dp,
2541: gl_sets_of_books glsob,
2542: fa_book_controls bc,
2543: fa_lookups_tl lk,
2544: gl_period_statuses ps
2545: where th.rowid between p_start_rowid and p_end_rowid
2546: and ps.application_id = 101
2547: and ((ps.migration_status_code in ('P', 'U')) or

Line 2619: fa_lookups_tl lk,

2615: from fa_transaction_headers th,
2616: fa_deprn_periods dp,
2617: gl_sets_of_books glsob,
2618: fa_book_controls bc,
2619: fa_lookups_tl lk,
2620: gl_period_statuses ps
2621: where th.rowid between p_start_rowid and p_end_rowid
2622: and ps.application_id = 101
2623: and ((ps.migration_status_code in ('P', 'U')) or

Line 2696: fa_lookups_tl lk,

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
2700: where bc.book_type_code = l_book_type_code

Line 2756: fa_lookups_tl lk,

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,
2758: fa_deprn_detail dd,
2759: gl_je_lines gljl,
2760: fa_distribution_accounts da,

Line 2831: fa_lookups_tl lk,

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,
2833: fa_deprn_detail dd,
2834: gl_je_lines gljl,
2835: fa_distribution_accounts da,

Line 2913: fa_lookups_tl lk,

2909: adj.je_header_id,
2910: nvl(adj.je_line_num, 0),
2911: adj.distribution_id
2912: from fa_mc_adjustments adj,
2913: fa_lookups_tl lk,
2914: gl_je_headers gljh,
2915: fa_mc_book_controls bc,
2916: gl_sets_of_books glsob
2917: where bc.book_type_code = l_book_type_code

Line 2976: fa_lookups_tl lk,

2972: adj.distribution_id
2973: from fa_mc_adjustments adj,
2974: gl_sets_of_books glsob,
2975: fa_mc_book_controls bc,
2976: fa_lookups_tl lk,
2977: gl_je_headers gljh,
2978: fa_mc_deprn_detail dd,
2979: gl_je_lines gljl,
2980: fa_distribution_accounts da,

Line 3055: fa_lookups_tl lk,

3051: adj.distribution_id
3052: from fa_mc_adjustments adj,
3053: gl_sets_of_books glsob,
3054: fa_mc_book_controls bc,
3055: fa_lookups_tl lk,
3056: gl_je_headers gljh,
3057: fa_mc_deprn_detail dd,
3058: gl_je_lines gljl,
3059: fa_distribution_accounts da,

Line 4184: from fa_lookups

4180:
4181: -- Save value into a variable
4182: select description
4183: into l_bonus_deprn_rsv_desc
4184: from fa_lookups
4185: where lookup_type = 'JOURNAL ENTRIES'
4186: and lookup_code = 'BONUS DEPRECIATION RESERVE';
4187:
4188: insert all

Line 4538: fa_lookups_tl lk,

4534: from fa_transaction_headers th,
4535: fa_book_controls bc,
4536: fa_deprn_periods dp,
4537: gl_period_statuses ps,
4538: fa_lookups_tl lk,
4539: fa_asset_history ah
4540: where th.rowid between p_start_rowid and p_end_rowid
4541: and th.member_transaction_header_id is null
4542: and th.event_id is null

Line 4620: fa_lookups_tl lk

4616: from fa_transaction_headers th,
4617: fa_book_controls bc,
4618: fa_deprn_periods dp,
4619: gl_period_statuses ps,
4620: fa_lookups_tl lk
4621: where th.rowid between p_start_rowid and p_end_rowid
4622: and th.member_transaction_header_id is null
4623: and th.event_id is null
4624: and ps.application_id = 101

Line 5379: fa_lookups_tl lk,

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,
5383: gl_je_headers gljh2,

Line 5380: fa_lookups_tl lk2,

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,
5383: gl_je_headers gljh2,
5384: gl_je_lines gljl2,

Line 6298: fa_lookups_tl lk,

6294: from
6295: fa_xla_upg_events_gt ev,
6296: fa_xla_upg_headers_gt he,
6297: fa_mc_adjustments adj,
6298: fa_lookups_tl lk,
6299: fa_lookups_tl lk2,
6300: gl_je_headers gljh,
6301: fa_mc_deprn_detail dd,
6302: gl_je_headers gljh2,

Line 6299: fa_lookups_tl lk2,

6295: fa_xla_upg_events_gt ev,
6296: fa_xla_upg_headers_gt he,
6297: fa_mc_adjustments adj,
6298: fa_lookups_tl lk,
6299: fa_lookups_tl lk2,
6300: gl_je_headers gljh,
6301: fa_mc_deprn_detail dd,
6302: gl_je_headers gljh2,
6303: gl_je_lines gljl2,

Line 6447: from fa_lookups_tl lk_de

6443: from dual;
6444:
6445: select lk_de.description
6446: into l_de_description
6447: from fa_lookups_tl lk_de
6448: where lk_de.lookup_type = 'JOURNAL ENTRIES'
6449: and lk_de.lookup_code = 'DEPRECIATION EXPENSE'
6450: and userenv('LANG') = lk_de.language;
6451:

Line 6454: from fa_lookups_tl lk_dr

6450: and userenv('LANG') = lk_de.language;
6451:
6452: select lk_dr.description
6453: into l_dr_description
6454: from fa_lookups_tl lk_dr
6455: where lk_dr.lookup_type = 'JOURNAL ENTRIES'
6456: and lk_dr.lookup_code = 'DEPRECIATION RESERVE'
6457: and userenv('LANG') = lk_dr.language;
6458:

Line 6461: from fa_lookups_tl lk_be

6457: and userenv('LANG') = lk_dr.language;
6458:
6459: select lk_be.description
6460: into l_be_description
6461: from fa_lookups_tl lk_be
6462: where lk_be.lookup_type = 'JOURNAL ENTRIES'
6463: and lk_be.lookup_code = 'BONUS DEPRECIATION EXPENSE'
6464: and userenv('LANG') = lk_be.language;
6465:

Line 6468: from fa_lookups_tl lk_br

6464: and userenv('LANG') = lk_be.language;
6465:
6466: select lk_br.description
6467: into l_br_description
6468: from fa_lookups_tl lk_br
6469: where lk_br.lookup_type = 'JOURNAL ENTRIES'
6470: and lk_br.lookup_code = 'BONUS DEPRECIATION RESERVE'
6471: and userenv('LANG') = lk_br.language;
6472:

Line 6475: from fa_lookups_tl lk_ra

6471: and userenv('LANG') = lk_br.language;
6472:
6473: select lk_ra.description
6474: into l_ra_description
6475: from fa_lookups_tl lk_ra
6476: where lk_ra.lookup_type = 'JOURNAL ENTRIES'
6477: and lk_ra.lookup_code = 'DEPRECIATION REVAL AMORT'
6478: and userenv('LANG') = lk_ra.language;
6479:

Line 6482: from fa_lookups_tl lk_rr

6478: and userenv('LANG') = lk_ra.language;
6479:
6480: select lk_rr.description
6481: into l_rr_description
6482: from fa_lookups_tl lk_rr
6483: where lk_rr.lookup_type = 'JOURNAL ENTRIES'
6484: and lk_rr.lookup_code = 'DEPRECIATION REVAL RESERVE'
6485: and userenv('LANG') = lk_rr.language;
6486:

Line 8231: fa_lookups_tl lk_de,

8227: from fa_deferred_deprn df,
8228: fa_deprn_periods dp,
8229: gl_sets_of_books glsob,
8230: fa_book_controls bc,
8231: fa_lookups_tl lk_de,
8232: fa_lookups_tl lk_dr,
8233: gl_je_headers gljh,
8234: gl_period_statuses ps
8235: where df.rowid between p_start_rowid and p_end_rowid

Line 8232: fa_lookups_tl lk_dr,

8228: fa_deprn_periods dp,
8229: gl_sets_of_books glsob,
8230: fa_book_controls bc,
8231: fa_lookups_tl lk_de,
8232: fa_lookups_tl lk_dr,
8233: gl_je_headers gljh,
8234: gl_period_statuses ps
8235: where df.rowid between p_start_rowid and p_end_rowid
8236: and df.corp_book_type_code = bc.book_type_code

Line 8274: fa_lookups_tl lk_de,

8270: gljh.je_batch_id,
8271: df.je_header_id,
8272: decode (df.je_header_id, null, 'N', 'Y')
8273: from fa_deferred_deprn df,
8274: fa_lookups_tl lk_de,
8275: fa_lookups_tl lk_dr,
8276: gl_je_headers gljh
8277: where df.corp_book_type_code = l_corp_book_type_code
8278: and df.tax_book_type_code = l_tax_book_type_code

Line 8275: fa_lookups_tl lk_dr,

8271: df.je_header_id,
8272: decode (df.je_header_id, null, 'N', 'Y')
8273: from fa_deferred_deprn df,
8274: fa_lookups_tl lk_de,
8275: fa_lookups_tl lk_dr,
8276: gl_je_headers gljh
8277: where df.corp_book_type_code = l_corp_book_type_code
8278: and df.tax_book_type_code = l_tax_book_type_code
8279: and df.asset_id = l_asset_id

Line 8316: fa_lookups_tl lk_de,

8312: df.je_header_id,
8313: decode (df.je_header_id, null, 'N', 'Y'),
8314: glsob.currency_code
8315: from fa_mc_deferred_deprn df,
8316: fa_lookups_tl lk_de,
8317: fa_lookups_tl lk_dr,
8318: gl_je_headers gljh,
8319: gl_sets_of_books glsob
8320: where df.corp_book_type_code = l_corp_book_type_code

Line 8317: fa_lookups_tl lk_dr,

8313: decode (df.je_header_id, null, 'N', 'Y'),
8314: glsob.currency_code
8315: from fa_mc_deferred_deprn df,
8316: fa_lookups_tl lk_de,
8317: fa_lookups_tl lk_dr,
8318: gl_je_headers gljh,
8319: gl_sets_of_books glsob
8320: where df.corp_book_type_code = l_corp_book_type_code
8321: and df.tax_book_type_code = l_tax_book_type_code