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
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 |