PC_ADD_PRJ_VW

(SQL View)
 Index Back

View of PS_PC_OPRID_PRJACT

PS_PC_OPRID_PRJACT

SELECT A.BUSINESS_UNIT , A.PROJECT_ID FROM PS_PROJECT A WHERE A.PROJECT_ID NOT IN ( SELECT PROJECT_ID FROM PS_PC_OPRID_PRJACT WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND OPRID = %OperatorId)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField