PC_AM_UNRETIRED

(SQL View)
 Index Back

Asset info from Asset Table

Subset of Asset information found in the Asset Management system. Used for prompting purposes in Projects.

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.PROFILE_ID , A.DESCR FROM PS_ASSET A WHERE A.GROUP_ASSET_FLAG <> 'G' AND A.ASSET_STATUS <> 'T' AND A.FINANCIAL_ASSET_SW = 'Y' AND A.ASSET_TYPE <> '200' AND EXISTS( SELECT 'X' FROM PS_ASSET_ACQ_DET D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.ASSET_ID = A.ASSET_ID AND D.CAPITALIZATION_SW = '2' )

  • Related Language Record: PC_AM_UNRET_LNG

    • # 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 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description