PC_AM_DEFN3_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 MAX(A.BUSINESS_UNIT) , MAX(A.PROJECT_ID) , B.BUSINESS_UNIT_AM , B.ASSET_ID , 0 , C.LANGUAGE_CD , MAX(C.DESCR) FROM PS_PC_AM_PROJ_DEFN A , PS_PC_AM_DEFN B , PS_PC_AM_DEFN_LNG C WHERE %Join(COMMON_KEYS, PC_AM_PROJ_DEFN A, PC_AM_DEFN B) AND %Join(COMMON_KEYS, PC_AM_DEFN B, PC_AM_DEFN_LNG C) AND B.AM_DISTRIB_STATUS <> 'I' GROUP BY B.BUSINESS_UNIT_AM, B.ASSET_ID, C.LANGUAGE_CD

  • Related Language Record for PC_AM_DEFN3_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 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

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

    Default Value: NEXT

    Prompt Table: PC_AM_DFNEXP_VW

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

    Default Value: 0

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description