[Home] [Help]
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
241: and adj.asset_id = l_asset_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,
299: fa_asset_history ah,
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,
374: fa_asset_history ah,
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'
458: and bc.set_of_books_id = glsob.set_of_books_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,
519: fa_asset_history ah,
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,
598: fa_asset_history ah,
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
2701: and bc.set_of_books_id = glsob.set_of_books_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,
2761: fa_asset_history ah,
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,
2836: fa_asset_history ah,
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
2918: and bc.set_of_books_id = l_set_of_books_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,
2981: fa_asset_history ah,
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,
3060: fa_asset_history ah,
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,
5385: gl_je_lines gljl3,
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,
5385: gl_je_lines gljl3,
5386: fa_book_controls bc,
5387: gl_sets_of_books glsob,
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,
6304: gl_je_lines gljl3,
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,
6304: gl_je_lines gljl3,
6305: fa_mc_book_controls bc,
6306: gl_sets_of_books glsob,
7555: gl_je_lines jl_be,
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
8071: gl_je_lines jl_be,
8072: gl_je_lines jl_br,
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
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
8237: and bc.set_of_books_id = glsob.set_of_books_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
8280: and df.corp_period_counter = l_corp_period_counter
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
8322: and df.asset_id = l_asset_id