PO_APPHDR_CA_VW

(SQL View)
 Index Back

PO Approval Header

PO Approval Header used by Fluid Approval

SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , C.COMMENT_ID , C.COMMENTS_2000 , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE , A.PUBLIC_FLG , A.COMMENT_TYPE , A.SHIPTO_ID FROM PS_PO_COMMENTS A FULL OUTER JOIN PS_PV_ATTACHMENTS B ON A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION , PS_COMMENTS_TBL C , PS_PO_APPR_HDR_VW D WHERE C.OPRID = A.OPRID AND C.COMMENT_ID = A.COMMENT_ID AND C.RANDOM_CMMT_NBR= A.RANDOM_CMMT_NBR AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PO_ID = D.PO_ID AND A.STATUS = 'A' AND A.LINE_NBR = 0 AND (A.APPR_JUSTIFY_FLG = 'N' OR (a.APPR_JUSTIFY_FLG = 'Y' AND A.SCM_ATTACH_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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
5 COMMENTS_2000 Long Character CLOB Comment Text
6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
8 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor
9 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
10 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location