PV_REQ_BUCAT_VW

(SQL View)
 Index Back

Requisition Business Category

Requisition Business Category

SELECT A.BUSINESS_UNIT , A.CATALOG_ID , A.PV_ENABLED FROM PS_PV_REQ_BU_CAT A , PSTREEDEFN B , PS_SET_CNTRL_GROUP C WHERE A.CATALOG_ID = B.TREE_NAME AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE B.SETID = SETID AND B.TREE_NAME = TREE_NAME AND B.SETCNTRLVALUE = SETCNTRLVALUE AND EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' AND B.TREE_STRCT_ID = 'ITEMS' AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.REC_GROUP_ID = 'FS_18' AND C.SETID = B.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

2 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID

Prompt Table: CATALOG_VW

3 PV_ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.
N=No
Y=Yes