FSS_SETID_VW

(SQL View)
Index Back

Sec Vw - TableSet ID's


SELECT SETID , DESCR , DESCRSHORT , DESCRLONG FROM PS_SETID_TBL WHERE (EXISTS ( SELECT 'X' FROM PS_SDN_SRCH_SETUP WHERE SCM_FSS_OPTION = '1') OR EXISTS ( SELECT 'Y' FROM PS_SDN_SRCH_SETUP A , PS_FSS_BU_OM_VW B , PS_SET_CNTRL_REC C WHERE A.SCM_FSS_OPTION = '2' AND B.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'CUSTOMER' AND C.SETID = PS_SETID_TBL.SETID) OR EXISTS ( SELECT 'Y' FROM PS_SDN_SRCH_SETUP A , PS_FSS_BU_IN_VW B , PS_SET_CNTRL_REC C WHERE A.SCM_FSS_OPTION = '2' AND B.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'CUSTOMER' AND C.SETID = PS_SETID_TBL.SETID) OR EXISTS ( SELECT 'Y' FROM PS_SDN_SRCH_SETUP A , PS_BI_BU_FSS_VW B , PS_SET_CNTRL_REC C WHERE A.SCM_FSS_OPTION = '2' AND B.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'CUSTOMER' AND C.SETID = PS_SETID_TBL.SETID))

  • Related Language Record: SETID_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCRLONG Long Character CLOB Long Description