PA Process Mass Update Batches

Description

Categories
BI Publisher
Application
Projects
Source
PRC: Process Mass Update Batches (XML)
Short Name
PAXBAUPD_XML
DB package
PA_PAXBAUPD_XMLP_PKG

SQL 14 lines

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

Parameters 1

ParameterTypeList of values SQL
Batch NameLOV Oracle