PA Generate Asset Lines for a Range of Projects

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: PRC: Generate Asset Lines for a Range of Projects (XML)
Short Name: PAXCPGAL_XML
DB package: PA_PAXCPGAL_XMLP_PKG
Run PA Generate Asset Lines for a Range of Projects and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  pe.project_id aex_project_id,
        pe.project_number aex_project_number,
        pl2.meaning aex_asset_allocation_method,
        pe.asset_or_project_error aex_error_type,
        pe.project_asset_line_id aex_asset_line_id,
        pt.task_number aex_task_number,
        ppa.asset_name aex_asset_name,
        pe.project_asset_id aex_asset_id,
        pe.capital_event_id aex_cap_event_id,
        pe.capital_event_number aex_event_number,
        pe.event_name aex_eventname,
        pl.lookup_code aex_error_code, 
        pl.meaning aex_error_message
FROM    pa_asset_alloc_exceptions_v pe,
        pa_project_assets ppa,
        pa_tasks pt,
        pa_lookups pl,
        pa_lookups pl2
WHERE   ppa.project_asset_id(+) = pe.project_asset_id
AND     pe.request_id = :p_conc_request_id
AND     pt.task_id = pe.task_id
AND     pl.lookup_type = 'ASSET_ALLOCATION_EXCEPTIONS'
AND     pl.lookup_code = pe.error_code
AND     pl2.lookup_type = 'ASSET_ALLOCATION_METHOD'
AND     pl2.lookup_code = pe.asset_allocation_method
AND    (pe.event_name IS NULL 
           OR   pe.event_name = nvl(:p_event_name,pe.event_name))
UNION ALL
SELECT  pe.project_id aex_project_id,
        pe.project_number aex_project_number,
        pl2.meaning aex_asset_allocation_method,
        pe.asset_or_project_error aex_error_type,
        pe.project_asset_line_id aex_asset_line_id,
        NULL,
        ppa.asset_name aex_asset_name,
        pe.project_asset_id aex_asset_id,
        pe.capital_event_id aex_cap_event_id,
        pe.capital_event_number aex_event_number,
        pe.event_name aex_eventname,
        pl.lookup_code aex_error_code, 
        pl.meaning aex_error_message
FROM    pa_asset_alloc_exceptions_v pe,
        pa_project_assets ppa,
        pa_lookups pl,
        pa_lookups pl2
WHERE   ppa.project_asset_id(+) = pe.project_asset_id
AND     pe.request_id = :p_conc_request_id
AND     pe.task_id = 0
AND     pl.lookup_type = 'ASSET_ALLOCATION_EXCEPTIONS'
AND     pl.lookup_code = pe.error_code
AND     pl2.lookup_type = 'ASSET_ALLOCATION_METHOD'
AND     pl2.lookup_code = pe.asset_allocation_method
AND    (pe.event_name IS NULL 
           OR   pe.event_name = nvl(:p_event_name,pe.event_name))
Parameter Name SQL text Validation
From Project Number 
 
 Char
To Project Number 
 
 Char
Date Placed In Service Through 
 
 Date
Include Common Tasks? 
 
 LOV Oracle
PA Through Date 
 
 Date
Download
Related Blitz Reports
PA Generate Asset Lines for a Single Project ECC Projects, Projects Costing: Transactions, SQL1 PA Generate Capitalized Interest Transactions AP Invoices and Lines GL Account Analysis (Distributions) GL Account Analysis (Distributions) 11g ECC Projects, Projects Costing: Assets GL Account Analysis PA Delete PA Periods
Blitz Report™

Blitz Report™ provides multiple benefits: