[Home] [Help]
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
238: where bc.book_type_code = l_book_type_code
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,
296: fa_deprn_detail dd,
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,
371: fa_deprn_detail dd,
447: adj.je_header_id,
448: nvl(adj.je_line_num, 0),
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
508: dd.je_header_id,
509: nvl(dd.deprn_reserve_je_line_num, 0),
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,
587: dd.je_header_id,
588: nvl(dd.deprn_reserve_je_line_num, 0),
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,
2537: th.date_effective
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
2613: 'OTHER') je_category_name,
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
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
2703: and adj.asset_id = l_asset_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,
2758: fa_deprn_detail dd,
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,
2833: fa_deprn_detail dd,
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
2918: and bc.set_of_books_id = l_set_of_books_id
2919: and bc.enabled_flag = 'Y'
2920: and bc.set_of_books_id = glsob.set_of_books_id
2970: dd.je_header_id,
2971: nvl(dd.deprn_reserve_je_line_num, 0),
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,
3049: dd.je_header_id,
3050: nvl(dd.deprn_reserve_je_line_num, 0),
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,
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,
5391: (select 1 adj_row from dual
6302: gl_je_headers gljh2,
6303: gl_je_lines gljl2,
6304: gl_je_lines gljl3,
6305: fa_mc_book_controls bc,
6306: gl_sets_of_books glsob,
6307: fa_distribution_accounts da,
6308: fa_asset_history ah,
6309: fa_category_books cb,
6310: (select 1 adj_row from dual
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
6812: where ds.rowid between p_start_rowid and p_end_rowid
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,
7146: gl_period_statuses ps
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
7565: and bc.set_of_books_id = glsob.set_of_books_id
8073: gl_je_lines jl_ra,
8074: gl_je_lines jl_rr,
8075: gl_je_headers gljh,
8076: fa_mc_book_controls bc,
8077: gl_sets_of_books glsob,
8078: gl_row_multipliers mult
8079: where ev.event_id = he.event_id
8080: and bc.book_type_code = ev.ds_book_type_code
8081: and bc.set_of_books_id = glsob.set_of_books_id
8225: glsob.currency_code,
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,
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
8322: and df.asset_id = l_asset_id
8323: and df.set_of_books_id = l_set_of_books_id