PTS_CREF_PMT_VW

(SQL View)
 Index Back

SELECT A.PORTAL_NAME ,A.PORTAL_OBJNAME ,C.PORTAL_LABEL FROM PS_PTS_CREF_FL_VW A , PSPRSMDEFN C WHERE A.PORTAL_NAME = C.PORTAL_NAME AND A.PORTAL_OBJNAME = C.PORTAL_OBJNAME AND EXISTS ( SELECT 'X' FROM PS_PTS_RECFLD_VW B WHERE A.SEARCHRECNAME = B.RECNAME AND B.PTS_SRCH_KEY_FLG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label