[Home] [Help]
421: and bc.book_type_code = cb.book_type_code;
422:
423: CURSOR c_mc_books (l_book_type_code varchar2) IS
424: select set_of_books_id
425: from fa_mc_book_controls
426: where book_type_code = l_book_type_code
427: and enabled_flag = 'Y';
428:
429: -- Bug 6827893 : Added outerjoin between DD and gljh
474: nvl(adj.je_line_num, 0),
475: adj.distribution_id
476: from fa_mc_adjustments adj,
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
541: nvl(dd.deprn_reserve_je_line_num, 0),
542: adj.distribution_id
543: from fa_mc_adjustments adj,
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,
626: nvl(dd.deprn_reserve_je_line_num, 0),
627: adj.distribution_id
628: from fa_mc_adjustments adj,
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,
2940: and bc.book_type_code = cb.book_type_code;
2941:
2942: CURSOR c_mc_books (l_book_type_code varchar2) IS
2943: select set_of_books_id
2944: from fa_mc_book_controls
2945: where book_type_code = l_book_type_code
2946: and enabled_flag = 'Y';
2947:
2948: -- Bug 6827893 : Added outerjoin between DD and gljh
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
3001: and bc.set_of_books_id = l_set_of_books_id
3058: nvl(dd.deprn_reserve_je_line_num, 0),
3059: adj.distribution_id
3060: from fa_mc_adjustments adj,
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,
3142: nvl(dd.deprn_reserve_je_line_num, 0),
3143: adj.distribution_id
3144: from fa_mc_adjustments adj,
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,
5585: (source_type_code = 'DEPRECIATION')));
5586:
5587: select count(*)
5588: into l_mc_books
5589: from fa_mc_book_controls
5590: where enabled_flag = 'Y'
5591: and rownum = 1;
5592:
5593: if (l_mc_books > 0) then
5712: faev.period_name period_name,
5713: faev.je_category_name je_category_name,
5714: faev.description description
5715: from fa_xla_upg_events_gt faev,
5716: fa_mc_book_controls mc
5717: where mc.book_type_code = faev.book_type_code
5718: and mc.enabled_flag = 'Y';
5719:
5720: insert all
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,
6446: fa_distribution_accounts da,
6447: fa_asset_history ah,
6448: fa_category_books cb,
6624: and userenv('LANG') = lk_rr.language;
6625:
6626: select count(*)
6627: into l_mc_books
6628: from fa_mc_book_controls
6629: where enabled_flag = 'Y'
6630: and rownum = 1;
6631:
6632: -- Bug 6811548 : Create events as U/U for downtime
7792: faev.period_name period_name,
7793: faev.je_category_name je_category_name,
7794: faev.description description
7795: from fa_xla_upg_events_gt faev,
7796: fa_mc_book_controls mc
7797: where mc.book_type_code = faev.ds_book_type_code
7798: and mc.enabled_flag = 'Y';
7799:
7800: end if; -- p_mode <> 'downtime'
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
8160: and bc.book_type_code = ev.ds_book_type_code
8368: and df.je_header_id = gljh.je_header_id (+);
8369:
8370: CURSOR c_mc_books (l_book_type_code varchar2) IS
8371: select set_of_books_id
8372: from fa_mc_book_controls
8373: where book_type_code = l_book_type_code
8374: and enabled_flag = 'Y';
8375:
8376: CURSOR c_mc_detail (l_corp_book_type_code varchar2,