SUP_PROF_QSTVLN

(SQL View)
 Index Back

Profile Question View


SELECT A.QUESTION_ID ,TO_CHAR(LN.COMMENTS_2000) ,LN.LANGUAGE_CD ,B.XLATLONGNAME ,C.XLATLONGNAME FROM PS_SUP_PROFILE_QST A ,PS_SUP_PROF_QST_LG LN ,PSXLATITEMLANG B ,PSXLATITEMLANG C WHERE A.BID_FACTOR_TYPE = B.FIELDVALUE AND B.FIELDNAME = 'BID_FACTOR_TYPE' AND A.SUP_CONTACT_TYPE = C.FIELDVALUE AND C.FIELDNAME = 'SUP_CONTACT_TYPE' AND BID_FACTOR_TYPE <> 'S' AND BID_FACTOR_TYPE <> 'M' AND A.QUESTION_ID = LN.QUESTION_ID AND LN.LANGUAGE_CD = B.LANGUAGE_CD AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT A.QUESTION_ID ,TO_CHAR(LN.COMMENTS_2000) ,LN.LANGUAGE_CD ,( SELECT MESSAGE_TEXT FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR = 10320 AND MESSAGE_NBR = 211 AND LANGUAGE_CD = LN.LANGUAGE_CD),C.XLATLONGNAME FROM PS_SUP_PROFILE_QST A,PSXLATITEMLANG C ,PS_SUP_PROF_QST_LG LN WHERE A.SUP_CONTACT_TYPE = C.FIELDVALUE AND C.FIELDNAME = 'SUP_CONTACT_TYPE' AND BID_FACTOR_TYPE = 'M' AND A.QUESTION_ID = LN.QUESTION_ID AND LN.LANGUAGE_CD = C.LANGUAGE_CD

  • Related Language Record for SUP_PROF_QSTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    2 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 BID_FACTOR_TYPE1 Character(30) VARCHAR2(30) 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.
    5 SUP_CONTACT_TYPE1 Character(30) VARCHAR2(30) NOT NULL Question Type