REQ_SE_SES_VW

(SQL View)
 Index Back

SCMT Document Security


SELECT HDR.BUSINESS_UNIT , HDR.REQ_ID , 'A:ALL' FROM PS_REQ_HDR HDR UNION SELECT HDR.BUSINESS_UNIT , HDR.REQ_ID , 'U:' %Concat HDR.REQUESTOR_ID FROM PS_REQ_HDR HDR UNION SELECT HDR.BUSINESS_UNIT , HDR.REQ_ID , 'U:' %Concat RQS.REQUESTOR_ID FROM PS_REQ_HDR HDR , PS_OPR_PO_RQSTR_VW RQS WHERE HDR.OPRID_ENTERED_BY = RQS.OPRID AND HDR.REQUESTOR_ID <> RQS.REQUESTOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

Default Value: NEXT

3 PV_REQ_SECURITY Character(75) VARCHAR2(75) NOT NULL Search Requisition Security