[Home] [Help]
242: adj.je_header_id,
243: nvl(adj.je_line_num, 0),
244: adj.distribution_id
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
304: dd.je_header_id,
305: nvl(dd.deprn_reserve_je_line_num, 0),
306: adj.distribution_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,
383: dd.je_header_id,
384: nvl(dd.deprn_reserve_je_line_num, 0),
385: adj.distribution_id
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,
473: adj.je_header_id,
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
540: dd.je_header_id,
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,
625: dd.je_header_id,
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,
2603: th.date_effective
2604: from fa_transaction_headers th,
2605: fa_asset_history ah,
2606: fa_deprn_periods dp,
2607: gl_sets_of_books glsob,
2608: fa_book_controls bc,
2609: fa_lookups_tl lk,
2610: gl_period_statuses ps
2611: where th.rowid between p_start_rowid and p_end_rowid
2679: 'OTHER') je_category_name,
2680: th.date_effective
2681: from fa_transaction_headers th,
2682: fa_deprn_periods dp,
2683: gl_sets_of_books glsob,
2684: fa_book_controls bc,
2685: fa_lookups_tl lk,
2686: gl_period_statuses ps
2687: where th.rowid between p_start_rowid and p_end_rowid
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
2773: and bc.book_type_code = adj.book_type_code
2774: and adj.asset_id = l_asset_id
2824: dd.je_header_id,
2825: nvl(dd.deprn_reserve_je_line_num, 0),
2826: adj.distribution_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,
2902: dd.je_header_id,
2903: nvl(dd.deprn_reserve_je_line_num, 0),
2904: adj.distribution_id
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,
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
3002: and bcp.book_type_code = l_book_type_code
3003: and bc.enabled_flag = 'Y'
3057: dd.je_header_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,
3141: dd.je_header_id,
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,
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,
5527: fa_distribution_accounts da,
5528: fa_asset_history ah,
5529: fa_category_books cb,
5530: (select 1 adj_row from dual
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,
6449: (select 1 adj_row from dual
6832: nvl(bc.je_depreciation_category, 'OTHER')
6833: je_category_name
6834: from fa_deprn_summary ds,
6835: fa_book_controls bc,
6836: gl_sets_of_books glsob,
6837: fa_deprn_periods dp,
6838: fa_asset_history ah,
6839: fa_category_books cb
6840: where ds.rowid between p_start_rowid and p_end_rowid
7180: and nvl(dd.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
7181: bc.gl_posting_allowed_flag gl_posting_allowed_flag
7182: from fa_deprn_summary ds,
7183: fa_book_controls bc,
7184: gl_sets_of_books glsob,
7185: fa_deprn_periods dp,
7186: fa_asset_history ah,
7187: fa_category_books cb,
7188: gl_period_statuses ps
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
7638: and bc.book_type_code = ev.ds_book_type_code
7639: and bc.set_of_books_id = glsob.set_of_books_id
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
8161: and bc.set_of_books_id = glsob.set_of_books_id
8305: glsob.currency_code,
8306: nvl (bc.je_deferred_deprn_category, 'OTHER') je_category_name
8307: from fa_deferred_deprn df,
8308: fa_deprn_periods dp,
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,
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
8403: and df.set_of_books_id = l_set_of_books_id