PV_CMMT_ATCH_VW

(SQL View)
 Index Back

ePro Comments and Attachments

ePro Comments and Attachments

SELECT B.BUSINESS_UNIT , B.REQ_ID , B.LINE_NBR , L.DESCR254_MIXED , B.COMMENT_ID , B.RANDOM_CMMT_NBR , A.SCM_ATTACH_ID , A.ATT_VERSION , A.ATTACHUSERFILE , A.ATTACHSYSFILENAME , C.COMMENTS_2000 FROM PS_REQ_COMMENTS B FULL OUTER JOIN PS_PV_REQ_ATTCH A ON A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR FULL OUTER JOIN PS_REQ_LINE L ON L.BUSINESS_UNIT = B.BUSINESS_UNIT AND L.REQ_ID = B.REQ_ID AND L.LINE_NBR = B.LINE_NBR ,PS_COMMENTS_TBL C ,PS_REQ_HDR H WHERE H.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.REQ_ID = B.REQ_ID AND C.COMMENT_ID = B.COMMENT_ID AND C.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND B.COMMENT_TYPE <> 'SHP' AND B.APPR_JUSTIFY_FLG <> 'Y' AND B.STATUS = 'A' AND H.ORIG_TRAN IN ('EPO','SPO', 'REQ') UNION ALL SELECT B.BUSINESS_UNIT , B.REQ_ID , B.LINE_NBR , L.DESCR254_MIXED , B.COMMENT_ID , B.RANDOM_CMMT_NBR , A.SCM_ATTACH_ID , A.ATT_VERSION , A.ATTACHUSERFILE , A.ATTACHSYSFILENAME , C.COMMENTS_2000 FROM PS_REQ_COMMENTS B FULL OUTER JOIN PS_PV_ATTACHMENTS A ON A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION FULL OUTER JOIN PS_REQ_LINE L ON L.BUSINESS_UNIT = B.BUSINESS_UNIT AND L.REQ_ID = B.REQ_ID AND L.LINE_NBR = B.LINE_NBR , PS_COMMENTS_TBL C , PS_REQ_HDR H WHERE H.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.REQ_ID = B.REQ_ID AND C.COMMENT_ID = B.COMMENT_ID AND C.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND B.COMMENT_TYPE <> 'SHP' AND B.APPR_JUSTIFY_FLG <> 'Y' AND B.STATUS = 'A' AND H.ORIG_TRAN IN ( 'REQ', 'EPO', 'SPO')

# 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
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
5 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
6 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
7 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
8 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
10 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
11 COMMENTS_2000 Long Character CLOB Comment Text