PTSF_CATFCT_V

index back

Selected facets for category

This will give the list of selected facets for a given category along with there labels
SELECT A.PTSF_SRCCAT_NAME , A.PTSF_FACET_NAME , A.PTSF_SRCATTR_NAME , A.PTSF_SRCATTR_TYPE , A.PTSF_IS_COMMON , B.SEQNO , A.DESCR254 , B.PTSF_ASSOIATED_FCT , ' ' , B.PTSF_FACET_ORDER , B.PTSF_FCT_MINDOC_NO , B.PTSF_FCT_MAX_CHILD , B.PTSF_DISFCT_COUNT FROM PS_PTSF_CATFCTP_V A , PSPTSF_CATFACET B WHERE A.PTSF_SRCCAT_NAME = B.PTSF_SRCCAT_NAME AND A.PTSF_FACET_NAME = B.PTSF_FACET_NAME

BEGIN ptref.pthtml('PTSF_CATFCT_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