PO_XMLP_PO_COM

(SQL View)
 Index Back

PO Comments for XMLP print

Date Initials Reference # Description 10/30/2008 SK F-AHAYT-D6Z26 9.1 PO XMLP Print

SELECT CMMTSH.BUSINESS_UNIT , CMMTSH.PO_ID , CMMTSH.SHIPTO_ID , CMMTSH.LINE_NBR , CMMTSH.COMMENT_TYPE , CMMTSH.COMMENT_ID , CMMTSH.RANDOM_CMMT_NBR , CMTSH.COMMENTS_2000 FROM PS_PO_COMMENTS CMMTSH , PS_COMMENTS_TBL CMTSH WHERE CMMTSH.BUSINESS_UNIT = 'IND01' AND CMMTSH.PO_ID ='0000000009' AND CMMTSH.PUBLIC_FLG = 'N' AND CMMTSH.STATUS = 'A' AND CMMTSH.COMMENT_ID = CMTSH.COMMENT_ID AND CMMTSH.OPRID = CMTSH.OPRID AND CMMTSH.RANDOM_CMMT_NBR = CMTSH.RANDOM_CMMT_NBR AND CMMTSH.SOURCE_FROM = 'PO'

# 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 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 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
6 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
7 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
8 COMMENTS_2000 Long Character CLOB Comment Text