AM_LOOKUP_VW2

(SQL View)
 Index Back

SELECT DISTINCT A.ASSET_ID , A.BUSINESS_UNIT , C.CF_SEQNO , A.ASSET_STATUS , A.DESCR , A.PARENT_ID , A.TAG_NUMBER , A.PROFILE_ID , A.SERIAL_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , C.GROUP_ASSET_ID , %subrec(CF12_AN_SBR, C) , C.PROJECT_ID , C.DEPTID , C.CATEGORY , C.COST_TYPE , E.LOCATION , C.QUANTITY , C.COST , C.FROM_CUR , A.GROUP_ASSET_FLAG FROM PS_ASSET A , PS_COST_BAL_VW0 C , PS_ASSET_LOCATION E , PS_SP_BU_AM_NONVW F , PS_BUS_UNIT_TBL_AM G WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ASSET_ID = C.ASSET_ID AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.ASSET_ID = E.ASSET_ID AND A.BUSINESS_UNIT = F.BUSINESS_UNIT AND C.BUSINESS_UNIT = G.BUSINESS_UNIT AND C.BOOK = G.DEFAULT_BOOK AND NOT EXISTS ( SELECT 'X' FROM PS_ASSET_ACQ_DET WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND ASSET_ID = A.ASSET_ID) AND %Sql(AM_LOC_EFFDT_EFFSEQ)

  • Related Language Record: AM_LOOKUP_LNVW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence 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
    6 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID
    7 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    8 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    10 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    11 PROJECT_ID_ACQ Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    12 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    13 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    14 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    15 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    16 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    17 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    18 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
    19 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
    20 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
    21 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    22 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
    23 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
    24 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
    25 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
    26 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    27 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    28 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
    29 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    30 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    31 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    32 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    33 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
    34 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
    35 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    36 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
    37 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    39 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
    G=Group Asset
    M=Group Member
    N=None