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
| Parameter | Type | List of values SQL |
|---|---|---|
| Batch Name | LOV Oracle |