PC_AM_EXP1_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' , C.BUSINESS_UNIT_AM , C.ASSET_ID , D.LANGUAGE_CD , D.DESCR FROM PS_PC_AM_RULE_ACT A , PS_PC_AM_PROJ_DEFN B , PS_PC_AM_DEFN C , PS_PC_AM_DEFN_LNG D WHERE %Join(COMMON_KEYS, PC_AM_RULE_ACT A, PC_AM_PROJ_DEFN B) AND %Join(COMMON_KEYS, PC_AM_PROJ_DEFN B, PC_AM_DEFN C) AND %Join(COMMON_KEYS, PC_AM_DEFN C, PC_AM_DEFN_LNG D) AND C.AM_DISTRIB_STATUS <> 'I'

  • Related Language Record for PC_AM_EXP1_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description