MIN_MNU_SRV_VW

(SQL View)
 Index Back

Mobile Inventory Services

Mobile Inventory Services Security View

SELECT B.OPRID , A.PORTAL_OBJNAME , B.CLASSID , A.VERSIONNAME , A.ACTIVE_FLAG , A.IB_OPERATIONNAME , A.BCNAME , A.IB_ACTION FROM PS_MIN_SERVICES A , PS_MIN_SRV_SEC_VW B WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.ACTIVE_FLAG = B.ACTIVE_FLAG AND A.VERSIONNAME = B.VERSIONNAME AND A.AUTHORIZEDACTIONS = B.AUTHORIZEDACTIONS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
4 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
6 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
7 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
8 IB_ACTION Character(60) VARCHAR2(60) NOT NULL Method