[Home] [Help]
140: ), 'OTHER') je_category_name,
141: th1.date_effective
142: from fa_transaction_headers th1,
143: fa_transaction_headers th2,
144: fa_book_controls bc,
145: fa_deprn_periods dp,
146: fa_trx_references tr,
147: fa_lookups_tl lk1,
148: fa_lookups_tl lk2,
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
251: and bc.set_of_books_id = glsob.set_of_books_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,
313: gl_je_lines gljl,
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,
392: gl_je_lines gljl,
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
483: and bc.set_of_books_id = l_set_of_books_id
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,
550: gl_je_lines gljl,
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,
635: gl_je_lines gljl,
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
2612: and ps.application_id = 101
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
2688: and ps.application_id = 101
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
2773: and bc.book_type_code = adj.book_type_code
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,
2833: gl_je_lines gljl,
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,
2911: gl_je_lines gljl,
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
3002: and bcp.book_type_code = l_book_type_code
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,
3067: gl_je_lines gljl,
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,
3151: gl_je_lines gljl,
4647: and adj.transaction_header_id = th.transaction_header_id
4648: and nvl(adj.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
4649: bc.gl_posting_allowed_flag gl_posting_allowed_flag
4650: from fa_transaction_headers th,
4651: fa_book_controls bc,
4652: fa_deprn_periods dp,
4653: gl_period_statuses ps,
4654: fa_lookups_tl lk,
4655: fa_asset_history ah,
4748: and adj.transaction_header_id = th.transaction_header_id
4749: and nvl(adj.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
4750: bc.gl_posting_allowed_flag gl_posting_allowed_flag
4751: from fa_transaction_headers th,
4752: fa_book_controls bc,
4753: fa_deprn_periods dp,
4754: gl_period_statuses ps,
4755: fa_lookups_tl lk,
4756: fa_additions_b ad
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,
5527: fa_distribution_accounts da,
5528: fa_asset_history ah,
5529: fa_category_books cb,
6831: default_reval_rsv_ccid,
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
7179: and dd.period_counter = ds.period_counter
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,
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
7638: and bc.book_type_code = ev.ds_book_type_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,
8314: gl_period_statuses ps