PT_IQ_TOP_PR

index back

Registry Top Level Fldr Prompt


SELECT A.PORTAL_NAME ,A.PORTAL_OBJNAME ,A.PORTAL_LABEL FROM PSPRSMDEFN A WHERE A.PORTAL_REFTYPE = 'F' AND A.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT' AND A.PORTAL_CREF_USGT <> 'LINK'

  • Related language record: PT_IQTPLNGVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PT_CREF_OBJCharacter(30)VARCHAR2(30) NOT NULLMenu Item Name
    PT_CREF_LBLCharacter(30)VARCHAR2(30) NOT NULLContent Reference label (PORTAL_LABEL)
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19