PA Process Mass Update Batches

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: PRC: Process Mass Update Batches (XML)
Short Name: PAXBAUPD_XML
DB package: PA_PAXBAUPD_XMLP_PKG
Run PA Process Mass Update Batches and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	batch_id batch_id1,
	project_name, 
	task_name,
	substr(old_attribute_value_v ,1,60)  Old_Organization,
	substr(new_attribute_value_v,1,60)  New_Organization,
	rejection_reason,
	update_flag,	
	recalculate_flag,
	PA_PAXBAUPD_XMLP_PKG.CF_UPDATE_FLAGFORMULA(update_flag) CF_Update_flag,
	PA_PAXBAUPD_XMLP_PKG.CF_RECAL_FLAGFORMULA(recalculate_flag) CF_recal_flag
FROM	pa_mu_details_v 
 where batch_id=:batch_id
ORDER	BY  project_name, NVL(task_name,'0'), old_attribute_value_v
Parameter Name SQL text Validation
Batch Name 
 
 LOV Oracle
Download
Related Blitz Reports
ECC Projects, Projects Costing: Transactions, SQL1 PA Capital Project Summary with Asset Detail PO IDV Modification PO Requisition Upload PPF_WP3_OM_DETAILS PON Solicitation data template CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Material Usage with Configuration and Lot Variances CAC WIP Resource Efficiency
Blitz Report™

Blitz Report™ provides multiple benefits: