PO_REQ_L_COM_WS

(SQL View)
 Index Back

Requisition Line Work Scroll


SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , A.OPRID , A.COMMENT_ID , A.RANDOM_CMMT_NBR , A.PUBLIC_FLG , B.COMMENTS_2000 FROM PS_REQ_COMMENTS A , PS_COMMENTS_TBL B WHERE A.COMMENT_ID = B.COMMENT_ID AND A.OPRID = B.OPRID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND A.STATUS = 'A' AND A.PUBLIC_FLG = 'Y' AND A.COMMENT_TYPE = 'LIN'

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
6 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
7 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

Y/N Table Edit

Default Value: Y

8 COMMENTS_2000 Long Character CLOB Comment Text