[Home] [Help]
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
253: and adj.asset_id = l_asset_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,
315: fa_asset_history ah,
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,
394: fa_asset_history ah,
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
485: and bc.enabled_flag = 'Y'
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,
552: fa_asset_history ah,
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,
637: fa_asset_history ah,
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
2772: and bc.set_of_books_id = glsob.set_of_books_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,
2835: fa_asset_history ah,
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,
2913: fa_asset_history ah,
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
3000: where bc.book_type_code = l_book_type_code
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,
3069: fa_asset_history ah,
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,
3153: fa_asset_history ah,
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,
5524: gl_je_lines gljl3,
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,
5524: gl_je_lines gljl3,
5525: fa_book_controls bc,
5526: gl_sets_of_books glsob,
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,
6443: gl_je_lines gljl3,
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,
6443: gl_je_lines gljl3,
6444: fa_mc_book_controls bc,
6445: gl_sets_of_books glsob,
7629: gl_je_lines jl_be,
7630: gl_je_lines jl_br,
7631: gl_je_lines jl_ra,
7632: gl_je_lines jl_rr,
7633: gl_je_headers gljh,
7634: fa_book_controls bc,
7635: gl_sets_of_books glsob,
7636: gl_row_multipliers mult
7637: where ev.event_id = he.event_id
8151: gl_je_lines jl_be,
8152: gl_je_lines jl_br,
8153: gl_je_lines jl_ra,
8154: gl_je_lines jl_rr,
8155: gl_je_headers gljh,
8156: fa_mc_book_controls bc,
8157: gl_sets_of_books glsob,
8158: gl_row_multipliers mult
8159: where ev.event_id = he.event_id
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
8317: and bc.set_of_books_id = glsob.set_of_books_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
8360: and df.corp_period_counter = l_corp_period_counter
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
8402: and df.asset_id = l_asset_id