PV_CAT_BUSEC_VW

(SQL View)
 Index Back

Catalog Security - Bus. Unit

Rule Based Catalogs

SELECT B.SETID , A.CATALOG_ID , 'C' , ' ' , 'BUSINESS_UNIT' , A.BUSINESS_UNIT FROM PS_PV_REQ_BU_CAT A , PS_SET_CNTRL_GROUP B WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE AND B.REC_GROUP_ID = 'FS_18' AND A.PV_ENABLED = 'Y' UNION SELECT L.SETID , L.PV_REQ_CAT_DESCR , L.CATALOG_TYPE , L.SETID_SECTYPE , L.PV_SECURITY_TYPE , L.PV_VALUE FROM PS_PV_CAT_SEC_LINE L , PS_PV_CAT_SEC_HDR H WHERE H.SETID_SECTYPE = L.SETID_SECTYPE AND H.PV_SECURITY_TYPE = L.PV_SECURITY_TYPE AND H.PV_VALUE = L.PV_VALUE AND H.PV_ENABLED = 'Y' AND L.PV_SECURITY_TYPE = 'BUSINESS_UNIT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID
3 CATALOG_TYPE Character(3) VARCHAR2(3) NOT NULL Catalog Type
4 SETID_SECTYPE Character(5) VARCHAR2(5) NOT NULL Security Type SetID
5 PV_SECURITY_TYPE Character(30) VARCHAR2(30) NOT NULL Security Type
6 PV_VALUE Character(150) VARCHAR2(150) NOT NULL Value