PC_ASTID_VW_LNG

(SQL View)
 Index Back

PC Rel Lang view of Asset Tbl


SELECT A.BUSINESS_UNIT , A.ASSET_ID , B.LANGUAGE_CD , B.DESCR FROM PS_ASSET A , PS_ASSET_LANG B WHERE %Join(COMMON_KEYS, ASSET A, ASSET_LANG B) AND A.ASSET_TYPE <> '200'

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