[Home] [Help]
295: gl_je_headers gljh,
296: fa_deprn_detail dd,
297: gl_je_lines gljl,
298: fa_distribution_accounts da,
299: fa_asset_history ah,
300: fa_category_books cb
301: where bc.book_type_code = l_book_type_code
302: and bc.set_of_books_id = glsob.set_of_books_id
303: and bc.book_type_code = adj.book_type_code
370: gl_je_headers gljh,
371: fa_deprn_detail dd,
372: gl_je_lines gljl,
373: fa_distribution_accounts da,
374: fa_asset_history ah,
375: fa_category_books cb
376: where bc.book_type_code = l_book_type_code
377: and bc.set_of_books_id = glsob.set_of_books_id
378: and bc.book_type_code = adj.book_type_code
515: gl_je_headers gljh,
516: fa_mc_deprn_detail dd,
517: gl_je_lines gljl,
518: fa_distribution_accounts da,
519: fa_asset_history ah,
520: fa_category_books cb
521: where bc.book_type_code = l_book_type_code
522: and bc.set_of_books_id = l_set_of_books_id
523: and bc.enabled_flag = 'Y'
594: gl_je_headers gljh,
595: fa_mc_deprn_detail dd,
596: gl_je_lines gljl,
597: fa_distribution_accounts da,
598: fa_asset_history ah,
599: fa_category_books cb
600: where bc.book_type_code = l_book_type_code
601: and bc.set_of_books_id = l_set_of_books_id
602: and bc.enabled_flag = 'Y'
2535: 'TAX', bc.je_deprn_adjustment_category
2536: ), 'OTHER') je_category_name,
2537: th.date_effective
2538: from fa_transaction_headers th,
2539: fa_asset_history ah,
2540: fa_deprn_periods dp,
2541: gl_sets_of_books glsob,
2542: fa_book_controls bc,
2543: fa_lookups_tl lk,
2757: gl_je_headers gljh,
2758: fa_deprn_detail dd,
2759: gl_je_lines gljl,
2760: fa_distribution_accounts da,
2761: fa_asset_history ah,
2762: fa_category_books cb
2763: where bc.book_type_code = l_book_type_code
2764: and bc.set_of_books_id = glsob.set_of_books_id
2765: and bc.book_type_code = adj.book_type_code
2832: gl_je_headers gljh,
2833: fa_deprn_detail dd,
2834: gl_je_lines gljl,
2835: fa_distribution_accounts da,
2836: fa_asset_history ah,
2837: fa_category_books cb
2838: where bc.book_type_code = l_book_type_code
2839: and bc.set_of_books_id = glsob.set_of_books_id
2840: and bc.book_type_code = adj.book_type_code
2977: gl_je_headers gljh,
2978: fa_mc_deprn_detail dd,
2979: gl_je_lines gljl,
2980: fa_distribution_accounts da,
2981: fa_asset_history ah,
2982: fa_category_books cb
2983: where bc.book_type_code = l_book_type_code
2984: and bc.set_of_books_id = l_set_of_books_id
2985: and bc.enabled_flag = 'Y'
3056: gl_je_headers gljh,
3057: fa_mc_deprn_detail dd,
3058: gl_je_lines gljl,
3059: fa_distribution_accounts da,
3060: fa_asset_history ah,
3061: fa_category_books cb
3062: where bc.book_type_code = l_book_type_code
3063: and bc.set_of_books_id = l_set_of_books_id
3064: and bc.enabled_flag = 'Y'
4535: fa_book_controls bc,
4536: fa_deprn_periods dp,
4537: gl_period_statuses ps,
4538: fa_lookups_tl lk,
4539: fa_asset_history ah
4540: where th.rowid between p_start_rowid and p_end_rowid
4541: and th.member_transaction_header_id is null
4542: and th.event_id is null
4543: and ps.application_id = 101
5385: gl_je_lines gljl3,
5386: fa_book_controls bc,
5387: gl_sets_of_books glsob,
5388: fa_distribution_accounts da,
5389: fa_asset_history ah,
5390: fa_category_books cb,
5391: (select 1 adj_row from dual
5392: union all
5393: select 2 adj_row from dual
6304: gl_je_lines gljl3,
6305: fa_mc_book_controls bc,
6306: gl_sets_of_books glsob,
6307: fa_distribution_accounts da,
6308: fa_asset_history ah,
6309: fa_category_books cb,
6310: (select 1 adj_row from dual
6311: union all
6312: select 2 adj_row from dual
6781: null, -- product_rule_version
6782: c_application_id, -- upg_source_application_id
6783: null -- upg_valid_flag
6784: )
6785: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
6786: ds.asset_id asset_id,
6787: ds.book_type_code book_type_code,
6788: bc.set_of_books_id set_of_books_id,
6789: ds.deprn_run_date transaction_date_entered,
6806: from fa_deprn_summary ds,
6807: fa_book_controls bc,
6808: gl_sets_of_books glsob,
6809: fa_deprn_periods dp,
6810: fa_asset_history ah,
6811: fa_category_books cb
6812: where ds.rowid between p_start_rowid and p_end_rowid
6813: and ds.book_type_code = bc.book_type_code
6814: and bc.set_of_books_id = glsob.set_of_books_id
7115: null, -- product_rule_version
7116: c_application_id, -- upg_source_application_id
7117: null -- upg_valid_flag
7118: )
7119: select /*+ ordered leading(dp) index(dp fa_deprn_periods_u3) rowid(ds) index(ah fa_asset_history_n2) */
7120: ds.asset_id asset_id,
7121: ds.book_type_code book_type_code,
7122: bc.set_of_books_id set_of_books_id,
7123: ds.deprn_run_date transaction_date_entered,
7140: from fa_deprn_summary ds,
7141: fa_book_controls bc,
7142: gl_sets_of_books glsob,
7143: fa_deprn_periods dp,
7144: fa_asset_history ah,
7145: fa_category_books cb,
7146: gl_period_statuses ps
7147: where ds.rowid between p_start_rowid and p_end_rowid
7148: and ds.book_type_code = bc.book_type_code