WM_SEC_SRCH_VW

(SQL View)
 Index Back

WM - Search Security View

Used for Document Level Security on Work Orders.

SELECT A.BUSINESS_UNIT , A.WO_ID , 'A:' %Concat A.BUSINESS_UNIT FROM PS_WM_WO_HDR A UNION ALL SELECT A.BUSINESS_UNIT , A.WO_ID , 'S:' %Concat A.BUSINESS_UNIT %Concat '-' %Concat A.SHOP_ID FROM PS_BUS_UNIT_TBL_WM BU , PS_WM_WO_ACCESS A WHERE BU.WM_WO_ACCESS IN ('S','B') AND A.BUSINESS_UNIT = BU.BUSINESS_UNIT UNION ALL SELECT WOAT.BUSINESS_UNIT , WOAT.WO_ID , 'P:' %Concat WOAPC.BUSINESS_UNIT_PC %Concat '-' %Concat WOAPC.POOL_ID FROM PS_BUS_UNIT_TBL_WM WOABU , PS_WM_WO_TSK WOAT , PS_PGM_ENFPOOL_ACT WOAPC WHERE WOABU.WM_WO_ACCESS IN ('R','B') AND WOAT.BUSINESS_UNIT = WOABU.BUSINESS_UNIT AND WOAPC.BUSINESS_UNIT_PC = WOAT.BUSINESS_UNIT_PC AND WOAPC.PROJECT_ID = WOAT.PROJECT_ID AND WOAPC.ACTIVITY_ID = WOAT.ACTIVITY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WM_SECURITY_ID Character(40) VARCHAR2(40) NOT NULL Security Attribute