Monday, June 23, 2014

SQL Query to identify the change requests for IR_ISO



Select * from po_change_requests
where request_status in ( 'NEW' , 'MGR_PRE_APP' , 'MGR_APP')
AND DOCUMENT_TYPE= 'REQ'
AND REQUEST_LEVEL= 'LINE'
AND ACTION_TYPE = 'MODIFICATION';

No comments:

Post a Comment