SUP_PROF_ALL_LN

(SQL View)
 Index Back

Supplier Profile Response

Supplier Profile Response view

SELECT A.SETID ,A.VENDOR_ID , A.QUESTION_ID ,LN.LANGUAGE_CD , TO_CHAR(LN.COMMENTS_2000 ) ,A.RESPONSE_DESCR , P.REQUIRED_FLG FROM PS_SUP_PROF_RESP A ,PS_SUP_PROFILE_QST P , PS_SUP_PROF_QST_LG LN WHERE A.QUESTION_ID = P.QUESTION_ID AND BID_FACTOR_TYPE NOT IN ('L','M','N') AND P.QUESTION_ID = LN.QUESTION_ID UNION SELECT B.SETID ,B.VENDOR_ID ,B.QUESTION_ID ,LN.LANGUAGE_CD ,TO_CHAR(LN.COMMENTS_2000) , ( SELECT PV.ATTACHUSERFILE FROM PS_PV_ATTACHMENTS PV WHERE PV.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND PV.ATT_VERSION = B.ATT_VERSION) , C.REQUIRED_FLG FROM PS_SUP_PRF_RSP_ATT B , PS_SUP_PROFILE_QST C , PS_SUP_PROF_QST_LG LN WHERE B.QUESTION_ID = C.QUESTION_ID AND C.BID_FACTOR_TYPE = 'A' AND B.SCM_ATTACH_ID <> ' ' AND C.QUESTION_ID = LN.QUESTION_ID UNION SELECT B.SETID ,B.VENDOR_ID ,B.QUESTION_ID ,LN.LANGUAGE_CD ,TO_CHAR(LN.COMMENTS_2000) ,( 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) , C.REQUIRED_FLG FROM PS_SUP_PROF_RESP B , PS_SUP_PROFILE_QST C , PS_SUP_PROF_QST_LG LN WHERE B.QUESTION_ID = C.QUESTION_ID AND C.BID_FACTOR_TYPE IN ('L','M') AND C.QUESTION_ID = LN.QUESTION_ID UNION SELECT A.SETID ,A.VENDOR_ID , A.QUESTION_ID ,LN.LANGUAGE_CD ,TO_CHAR(LN.COMMENTS_2000) ,A.RESPONSE_DESCR , P.REQUIRED_FLG FROM PS_SUP_PROF_RESP A ,PS_SUP_PROFILE_QST P , PS_SUP_PROF_QST_LG LN WHERE A.QUESTION_ID = P.QUESTION_ID AND BID_FACTOR_TYPE = 'N' AND A.RESPONSE_DESCR <> '0' AND P.QUESTION_ID = LN.QUESTION_ID

  • Related Language Record for SUP_PROF_ALL

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 COMMENTS_2000 Long Character CLOB Comment Text
    6 RESPONSE_DESCR Character(254) VARCHAR2(254) NOT NULL Response Status Description
    7 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag