FA Unplanned Depreciation - draft

Description
Categories: BI Publisher
Application: Assets
Source: Unplanned Depreciation (XML) - Not Supported: Reserved For Future Use
Short Name: FASUNPLD_XML
DB package: FA_FASUNPLD_XMLP_PKG
select  	
	&ACCT_FLEX_BAL_SEG comp_code,	
	&ACCT_FLEX_ALL_SEG expense_account,
	&KEY_FLEX_ALL_SEG asset_key,
	fa.asset_number,
        	fa.tag_number,
        	fa.description,
        	fd.period_name,
	decode(substr(ft.transaction_name, 1,5),'UNPL ',substr(upper(ft.transaction_name),6),
				                'UNPLA',substr(upper(ft.transaction_name),23),
					ft.transaction_subtype )	t_name,
       	fj.adjustment_amount,
	fj.debit_credit_flag, 
	fnd_flex_xml_publisher_apis.proc