SELECT DISTINCT
fma.book_type_code,
fma.posting_status,
fma.description,
fcb.segmnet1 major_category,
fcb.segment2 minor_category,
fma.fixed_assets_units,
fma.fixed_assets_cost,
(select segment3
from fa_locations
where location_id=fma.location_id) location,
fma.date_placed_in_service,
fma.asset_number,
fma.asset_key_segment1,
fma.asset_key_segment2,
invoice_number,
po_number,
vendor_number,
queue_name,
invoice_date,
payables_cost,
depreciate_flag,
asset_type,
fma.deprn_reserve,
ytd_deprn,
salvage_value,
fma.owned_leased,
deprn_method_code,
life_in_months,
prorate_convention_code,
(select segment1
from gl_code_combinations
where code_combination_id=payables_code_combination_id) company,
(select segment7
from gl_code_combinations
where code_combination_id=payables_code_combination_id) account,
(select segment3
from gl_code_combinations
where code_combination_id=payables_code_combination_id) cost_center,
(select segment2
from gl_code_combinations
where code_combination_id=payables_code_combination_id) location,
(select segment9
from gl_code_combinations
where code_combination_id=payables_code_combination_id) intercompany,
(select segment11
from gl_code_combinations
where code_combination_id=payables_code_combination_id) future2
FROM fa_mass_additions fma,
fa_categories_b fcb
WHERE
queue_name<>’POSTED’
AND fma.asset_category_id=fcb.category_id;
Recent Posts
