DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_BOOK_CONTROLS

Line 138: fa_book_controls bc,

134: ), 'OTHER') je_category_name,
135: th1.date_effective
136: from fa_transaction_headers th1,
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,

Line 235: fa_book_controls bc,

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

Line 293: fa_book_controls bc,

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

Line 368: fa_book_controls bc,

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

Line 2542: fa_book_controls bc,

2538: from fa_transaction_headers th,
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

Line 2618: fa_book_controls bc,

2614: th.date_effective
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

Line 2698: fa_book_controls bc,

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
2701: and bc.set_of_books_id = glsob.set_of_books_id
2702: and bc.book_type_code = adj.book_type_code

Line 2755: fa_book_controls bc,

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

Line 2830: fa_book_controls bc,

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

Line 4535: fa_book_controls bc,

4531: description,
4532: dp.period_counter period_counter,
4533: th.asset_id asset_id
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

Line 4617: fa_book_controls bc,

4613: description,
4614: dp.period_counter period_counter,
4615: th.asset_id asset_id
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

Line 5386: fa_book_controls bc,

5382: fa_deprn_detail dd,
5383: gl_je_headers gljh2,
5384: gl_je_lines gljl2,
5385: gl_je_lines gljl3,
5386: fa_book_controls bc,
5387: gl_sets_of_books glsob,
5388: fa_distribution_accounts da,
5389: fa_asset_history ah,
5390: fa_category_books cb,

Line 6807: fa_book_controls bc,

6803: default_reval_rsv_ccid,
6804: nvl(bc.je_depreciation_category, 'OTHER')
6805: je_category_name
6806: from fa_deprn_summary ds,
6807: fa_book_controls bc,
6808: gl_sets_of_books glsob,
6809: fa_deprn_periods dp,
6810: fa_asset_history ah,
6811: fa_category_books cb

Line 7141: fa_book_controls bc,

7137: default_reval_rsv_ccid,
7138: nvl(bc.je_depreciation_category, 'OTHER')
7139: je_category_name
7140: from fa_deprn_summary ds,
7141: fa_book_controls bc,
7142: gl_sets_of_books glsob,
7143: fa_deprn_periods dp,
7144: fa_asset_history ah,
7145: fa_category_books cb,

Line 7560: fa_book_controls bc,

7556: gl_je_lines jl_br,
7557: gl_je_lines jl_ra,
7558: gl_je_lines jl_rr,
7559: gl_je_headers gljh,
7560: fa_book_controls bc,
7561: gl_sets_of_books glsob,
7562: gl_row_multipliers mult
7563: where ev.event_id = he.event_id
7564: and bc.book_type_code = ev.ds_book_type_code

Line 8230: fa_book_controls bc,

8226: nvl (bc.je_deferred_deprn_category, 'OTHER') je_category_name
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