PC_AM_EXP45_LVW

(SQL View)
 Index Back

PC AM Exp: Express view

Views combination of activity level rules, asset definition and the relationship between assets and a project.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , 'CLS' , B.BUSINESS_UNIT_AM , B.ASSET_ID , 0 , D.LANGUAGE_CD , D.DESCR FROM PS_PC_AM_PROJ_DEFN A , PS_PC_AM_DEFN B , PS_PC_AM_RULE_ACT C , PS_PC_AM_DEFN_LNG D WHERE %Join(COMMON_KEYS, PC_AM_PROJ_DEFN A, PC_AM_DEFN B) AND %Join(COMMON_KEYS, PC_AM_PROJ_DEFN A, PC_AM_RULE_ACT C) AND %Join(COMMON_KEYS, PC_AM_DEFN B, PC_AM_DEFN_LNG D) AND B.AM_DISTRIB_STATUS <> 'I' AND C.PC_AM_CAP_SW = 'Y'

  • Related Language Record for PC_AM_EXP4_VW PC_AM_EXP5_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    4 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    6 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Default Value: NEXT

    Prompt Table: PC_AM_DFNEXP_VW

    7 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number

    Default Value: 0

    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description