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_TL

Line 147: fa_lookups_tl lk1,

143: fa_transaction_headers th2,
144: fa_book_controls bc,
145: fa_deprn_periods dp,
146: fa_trx_references tr,
147: fa_lookups_tl lk1,
148: fa_lookups_tl lk2,
149: gl_period_statuses ps
150: where tr.rowid between p_start_rowid and p_end_rowid
151: and ps.application_id = 101

Line 148: fa_lookups_tl lk2,

144: fa_book_controls bc,
145: fa_deprn_periods dp,
146: fa_trx_references tr,
147: fa_lookups_tl lk1,
148: fa_lookups_tl lk2,
149: gl_period_statuses ps
150: where tr.rowid between p_start_rowid and p_end_rowid
151: and ps.application_id = 101
152: and ((ps.migration_status_code in ('P', 'U')) or

Line 248: fa_lookups_tl lk,

244: adj.distribution_id
245: from fa_adjustments adj,
246: gl_sets_of_books glsob,
247: fa_book_controls bc,
248: fa_lookups_tl lk,
249: gl_je_headers gljh
250: where bc.book_type_code = l_book_type_code
251: and bc.set_of_books_id = glsob.set_of_books_id
252: and bc.book_type_code = adj.book_type_code

Line 310: fa_lookups_tl lk,

306: adj.distribution_id
307: from fa_adjustments adj,
308: gl_sets_of_books glsob,
309: fa_book_controls bc,
310: fa_lookups_tl lk,
311: gl_je_headers gljh,
312: fa_deprn_detail dd,
313: gl_je_lines gljl,
314: fa_distribution_accounts da,

Line 389: fa_lookups_tl lk,

385: adj.distribution_id
386: from fa_adjustments adj,
387: gl_sets_of_books glsob,
388: fa_book_controls bc,
389: fa_lookups_tl lk,
390: gl_je_headers gljh,
391: fa_deprn_detail dd,
392: gl_je_lines gljl,
393: fa_distribution_accounts da,

Line 480: fa_lookups_tl lk,

476: from fa_mc_adjustments adj,
477: gl_sets_of_books glsob,
478: fa_mc_book_controls bc,
479: fa_book_controls bcp,
480: fa_lookups_tl lk,
481: gl_je_headers gljh
482: where bc.book_type_code = l_book_type_code
483: and bc.set_of_books_id = l_set_of_books_id
484: and bcp.book_type_code = l_book_type_code

Line 547: fa_lookups_tl lk,

543: from fa_mc_adjustments adj,
544: gl_sets_of_books glsob,
545: fa_mc_book_controls bc,
546: fa_book_controls bcp,
547: fa_lookups_tl lk,
548: gl_je_headers gljh,
549: fa_mc_deprn_detail dd,
550: gl_je_lines gljl,
551: fa_distribution_accounts da,

Line 632: fa_lookups_tl lk,

628: from fa_mc_adjustments adj,
629: gl_sets_of_books glsob,
630: fa_mc_book_controls bc,
631: fa_book_controls bcp,
632: fa_lookups_tl lk,
633: gl_je_headers gljh,
634: fa_mc_deprn_detail dd,
635: gl_je_lines gljl,
636: fa_distribution_accounts da,

Line 2609: fa_lookups_tl lk,

2605: fa_asset_history ah,
2606: fa_deprn_periods dp,
2607: gl_sets_of_books glsob,
2608: fa_book_controls bc,
2609: fa_lookups_tl lk,
2610: gl_period_statuses ps
2611: where th.rowid between p_start_rowid and p_end_rowid
2612: and ps.application_id = 101
2613: and ((ps.migration_status_code in ('P', 'U')) or

Line 2685: fa_lookups_tl lk,

2681: from fa_transaction_headers th,
2682: fa_deprn_periods dp,
2683: gl_sets_of_books glsob,
2684: fa_book_controls bc,
2685: fa_lookups_tl lk,
2686: gl_period_statuses ps
2687: where th.rowid between p_start_rowid and p_end_rowid
2688: and ps.application_id = 101
2689: and ((ps.migration_status_code in ('P', 'U')) or

Line 2767: fa_lookups_tl lk,

2763: adj.je_header_id,
2764: nvl(adj.je_line_num, 0),
2765: adj.distribution_id
2766: from fa_adjustments adj,
2767: fa_lookups_tl lk,
2768: gl_je_headers gljh,
2769: fa_book_controls bc,
2770: gl_sets_of_books glsob
2771: where bc.book_type_code = l_book_type_code

Line 2830: fa_lookups_tl lk,

2826: adj.distribution_id
2827: from fa_adjustments adj,
2828: gl_sets_of_books glsob,
2829: fa_book_controls bc,
2830: fa_lookups_tl lk,
2831: gl_je_headers gljh,
2832: fa_deprn_detail dd,
2833: gl_je_lines gljl,
2834: fa_distribution_accounts da,

Line 2908: fa_lookups_tl lk,

2904: adj.distribution_id
2905: from fa_adjustments adj,
2906: gl_sets_of_books glsob,
2907: fa_book_controls bc,
2908: fa_lookups_tl lk,
2909: gl_je_headers gljh,
2910: fa_deprn_detail dd,
2911: gl_je_lines gljl,
2912: fa_distribution_accounts da,

Line 2995: fa_lookups_tl lk,

2991: adj.je_header_id,
2992: nvl(adj.je_line_num, 0),
2993: adj.distribution_id
2994: from fa_mc_adjustments adj,
2995: fa_lookups_tl lk,
2996: gl_je_headers gljh,
2997: fa_mc_book_controls bc,
2998: fa_book_controls bcp,
2999: gl_sets_of_books glsob

Line 3064: fa_lookups_tl lk,

3060: from fa_mc_adjustments adj,
3061: gl_sets_of_books glsob,
3062: fa_mc_book_controls bc,
3063: fa_book_controls bcp,
3064: fa_lookups_tl lk,
3065: gl_je_headers gljh,
3066: fa_mc_deprn_detail dd,
3067: gl_je_lines gljl,
3068: fa_distribution_accounts da,

Line 3148: fa_lookups_tl lk,

3144: from fa_mc_adjustments adj,
3145: gl_sets_of_books glsob,
3146: fa_mc_book_controls bc,
3147: fa_book_controls bcp,
3148: fa_lookups_tl lk,
3149: gl_je_headers gljh,
3150: fa_mc_deprn_detail dd,
3151: gl_je_lines gljl,
3152: fa_distribution_accounts da,

Line 4654: fa_lookups_tl lk,

4650: from fa_transaction_headers th,
4651: fa_book_controls bc,
4652: fa_deprn_periods dp,
4653: gl_period_statuses ps,
4654: fa_lookups_tl lk,
4655: fa_asset_history ah,
4656: fa_additions_b ad
4657: where th.rowid between p_start_rowid and p_end_rowid
4658: and th.member_transaction_header_id is null

Line 4755: fa_lookups_tl lk,

4751: from fa_transaction_headers th,
4752: fa_book_controls bc,
4753: fa_deprn_periods dp,
4754: gl_period_statuses ps,
4755: fa_lookups_tl lk,
4756: fa_additions_b ad
4757: where th.rowid between p_start_rowid and p_end_rowid
4758: and th.member_transaction_header_id is null
4759: and (th.event_id is null or th.event_id in (-2,-3)) -- Bug 6811554

Line 5518: fa_lookups_tl lk,

5514: from
5515: fa_xla_upg_events_gt ev,
5516: fa_xla_upg_headers_gt he,
5517: fa_adjustments adj,
5518: fa_lookups_tl lk,
5519: fa_lookups_tl lk2,
5520: gl_je_headers gljh,
5521: fa_deprn_detail dd,
5522: gl_je_headers gljh2,

Line 5519: fa_lookups_tl lk2,

5515: fa_xla_upg_events_gt ev,
5516: fa_xla_upg_headers_gt he,
5517: fa_adjustments adj,
5518: fa_lookups_tl lk,
5519: fa_lookups_tl lk2,
5520: gl_je_headers gljh,
5521: fa_deprn_detail dd,
5522: gl_je_headers gljh2,
5523: gl_je_lines gljl2,

Line 6437: fa_lookups_tl lk,

6433: from
6434: fa_xla_upg_events_gt ev,
6435: fa_xla_upg_headers_gt he,
6436: fa_mc_adjustments adj,
6437: fa_lookups_tl lk,
6438: fa_lookups_tl lk2,
6439: gl_je_headers gljh,
6440: fa_mc_deprn_detail dd,
6441: gl_je_headers gljh2,

Line 6438: fa_lookups_tl lk2,

6434: fa_xla_upg_events_gt ev,
6435: fa_xla_upg_headers_gt he,
6436: fa_mc_adjustments adj,
6437: fa_lookups_tl lk,
6438: fa_lookups_tl lk2,
6439: gl_je_headers gljh,
6440: fa_mc_deprn_detail dd,
6441: gl_je_headers gljh2,
6442: gl_je_lines gljl2,

Line 6586: from fa_lookups_tl lk_de

6582: from dual;
6583:
6584: select lk_de.description
6585: into l_de_description
6586: from fa_lookups_tl lk_de
6587: where lk_de.lookup_type = 'JOURNAL ENTRIES'
6588: and lk_de.lookup_code = 'DEPRECIATION EXPENSE'
6589: and userenv('LANG') = lk_de.language;
6590:

Line 6593: from fa_lookups_tl lk_dr

6589: and userenv('LANG') = lk_de.language;
6590:
6591: select lk_dr.description
6592: into l_dr_description
6593: from fa_lookups_tl lk_dr
6594: where lk_dr.lookup_type = 'JOURNAL ENTRIES'
6595: and lk_dr.lookup_code = 'DEPRECIATION RESERVE'
6596: and userenv('LANG') = lk_dr.language;
6597:

Line 6600: from fa_lookups_tl lk_be

6596: and userenv('LANG') = lk_dr.language;
6597:
6598: select lk_be.description
6599: into l_be_description
6600: from fa_lookups_tl lk_be
6601: where lk_be.lookup_type = 'JOURNAL ENTRIES'
6602: and lk_be.lookup_code = 'BONUS DEPRECIATION EXPENSE'
6603: and userenv('LANG') = lk_be.language;
6604:

Line 6607: from fa_lookups_tl lk_br

6603: and userenv('LANG') = lk_be.language;
6604:
6605: select lk_br.description
6606: into l_br_description
6607: from fa_lookups_tl lk_br
6608: where lk_br.lookup_type = 'JOURNAL ENTRIES'
6609: and lk_br.lookup_code = 'BONUS DEPRECIATION RESERVE'
6610: and userenv('LANG') = lk_br.language;
6611:

Line 6614: from fa_lookups_tl lk_ra

6610: and userenv('LANG') = lk_br.language;
6611:
6612: select lk_ra.description
6613: into l_ra_description
6614: from fa_lookups_tl lk_ra
6615: where lk_ra.lookup_type = 'JOURNAL ENTRIES'
6616: and lk_ra.lookup_code = 'DEPRECIATION REVAL AMORT'
6617: and userenv('LANG') = lk_ra.language;
6618:

Line 6621: from fa_lookups_tl lk_rr

6617: and userenv('LANG') = lk_ra.language;
6618:
6619: select lk_rr.description
6620: into l_rr_description
6621: from fa_lookups_tl lk_rr
6622: where lk_rr.lookup_type = 'JOURNAL ENTRIES'
6623: and lk_rr.lookup_code = 'DEPRECIATION REVAL RESERVE'
6624: and userenv('LANG') = lk_rr.language;
6625:

Line 8311: fa_lookups_tl lk_de,

8307: from fa_deferred_deprn df,
8308: fa_deprn_periods dp,
8309: gl_sets_of_books glsob,
8310: fa_book_controls bc,
8311: fa_lookups_tl lk_de,
8312: fa_lookups_tl lk_dr,
8313: gl_je_headers gljh,
8314: gl_period_statuses ps
8315: where df.rowid between p_start_rowid and p_end_rowid

Line 8312: fa_lookups_tl lk_dr,

8308: fa_deprn_periods dp,
8309: gl_sets_of_books glsob,
8310: fa_book_controls bc,
8311: fa_lookups_tl lk_de,
8312: fa_lookups_tl lk_dr,
8313: gl_je_headers gljh,
8314: gl_period_statuses ps
8315: where df.rowid between p_start_rowid and p_end_rowid
8316: and df.corp_book_type_code = bc.book_type_code

Line 8354: fa_lookups_tl lk_de,

8350: gljh.je_batch_id,
8351: df.je_header_id,
8352: decode (df.je_header_id, null, 'N', 'Y')
8353: from fa_deferred_deprn df,
8354: fa_lookups_tl lk_de,
8355: fa_lookups_tl lk_dr,
8356: gl_je_headers gljh
8357: where df.corp_book_type_code = l_corp_book_type_code
8358: and df.tax_book_type_code = l_tax_book_type_code

Line 8355: fa_lookups_tl lk_dr,

8351: df.je_header_id,
8352: decode (df.je_header_id, null, 'N', 'Y')
8353: from fa_deferred_deprn df,
8354: fa_lookups_tl lk_de,
8355: fa_lookups_tl lk_dr,
8356: gl_je_headers gljh
8357: where df.corp_book_type_code = l_corp_book_type_code
8358: and df.tax_book_type_code = l_tax_book_type_code
8359: and df.asset_id = l_asset_id

Line 8396: fa_lookups_tl lk_de,

8392: df.je_header_id,
8393: decode (df.je_header_id, null, 'N', 'Y'),
8394: glsob.currency_code
8395: from fa_mc_deferred_deprn df,
8396: fa_lookups_tl lk_de,
8397: fa_lookups_tl lk_dr,
8398: gl_je_headers gljh,
8399: gl_sets_of_books glsob
8400: where df.corp_book_type_code = l_corp_book_type_code

Line 8397: fa_lookups_tl lk_dr,

8393: decode (df.je_header_id, null, 'N', 'Y'),
8394: glsob.currency_code
8395: from fa_mc_deferred_deprn df,
8396: fa_lookups_tl lk_de,
8397: fa_lookups_tl lk_dr,
8398: gl_je_headers gljh,
8399: gl_sets_of_books glsob
8400: where df.corp_book_type_code = l_corp_book_type_code
8401: and df.tax_book_type_code = l_tax_book_type_code