PAY_MESSAGES_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
MODULE_NAME FLOW_NAME FLOW_INSTANCE_ID STATUS TOTAL MESSAGE_TEXT TASK_INSTANCE_ID PROCESS MESSAGE_TEXT_CODE

Query

SQL_Statement

select aaa.module_name, aaa.flow_name,aaa.flow_instance_id, MESSAGE_LEVEL as status,COUNT(*) total, nvl(bbb.message_text,nvl((select max(message_text) from FND_MESSAGES_VL fnm where fnm.MESSAGE_NAME=bbb.MESSAGE),MESSAGE)) as message_text, aaa.task_instance_id,PROCESS, MESSAGE message_text_code from PAY_task_STATUS_VL aaa, PAY_PAY_MSG_RESULTS_VL bbb where bbb.flow_id= aaa.flow_instance_id and bbb.task_instance_id=aaa.task_instance_id and bbb.MESSAGE_LEVEL in ('F','E','W') group by aaa.module_name, aaa.flow_name,aaa.flow_instance_id, MESSAGE_LEVEL , MESSAGE_TEXT ,aaa.task_instance_id,PROCESS, MESSAGE