MIN_POCOMM_VW

(SQL View)
Index Back

PO Comments View for Mobile

PO Comments View for Mobile transactions

SELECT A.BUSINESS_UNIT , A.PO_ID , A.RECV_VIEW_FLG , A.COMMENT_TYPE , A.SHIPTO_ID , A.LINE_NBR , B.COMMENTS_2000 FROM PS_PO_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.RECV_VIEW_FLG = 'Y' AND A.SOURCE_FROM = 'PO' 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 RECV_VIEW_FLG Character(1) VARCHAR2(1) NOT NULL Shown at Receipt
4 COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
BF=Bid Factor
CBF=Analysis Collab Bid Factor
HDR=Header
LIN=Line
SHP=Ship To Location
5 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 COMMENTS_2000 Long Character CLOB Comment Text