DEPRCMP_LN_SRCH

(SQL View)
Index Back

Search record for What If depr


SELECT DISTINCT BOOK.RUN_ID , BOOK.BUSINESS_UNIT , BOOK.ASSET_ID , A.LANGUAGE_CD , A.DESCR FROM PS_DEPR_BOOK BOOK , PS_ASSET ASSET , PS_ASSET_LANG A WHERE BOOK.BUSINESS_UNIT = ASSET.BUSINESS_UNIT AND BOOK.ASSET_ID = ASSET.ASSET_ID AND BOOK.BUSINESS_UNIT = A.BUSINESS_UNIT AND BOOK.ASSET_ID = A.ASSET_ID

  • Related Language Record for DEPR_COMP_SRCH
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_ID Character(25) VARCHAR2(25) NOT NULL Run ID
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description