How to check auto create approved PO without manual perform.

Make sure the four values are all return 'Y' to achieve auto create.



select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Should Workflow Create The Release?' Attribute 
from wf_item_attributes w 
where w.NAME = 'CONT_WF_FOR_AC_REL_GEN' 
union 
select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Is Automatic Creation Allowed?' Attribute 
from wf_item_attributes w 
where w.NAME = 'AUTOCREATE_DOC' 
union 
select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Is Automatic Approval Allowed?' Attribute 
from wf_item_attributes w 
where w.NAME = 'AUTO_APPROVE_DOC' 
union 
select rtrim(w.name) name, 
w.text_default Value, 
rtrim(w.item_type) item_type, 
'Send PO Autocreation to Background' Attribute 
from wf_item_attributes w 
where w.NAME = 'SEND_CREATEPO_TO_BACKGROUND' 
and w.item_type = 'REQAPPRV' 
order by 1