CAP_ASSET_NF_VW

(SQL View)
 Index Back

Assets (non-Fin) by CAP Num


SELECT b.Business_Unit , b.CAP_Num , b.Asset_ID , b.Descr , b.Asset_Status , SUM(a.Amount) , b.Currency_cd FROM ps_Asset_Acq_det a , ps_Asset b , ps_Bus_unit_tbl_am c WHERE a.Business_Unit = b.Business_Unit AND a.Asset_ID = b.Asset_ID AND c.Business_Unit = b.Business_Unit AND b.financial_asset_sw = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_RETIREMENT R WHERE R.BUSINESS_UNIT = B.BUSINESS_UNIT AND R.ASSET_ID = B.ASSET_ID) GROUP BY b.Business_Unit, b.CAP_Num, b.Asset_ID, b.Descr, b.Asset_Status, b.Currency_cd

  • Related Language Record: CAP_ASSETNF_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    2 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #
    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 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
    6 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code