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_DEPRN_PERIODS

Line 145: fa_deprn_periods dp,

141: th1.date_effective
142: from fa_transaction_headers th1,
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

Line 2606: fa_deprn_periods dp,

2602: ), 'OTHER') je_category_name,
2603: th.date_effective
2604: from fa_transaction_headers th,
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

Line 2682: fa_deprn_periods dp,

2678: 'UNIT ADJUSTMENT', bc.je_transfer_category),
2679: 'OTHER') je_category_name,
2680: th.date_effective
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

Line 4652: fa_deprn_periods dp,

4648: and nvl(adj.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
4649: bc.gl_posting_allowed_flag gl_posting_allowed_flag
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

Line 4753: fa_deprn_periods dp,

4749: and nvl(adj.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
4750: bc.gl_posting_allowed_flag gl_posting_allowed_flag
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

Line 6813: select /+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) /

6809: c_application_id, -- upg_source_application_id
6810: transaction_date_entered
6811: -- transaction_date
6812: )
6813: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
6814: ds.asset_id asset_id,
6815: ds.book_type_code book_type_code,
6816: bc.set_of_books_id set_of_books_id,
6817: ds.deprn_run_date transaction_date_entered,

Line 6837: fa_deprn_periods dp,

6833: je_category_name
6834: from fa_deprn_summary ds,
6835: fa_book_controls bc,
6836: gl_sets_of_books glsob,
6837: fa_deprn_periods dp,
6838: fa_asset_history ah,
6839: fa_category_books cb
6840: where ds.rowid between p_start_rowid and p_end_rowid
6841: and ds.book_type_code = bc.book_type_code

Line 7154: select /+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) /

7150: null, -- product_rule_version
7151: c_application_id, -- upg_source_application_id
7152: null -- upg_valid_flag
7153: )
7154: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
7155: ds.asset_id asset_id,
7156: ds.book_type_code book_type_code,
7157: bc.set_of_books_id set_of_books_id,
7158: ds.deprn_run_date transaction_date_entered,

Line 7185: fa_deprn_periods dp,

7181: bc.gl_posting_allowed_flag gl_posting_allowed_flag
7182: from fa_deprn_summary ds,
7183: fa_book_controls bc,
7184: gl_sets_of_books glsob,
7185: fa_deprn_periods dp,
7186: fa_asset_history ah,
7187: fa_category_books cb,
7188: gl_period_statuses ps
7189: where ds.rowid between p_start_rowid and p_end_rowid

Line 8308: fa_deprn_periods dp,

8304: df.tax_period_counter,
8305: glsob.currency_code,
8306: nvl (bc.je_deferred_deprn_category, 'OTHER') je_category_name
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,