PA Purge Project Data

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: ADM: Purge Project Data (XML)
Short Name: PAXARPPR_XML
DB package: PA_PAXARPPR_XMLP_PKG
Run PA Purge Project Data and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT proj.name, proj.segment1, 
              decode(ppj.archive_summary_flag, 'Y',:C_YES, :C_NO),                                                                                                       
              decode(ppj.purge_summary_flag,'Y',:C_YES, :C_NO),
              decode(ppj.archive_capital_flag,'Y',:C_YES, :C_NO),
              decode(ppj.purge_capital_flag,'Y',:C_YES, :C_NO),
              decode(ppj.archive_budgets_flag,'Y',:C_YES, :C_NO),
              decode(ppj.purge_budgets_flag,'Y',:C_YES, :C_NO),
              decode(ppj.archive_actuals_flag,'Y',:C_YES, :C_NO),
              decode(ppj.purge_actuals_flag,'Y',:C_YES, :C_NO), 
              ppj.project_id, 
              projd.table_name,
              projd.num_recs_purged recs_purged,
              projd.num_recs_archived recs_archived
FROM  pa_purge_prj_details projd, 
             pa_purge_projects ppj, 
             pa_projects_all proj
WHERE ppj.project_id = proj.project_id
AND  ppj.project_id = projd.project_id (+)
AND  ppj.purge_batch_id = projd.purge_batch_id (+)
AND  ppj.purge_batch_id = :P_Purge_batch_id
order by ppj.project_id,proj.segment1
Parameter Name SQL text Validation
Batch Name 
 
 LOV Oracle
Run Purge 
 
 LOV Oracle
Commit Size 
 
 Number
Download
Related Blitz Reports
ECC Projects, Projects Costing: Transactions, SQL1 ECC Projects, Projects Costing: Transactions, SQL2 ECC Projects, Projects Costing: Transactions, SQL3 ECC Discrete Manufacturing, Work Orders ECC Discrete Manufacturing, Work Order Delays PA Validate Purge Batches PON Solicitation data template PA Sweep Transaction Accounting Events PA Project Subledger: Detail by Project
Blitz Report™

Blitz Report™ provides multiple benefits: