REQ_SE_COMM_HDR

(SQL View)
 Index Back

Req Search header comments


SELECT A.BUSINESS_UNIT , A.REQ_ID , B.COMMENTS_2000 , A.OPRID FROM PS_REQ_COMMENTS A , PS_COMMENTS_TBL B WHERE A.OPRID = B.OPRID AND A.COMMENT_ID = B.COMMENT_ID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND A.STATUS = 'A'

# 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 SES_PROC_CMMT Long Character CLOB Common Procurement Comment Field
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).