PARENTASSET_VW2

(SQL View)
 Index Back

Prompt tbl for financial paren

Prompt tbl for financial parent assets Used by P&C IUTs

SELECT P.BUSINESS_UNIT , P.PARENT_ID , A.TAG_NUMBER , A.ASSET_STATUS , P.DESCR FROM PS_PARENT_ASSET P , PS_ASSET A WHERE P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.PARENT_ID = A.ASSET_ID AND A.ASSET_STATUS NOT IN ('D','T')

  • Related Language Record: PARENTAST_L_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    3 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    4 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
    A=Received (Not in Service)
    B=Budgeted
    C=Commitment
    D=Disposed
    I=In Service
    M=Suspended
    R=Requisitioned
    T=Transferred
    W=Work In Progress
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description