PC_AM_DFNRL_LVW

(SQL View)
 Index Back

PC manual assets language view

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

SELECT A.BUSINESS_UNIT_AM ,A.ASSET_ID , D.LANGUAGE_CD ,D.DESCR FROM PS_PC_AM_DEFN A , PS_PC_AM_DEFN_LNG D WHERE %Join(COMMON_KEYS, PC_AM_DEFN A ,PC_AM_DEFN_LNG D) AND 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 <> '1')

  • Related Language Record for PC_AM_DFNRUL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description