PO_SE_COMM_HDR1

(SQL View)
Index Back

PO Search attach D view


SELECT A.BUSINESS_UNIT , A.PO_ID , B.COMMENTS_2000 , A.OPRID FROM PS_PO_COMMENTS A , PS_COMMENTS_TBL B WHERE A.OPRID = B.OPRID AND A.COMMENT_ID = B.COMMENT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 COMMENTS_2000 Long Character CLOB Comment Text
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).