[Home] [Help]
36: fa_deprn_periods dp,
37: fa_books bk,
38: fa_category_books cb,
39: fa_additions_b ad,
40: fa_book_controls bc
41: where th.rowid between p_start_rowid and p_end_rowid
42: and th.book_type_code = dp.book_type_code
43: and th.date_effective > dp.period_open_date
44: and dp.period_close_date is null
339: fa_mc_deprn_periods dp,
340: fa_mc_books bk,
341: fa_additions_b ad,
342: fa_category_books cb,
343: fa_book_controls bc,
344: fa_mc_book_controls mcbc
345: where th.rowid between p_start_rowid and p_end_rowid
346: and th.book_type_code = dp.book_type_code
347: and th.date_effective > dp.period_open_date
789: ds.ltd_production
790: from fa_transaction_headers th,
791: fa_books bks,
792: fa_additions_b ad,
793: fa_book_controls bc,
794: fa_category_books cb,
795: fa_deprn_summary ds,
796: fa_deprn_periods dp
797: where th.rowid between p_start_rowid and p_end_rowid
870: ds.ltd_production
871: from fa_transaction_headers th,
872: fa_mc_books bks,
873: fa_additions_b ad,
874: fa_book_controls bc,
875: fa_category_books cb,
876: fa_mc_book_controls mcbc,
877: fa_mc_deprn_summary ds,
878: fa_mc_deprn_periods dp
1710: adj.adjustment_type,
1711: adj.debit_credit_flag,
1712: adj.code_combination_id
1713: from fa_transaction_headers th,
1714: fa_book_controls bc,
1715: fa_deprn_periods dp,
1716: fa_adjustments adj,
1717: fa_asset_invoices ai,
1718: fa_invoice_transactions it,
1750: adj.adjustment_type,
1751: adj.debit_credit_flag,
1752: adj.code_combination_id
1753: from fa_transaction_headers th,
1754: fa_book_controls bc,
1755: fa_deprn_periods dp,
1756: fa_adjustments adj,
1757: fa_distribution_history dh,
1758: (select 'SOURCE' source_dest_code from dual union all