PTAI_LIST_SVW

index back

Action Items Lists View

Action Items Lists View
SELECT D.OPRID , A.PTAI_LIST_ID , A.PTAI_LABEL , A.PORTAL_NAME , A.PTAI_ACTIVE_FLG , A.PTAI_IS_TMPL , A.PTAI_LIST_STATUS ,A.PTAI_PARENT_TMPL , A.CREATEOPRID FROM PS_PTAI_LIST A , PSOPRDEFN D WHERE (EXISTS ( SELECT 'X' FROM PS_PTAI_LIST_PRIV F WHERE F.PTAI_LIST_ID = A.PTAI_LIST_ID AND EXISTS ( SELECT 'X' FROM PSROLEUSER X WHERE X.ROLEUSER = D.OPRID AND ((F.PTAI_MBR_TYPE = 'USER' AND F.PTAI_MBR_NAME = X.ROLEUSER) OR (F.PTAI_MBR_TYPE = 'ROLE' AND F.PTAI_MBR_NAME = X.ROLENAME)))))

BEGIN ptref.pthtml('PTAI_LIST_SVW'); END; * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "SYSADM.PTREF", line 33 ORA-06512: at "SYSADM.PTREF", line 146 ORA-06512: at line 1