FA Asset Register

Description

Categories
Enginatics
Application
Assets
Source
Asset Register Report (XML)
Short Name
FAS600_XML
DB package
FA_FAS600_XMLP_PKG
Repository
GitHub

SQL 543 lines

Parameters 10

ParameterTypeList of values SQL
BookLOV Oracle
From PeriodLOV
exists (select null from fa_deprn_summary ds_f where ds_f.asset_id=ad.asset_id and ds_f.book_type_code=bk.book_type_code and ds_f.period_counter>=(select fdp.period_counter from fa_deprn_periods fdp where fdp.book_type_code=bk.book_type_code and fdp.period_name=:p_from_period))
To PeriodLOV
From Asset NumberLOV Oracle
ad.asset_number >= :p_start_asset
To Asset NumberLOV Oracle
ad.asset_number <= :p_end_asset
Asset KeyLOV
ad.asset_key_ccid in (select fakk.code_combination_id from fa_asset_keywords_kfv fakk where fakk.concatenated_segments=:asset_key)
Show Deprn Book DetailsLOV Oracle
Show Distribution DetailsLOV Oracle
Show Invoice DetailsLOV Oracle
DFF DisplayLOV
select xxen_util.dff_columns(p_table_name=>'fa_additions_b',p_table_alias=>'ad',p_column_name_prefix=>'Asset DFF: ',p_display_mode=>:dff_display) from dual