PTSF_CAT_ATRSV

index back

Category attributes desc view

This can be used by the UI to show category specific attributes with description
SELECT A.PTSF_SRCCAT_NAME ,A.PTSF_SRCATTR_NAME , B.PTSF_SRCATTR_TYPE , A.PTSF_IS_COMMON , B.DESCR254 FROM PS_PTSF_CATATTRSVW A , PS_PTSF_ALLATR_V B WHERE A.PTSF_SD_SOURCE = B.PTSF_SD_SOURCE AND A.PTSF_SOURCE_NAME = B.PTSF_SOURCE_NAME AND A.PTSF_SRCATTR_NAME = B.PTSF_SRCATTR_NAME

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