ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4213869E053B46B63588994 SELECT concurrent_request_id, description, process_id, source_process FROM psb_error_messages WHERE (( process_id = NVL(:P_PROCESS_ID,'000') AND source_process = NVL(:P_SOURCE_PROCESS,'000') ) OR (concurrent_request_id = NVL(:P_CONC_ID,'000')) ) AND concurrent_request_id = to_number(:cp_max_conc_id) ORDER BY sequence_number Y PSB PSBRPERR_XML Y US PSB Validation Results Application: Public Sector Budgeting (Obsolete) Source: Validation Results Report (XML) Short Name: PSBRPERR_XML DB package: PSB_PSBRPERR_XMLP_PKG BI Publisher :cp_max_conc_id :p_conc_id :p_process_id :p_source_process 1 10 :p_source_process LOV Oracle PSB_SRS_SOURCE_PROCESS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='PSB_ERROR_MESSAGE_SOURCE' and lookup_code<>'POSITION_WORKSHEET_EXCEPTION' order by value,description US Source Process 2 20 :p_process_id LOV Oracle PSB_SRS_PROCESS_NAME Y select process_id id, process_name value, null description from psb_error_requests_v where source_process=:$flex$.psb_srs_source_processorder by process_name order by value,description US Process Name 3 30 :p_conc_id LOV Oracle PSB_SRS_CONSTRAINTS Y select concurrent_request_id id, concurrent_request_id value, source_process_meaning description from psb_error_requests_v order by source_process_meaning,concurrent_request_id US Concurrent Request Id