PA Process Mass Update Batches

Description
Categories: BI Publisher
Columns: Batch Id1, Project Name, Task Name, Old Organization, New Organization, Rejection Reason, Update Flag, Recalculate Flag, Cf Update Flag, Cf Recal Flag ...
Application: Projects
Source: PRC: Process Mass Update Batches (XML)
Short Name: PAXBAUPD_XML
DB package: PA_PAXBAUPD_XMLP_PKG
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