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
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 |