RF_AST_STYP_LVW

(SQL View)
 Index Back

Asset reconciliation subtypes

Language view Prompt for asset subtype values for reconciliation entries

SELECT MAX(A.BUSINESS_UNIT) , B.ASSET_SUBTYPE , B.LANGUAGE_CD , B.DESCR FROM PS_RF_ASSET_RECON A , PS_AM_SUBTYPE_LG 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,B.LANGUAGE_CD

  • Related Language Record for RF_AST_STYPE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description