CS_CNT_AG_US_VW

(SQL View)
 Index Back

SLA External Update Verify

SCC 01/01/07 F-AHAYT_25EQ8

SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , A.CNTRCT_LINE_NBR , A.CAT_LINE_NBR , A.CS_AGREE_SEQ5 , D.CS_VERIFY_SEQ , C.VENDOR_SETID , C.VENDOR_ID , C.VNDR_CNTRCT_REF , C.BUYER_ID , A.CS_SETID , A.CS_AGREE_CD , A.DESCR60 , A.CS_COMPLIANCE_STAT , A.CS_TARGET_DATE , D.DESCR60 , D.CS_ACTIVITY_STATUS , D.OPRDEFNDESC , B.OPRID FROM PS_CS_CNT_AG A , PS_CS_CNT_AG_WF B , PS_CNTRCT_HDR C , PS_CS_CNT_AG_VFY D WHERE %Join(COMMON_KEYS, CS_CNT_AG A, CNTRCT_HDR C) AND %Join(COMMON_KEYS, CS_CNT_AG A, CS_CNT_AG_VFY D) AND A.CS_COMPLIANCE_STAT <> '4' AND C.CNTRCT_STATUS <> 'X' AND C.VERSION_STATUS = 'C' AND D.CS_VERIFY_METHOD <> 'NO' AND D.CS_VERIFY_METHOD <> 'SY' AND D.CS_ACTIVITY_STATUS <> '5' AND B.SETID=A.SETID AND B.CNTRCT_ID=A.CNTRCT_ID AND B.VERSION_NBR=A.VERSION_NBR AND B.CNTRCT_LINE_NBR=A.CNTRCT_LINE_NBR AND B.CS_AGREE_SEQ5=A.CS_AGREE_SEQ5 AND B.CS_WORKFLOW_TYPE = '2' AND B.USER_TYPE = 'E' AND B.ALLOW_UPDATE_FLG = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_CS_CNT_AG_UV_VW E WHERE %Join(COMMON_KEYS, CS_CNT_AG_VFY D, CS_CNT_AG_UV_VW E))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
5 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
6 CS_AGREE_SEQ5 Number(5,0) INTEGER NOT NULL Agreement Sequence for Supplier Contract Managment
7 CS_VERIFY_SEQ Number(5,0) INTEGER NOT NULL Contract Agreement Verification Step
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VNDR_CNTRCT_REF Character(30) VARCHAR2(30) NOT NULL Supplier Contract Ref
11 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
12 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
13 CS_AGREE_CD Character(18) VARCHAR2(18) NOT NULL Agreement Code for Supplier Contract Managment
14 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
15 CS_COMPLIANCE_STAT Character(2) VARCHAR2(2) NOT NULL Compliance Status for Supplier Contract Managment
1=Compliant
2=Not Compliant
3=Not Set
4=Cancelled
16 CS_TARGET_DATE Date(10) DATE Contract Target Date for Supplier Contract Management
17 DESCR60_2 Character(60) VARCHAR2(60) NOT NULL Description
18 CS_ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Agreement Verification Activity Status
1=Completed
2=Failed
3=In Process
4=Not Started
5=Cancelled
19 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).