PA Interface Assets to Oracle Assets

Description
Categories: BI Publisher
Application: Projects
Source: PRC: Interface Assets to Oracle Assets (XML)
Short Name: PAXCPCAL_XML
DB package: PA_PAXCPCAL_XMLP_PKG
select  p.segment1 project_number_rl,
        pa.asset_name asset_name_rl,
        pa.asset_description description_rl,
        lkp.meaning retirement_cost_type,
        fa.asset_number target_asset,
        count(pal.project_asset_line_id) count_asset_line_rl,
        sum(pal.current_asset_cost) sum_asset_cost_rl
from    pa_project_assets pa,
        pa_project_asset_lines pal,
        pa_projects p,
        pa_lookups lkp,
        fa_additions fa
where   pal.request_id =  nvl(:p_conc_request_id,0) AND
        pal.transfer_status_code ||'' = 'T'   AND
		pal.LINE_TYPE = 'R' AND
        pa.project_asset_id = pal.project_asset_id AND
        pa.project_id = p.project_id AND
		lkp.lookup_type = 'RETIREMENT_COST_TYPE' AND
		lkp.lookup_code = pal.retirement_cost_type AND
		pa.ret_target_asset_id = fa.asset_id
group by p.segment1, pa.asset_name, pa.asset_description,
pa.request_id,lkp.meaning,fa.asset_number
order by 1,2,3
Parameter Name SQL text Validation
From Project Number
 
Char
To Project Number
 
Char
Date Placed In Service Through
 
Date