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
320: and adj.asset_id = l_asset_id
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
399: and adj.asset_id = l_asset_id
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
557: and bc.enabled_flag = 'Y'
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
642: and bc.enabled_flag = 'Y'
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
2840: and adj.asset_id = l_asset_id
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
2918: and adj.asset_id = l_asset_id
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
3074: and bc.enabled_flag = 'Y'
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
3158: and bc.enabled_flag = 'Y'
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,
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
5533: union all
6360: null, -- subledger_doc_seq_value
6361: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6362: 'XLAJEL' -- gl_sl_link_table
6363: )
6364: select /*+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
6365: adj.adjustment_line_id adj_line_id,
6366: decode(adj.debit_credit_flag,
6367: 'DR', adj.adjustment_amount, null) debit_amount,
6368: decode(adj.debit_credit_flag,
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
6452: union all
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
6843: and dp.book_type_code = ds.book_type_code
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
7191: and bc.set_of_books_id = glsob.set_of_books_id