PC_AM_DFNRUL_VW

(SQL View)
 Index Back

PC manual assets

View Project's asset definitions that are not already related to a non-manual project.

SELECT A.BUSINESS_UNIT_AM ,A.ASSET_ID ,A.DESCR ,A.PROFILE_ID FROM PS_PC_AM_DEFN A WHERE NOT EXISTS ( SELECT 'X' FROM PS_PC_AM_RULE_ACT B , PS_PC_AM_PROJ_DEFN C WHERE %Join(COMMON_KEYS, PC_AM_RULE_ACT B ,PC_AM_PROJ_DEFN C) AND %Join(COMMON_KEYS, PC_AM_DEFN A ,PC_AM_PROJ_DEFN C) AND B.PC_AM_CAP_RULE NOT IN ('1','6'))

  • Related Language Record: PC_AM_DFNRL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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

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

    Prompt Table: PC_AM_DFNRUL_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID