PC_ANTP_VER_LVW

(SQL View)
 Index Back

Analysis Type Versioning View

Language record for PC_ANTYP_VER Returns the analysis types that are not part of one of the configured PC budgeting analysis groups. Used as a prompt in the versioning configuration page.

SELECT B.BUSINESS_UNIT , A.ANALYSIS_TYPE , A.LANGUAGE_CD , A.DESCR FROM PS_PROJ_ANTYPE_LNG A , PS_BUS_UNIT_OPT_PC B WHERE NOT EXISTS ( SELECT 'X' FROM PS_PROJ_AN_GRP_MAP C , PS_INSTALLATION_PC E WHERE C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = B.BUSINESS_UNIT AND RECNAME = 'PROJ_AN_GRP_MAP') AND C.ANALYSIS_TYPE = A.ANALYSIS_TYPE AND C.ANALYSIS_GROUP IN (E.AN_GRP_ACTV_BUD,E.PC_REV_BUD_AN_GRP,E.AN_GRP_TOT_COSTS,E.AN_GRP_TOT_REV) )

  • Related Language Record for PC_ANTYP_VER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJECT.BUSINESS_UNIT

    2 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description