PV_APPR_ATTACH

(SQL View)
Index Back

PV_APPR_ATTACH


SELECT B.BUSINESS_UNIT , B.REQ_ID , B.COMMENT_ID , B.RANDOM_CMMT_NBR , A.SCM_ATTACH_ID , A.ATT_VERSION , A.ATTACHUSERFILE , A.ATTACHSYSFILENAME 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 B.COMMENT_ID = A.COMMENT_ID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR , PS_REQ_HDR H WHERE H.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.REQ_ID = B.REQ_ID AND B.COMMENT_TYPE = 'HDR' AND B.APPR_JUSTIFY_FLG = 'Y' AND B.STATUS = 'A' AND H.ORIG_TRAN IN ('EPO', 'SPO', 'REQ') AND A.SCM_ATTACH_ID IS NOT NULL UNION ALL SELECT B.BUSINESS_UNIT , B.REQ_ID , B.COMMENT_ID , B.RANDOM_CMMT_NBR , A.SCM_ATTACH_ID , A.ATT_VERSION , A.ATTACHUSERFILE , A.ATTACHSYSFILENAME 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 , PS_REQ_HDR H WHERE H.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.REQ_ID = B.REQ_ID AND B.COMMENT_TYPE = 'HDR' 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 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
4 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
5 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.
6 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.
7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename