PTPP_CPPGLT_LVW

(SQL View)
 Index Back

Pagelet Objects

Retrieves Pagelet definitions for use in selecting which pagelets to keep during the EOPP_CPPROJ AE process.

SELECT C.PROJECTNAME , B.PORTAL_NAME , B.PORTAL_CNTPRV_NAM , B.PORTAL_OBJNAME , D.LANGUAGE_CD , D.PORTAL_LABEL FROM PSPRSMDEFN B , PSPROJECTITEM C , PSPRSMDEFNLANG D WHERE C.OBJECTTYPE = 55 AND B.PORTAL_NAME = C.OBJECTVALUE1 AND B.PORTAL_REFTYPE = C.OBJECTVALUE2 AND B.PORTAL_OBJNAME = C.OBJECTVALUE3 AND B.PORTAL_NAME = D.PORTAL_NAME AND B.PORTAL_REFTYPE = D.PORTAL_REFTYPE AND B.PORTAL_OBJNAME = D.PORTAL_OBJNAME AND B.PORTAL_REFTYPE = 'C' AND B.PORTAL_CREF_USGT = 'HPGC' AND B.PORTAL_OBJNAME NOT LIKE 'PT%' AND B.PORTAL_OBJNAME NOT LIKE 'PA%' AND B.PORTAL_OBJNAME NOT LIKE 'PORTAL%' AND B.OBJECTOWNERID NOT IN ('PPT','ENV','PPTD') AND B.PORTAL_PRODUCT NOT IN ('PT', 'AE', 'PRTL') AND B.PORTAL_CNTPRV_NAM NOT LIKE 'PSFT%'

  • Related Language Record for PTPP_CPPGLT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    2 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    3 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    4 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Pagelet Name
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Pagelet Label