PA Interface Assets to Oracle Assets

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: PRC: Interface Assets to Oracle Assets (XML)
Short Name: PAXCPCAL_XML
DB package: PA_PAXCPCAL_XMLP_PKG
Run PA Interface Assets to Oracle Assets and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
GL SLA Drillback Diagnostic GL Account Analysis (Distributions) GL Account Analysis 11g GL Account Analysis GL Account Analysis (Distributions) 11g ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets ECC Projects, Projects Costing: Assets PA Capital Project Summary with Asset Detail PA Interfaced CIP/RWIP Amounts by FA Period
Blitz Report™

Blitz Report™ provides multiple benefits: