SP_FR_ENT_OPRVW

(SQL View)
 Index Back

Worksheet Report Entities

Security view of FR_WS_ENT_NONVW. The sub-select is to exclude any tree nodes with Business Units that the user does not have access to.

SELECT DISTINCT B.OPRID ,A.WORKSHEET_ID ,A.FR_REPORT_ENTITY FROM PS_FR_WS_BU_SEL A , PS_SEC_BU_OPR B WHERE B.OPRID = A.OPRID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND NOT EXISTS ( SELECT 'X' FROM PS_FR_WS_BU_SEL C WHERE C.WORKSHEET_ID = A.WORKSHEET_ID AND C.OPRID = A.OPRID AND C.FR_REPORT_ENTITY = A.FR_REPORT_ENTITY AND C.BUSINESS_UNIT NOT IN ( SELECT BUSINESS_UNIT FROM PS_SEC_BU_OPR WHERE OPRID = C.OPRID))

# 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 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID
3 FR_REPORT_ENTITY Character(20) VARCHAR2(20) NOT NULL Report Entity