EOSF_CREF_PRMPT

 index back

SELECT A.PORTAL_NAME ,A.PORTAL_OBJNAME ,C.PORTAL_LABEL FROM PS_EOSF_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_EOSF_RECFLD_VW B WHERE A.SEARCHRECNAME = B.RECNAME AND B.EOSF_SRCH_KEY_FLG = 'Y')

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20