[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
352: fa_mc_deprn_periods dp,
353: fa_mc_books bk,
354: fa_additions_b ad,
355: fa_category_books cb,
356: fa_book_controls bc,
357: fa_mc_book_controls mcbc
358: where th.rowid between p_start_rowid and p_end_rowid
359: and th.book_type_code = dp.book_type_code
360: and th.date_effective > dp.period_open_date
806: ds.ltd_production
807: from fa_transaction_headers th,
808: fa_books bks,
809: fa_additions_b ad,
810: fa_book_controls bc,
811: fa_category_books cb,
812: fa_deprn_summary ds,
813: fa_deprn_periods dp
814: where th.rowid between p_start_rowid and p_end_rowid
887: ds.ltd_production
888: from fa_transaction_headers th,
889: fa_mc_books bks,
890: fa_additions_b ad,
891: fa_book_controls bc,
892: fa_category_books cb,
893: fa_mc_book_controls mcbc,
894: fa_mc_deprn_summary ds,
895: fa_mc_deprn_periods dp
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_asset_invoices ai,
1758: fa_invoice_transactions it,
1790: adj.adjustment_type,
1791: adj.debit_credit_flag,
1792: adj.code_combination_id
1793: from fa_transaction_headers th,
1794: fa_book_controls bc,
1795: fa_deprn_periods dp,
1796: fa_adjustments adj,
1797: fa_distribution_history dh,
1798: (select 'SOURCE' source_dest_code from dual union all