[Home] [Help]
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,
316: fa_category_books cb
317: where bc.book_type_code = l_book_type_code
318: and bc.set_of_books_id = glsob.set_of_books_id
319: and bc.book_type_code = adj.book_type_code
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,
395: fa_category_books cb
396: where bc.book_type_code = l_book_type_code
397: and bc.set_of_books_id = glsob.set_of_books_id
398: and bc.book_type_code = adj.book_type_code
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,
553: fa_category_books cb
554: where bc.book_type_code = l_book_type_code
555: and bc.set_of_books_id = l_set_of_books_id
556: and bcp.book_type_code = l_book_type_code
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,
638: fa_category_books cb
639: where bc.book_type_code = l_book_type_code
640: and bc.set_of_books_id = l_set_of_books_id
641: and bcp.book_type_code = l_book_type_code
2601: 'TAX', bc.je_deprn_adjustment_category
2602: ), 'OTHER') je_category_name,
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,
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,
2836: fa_category_books cb
2837: where bc.book_type_code = l_book_type_code
2838: and bc.set_of_books_id = glsob.set_of_books_id
2839: and bc.book_type_code = adj.book_type_code
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,
2914: fa_category_books cb
2915: where bc.book_type_code = l_book_type_code
2916: and bc.set_of_books_id = glsob.set_of_books_id
2917: and bc.book_type_code = adj.book_type_code
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,
3070: fa_category_books cb
3071: where bc.book_type_code = l_book_type_code
3072: and bc.set_of_books_id = l_set_of_books_id
3073: and bcp.book_type_code = l_book_type_code
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,
3154: fa_category_books cb
3155: where bc.book_type_code = l_book_type_code
3156: and bc.set_of_books_id = l_set_of_books_id
3157: and bcp.book_type_code = l_book_type_code
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,
4656: fa_additions_b ad
4657: where th.rowid between p_start_rowid and p_end_rowid
4658: and th.member_transaction_header_id is null
4659: and (th.event_id is null or th.event_id in (-2,-3)) -- Bug 6811554
5441: null, -- subledger_doc_seq_value
5442: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5443: 'XLAJEL' -- gl_sl_link_table
5444: )
5445: -- Bug 7498880: Added hint to use FA_ASSET_HISTORY_N2 index
5446: select /*+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) index(AH FA_ASSET_HISTORY_N2)*/
5447: adj.adjustment_line_id adj_line_id,
5448: decode(adj.debit_credit_flag,
5449: 'DR', adj.adjustment_amount, null) debit_amount,
5442: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5443: 'XLAJEL' -- gl_sl_link_table
5444: )
5445: -- Bug 7498880: Added hint to use FA_ASSET_HISTORY_N2 index
5446: select /*+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) index(AH FA_ASSET_HISTORY_N2)*/
5447: adj.adjustment_line_id adj_line_id,
5448: decode(adj.debit_credit_flag,
5449: 'DR', adj.adjustment_amount, null) debit_amount,
5450: decode(adj.debit_credit_flag,
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
5531: union all
5532: select 2 adj_row from dual
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
6450: union all
6451: select 2 adj_row from dual
6809: c_application_id, -- upg_source_application_id
6810: transaction_date_entered
6811: -- transaction_date
6812: )
6813: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
6814: ds.asset_id asset_id,
6815: ds.book_type_code book_type_code,
6816: bc.set_of_books_id set_of_books_id,
6817: ds.deprn_run_date transaction_date_entered,
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
6841: and ds.book_type_code = bc.book_type_code
6842: and bc.set_of_books_id = glsob.set_of_books_id
7150: null, -- product_rule_version
7151: c_application_id, -- upg_source_application_id
7152: null -- upg_valid_flag
7153: )
7154: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
7155: ds.asset_id asset_id,
7156: ds.book_type_code book_type_code,
7157: bc.set_of_books_id set_of_books_id,
7158: ds.deprn_run_date transaction_date_entered,
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
7189: where ds.rowid between p_start_rowid and p_end_rowid
7190: and ds.book_type_code = bc.book_type_code