SUP_PROF_ALL

(SQL View)
 Index Back

Supplier Profile Response

Supplier Profile Response view

SELECT A.SETID ,A.VENDOR_ID , A.QUESTION_ID , P.BID_FACTOR_TYPE ,TO_CHAR(P.COMMENTS_2000) ,P.REQUIRED_FLG ,A.RESPONSE_DESCR FROM PS_SUP_PROF_RESP A ,PS_SUP_PROFILE_QST P WHERE A.QUESTION_ID = P.QUESTION_ID AND BID_FACTOR_TYPE NOT IN ('L','M','N') UNION SELECT B.SETID ,B.VENDOR_ID ,B.QUESTION_ID ,C.BID_FACTOR_TYPE ,TO_CHAR(C.COMMENTS_2000) ,C.REQUIRED_FLG , ( SELECT PV.ATTACHUSERFILE FROM PS_PV_ATTACHMENTS PV WHERE PV.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND PV.ATT_VERSION = B.ATT_VERSION) FROM PS_SUP_PRF_RSP_ATT B , PS_SUP_PROFILE_QST C WHERE B.QUESTION_ID = C.QUESTION_ID AND C.BID_FACTOR_TYPE = 'A' AND B.SCM_ATTACH_ID <> ' ' UNION SELECT B.SETID ,B.VENDOR_ID ,B.QUESTION_ID ,C.BID_FACTOR_TYPE ,TO_CHAR(C.COMMENTS_2000) ,C.REQUIRED_FLG ,( SELECT D.BID_LIST_ITEM FROM PS_SUP_PRO_QST_LST D WHERE D.AUC_BF_LIST_LINE = B.RESPONSE_DESCR AND D.QUESTION_ID = B.QUESTION_ID) FROM PS_SUP_PROF_RESP B , PS_SUP_PROFILE_QST C WHERE B.QUESTION_ID = C.QUESTION_ID AND C.BID_FACTOR_TYPE IN ('L','M') UNION SELECT A.SETID ,A.VENDOR_ID , A.QUESTION_ID , P.BID_FACTOR_TYPE ,TO_CHAR(P.COMMENTS_2000) ,P.REQUIRED_FLG ,A.RESPONSE_DESCR FROM PS_SUP_PROF_RESP A ,PS_SUP_PROFILE_QST P WHERE A.QUESTION_ID = P.QUESTION_ID AND BID_FACTOR_TYPE = 'N' AND A.RESPONSE_DESCR <> '0'

  • Related Language Record: SUP_PROF_ALL_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    4 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
    A=Attachment
    C=Monetary
    D=Date
    L=List
    N=Numeric
    S=Separator
    T=Text
    Y=Yes/No
    5 COMMENTS_2000 Long Character CLOB Comment Text
    6 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag
    7 RESPONSE_DESCR Character(254) VARCHAR2(254) NOT NULL Response Status Description