PV_CAT_CATID_VW

(SQL View)
 Index Back

Catalog View

Rule Based Catalogs

SELECT DISTINCT a.SETID , a.TREE_NAME ,'C' FROM PSTREENODE a , PS_ITM_CAT_TBL b , PSTREEDEFN c WHERE a.SETID = b.SETID AND a.TREE_NODE = b.CATEGORY_CD AND b.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITM_CAT_TBL WHERE SETID = b.SETID AND CATEGORY_TYPE = b.CATEGORY_TYPE AND CATEGORY_ID = b.CATEGORY_ID AND CATEGORY_CD = b.CATEGORY_CD AND EFFDT <= %CurrentDateIn ) AND b.EFF_STATUS = 'A' AND a.SETID = c.SETID AND a.TREE_NAME = c.TREE_NAME AND a.SETCNTRLVALUE = c.SETCNTRLVALUE AND a.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREENODE WHERE a.SETID = SETID AND a.TREE_NAME = TREE_NAME AND a.SETCNTRLVALUE = SETCNTRLVALUE AND a.TREE_NODE_NUM = TREE_NODE_NUM AND a.TREE_NODE = TREE_NODE AND a.TREE_BRANCH = TREE_BRANCH AND a.EFFDT <= %CurrentDateIn ) AND c.EFF_STATUS = 'A' AND c.TREE_STRCT_ID = 'ITEMS' AND a.TREE_NODE_NUM = 1

# 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