Oracle Apps SCM
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment