PTSF_CATSORTF_V

index back

Advanced search filters view

This view can return the list of advanced search fields setup along with correspoding labels.
SELECT A.PTSF_SRCCAT_NAME ,A.PTSF_SRCATTR_NAME , A.PTSF_SRCATTR_TYPE ,B.SEQNO , A.DESCR254 FROM PS_PTSF_CAT_ATRSV A , PSPTSF_CATSRTFD B WHERE A.PTSF_SRCCAT_NAME = B.PTSF_SRCCAT_NAME AND A.PTSF_SRCATTR_NAME = B.PTSF_SRCATTR_NAME

BEGIN ptref.pthtml('PTSF_CATSORTF_V'); 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