SUP_PROF_QSTVW

(SQL View)
Index Back

Profile Question View


SELECT A.QUESTION_ID ,TO_CHAR(COMMENTS_2000) ,B.XLATLONGNAME ,C.XLATLONGNAME , A.REQUIRED_FLG FROM PS_SUP_PROFILE_QST A ,PSXLATITEM B ,PSXLATITEM 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' UNION SELECT A.QUESTION_ID ,TO_CHAR(COMMENTS_2000) ,( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 10320 AND MESSAGE_NBR = 211),C.XLATLONGNAME , A.REQUIRED_FLG FROM PS_SUP_PROFILE_QST A,PSXLATITEM C WHERE A.SUP_CONTACT_TYPE = C.FIELDVALUE AND C.FIELDNAME = 'SUP_CONTACT_TYPE' AND BID_FACTOR_TYPE = 'M'

  • Related Language Record: SUP_PROF_QSTVLN
  • # 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 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.
    4 SUP_CONTACT_TYPE1 Character(30) VARCHAR2(30) NOT NULL Question Type
    5 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit