RF_AST_STYPE_VW

(SQL View)
 Index Back

Asset reconciliation subtypes

Prompt for asset subtype values for reconciliation entries

SELECT MAX(A.BUSINESS_UNIT) , B.ASSET_SUBTYPE , B.DESCR FROM PS_RF_ASSET_RECON A , PS_AM_SUBTYPE B , PS_SET_CNTRL_REC R WHERE R.RECNAME = 'AM_SUBTYPE' AND A.BUSINESS_UNIT = R.SETCNTRLVALUE AND B.SETID = R.SETID AND A.AM_ASSET_TYPE = B.AM_ASSET_TYPE GROUP BY BUSINESS_UNIT, B.ASSET_SUBTYPE, B.DESCR

  • Related Language Record: RF_AST_STYP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL This field is used in the problem tree in work management.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description