AM_LOOKUP_VW4

(SQL View)
 Index Back

SELECT DISTINCT A.ASSET_ID , A.BUSINESS_UNIT , 1 , A.ASSET_STATUS , A.DESCR , A.PARENT_ID , A.TAG_NUMBER , A.PROFILE_ID , A.SERIAL_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %Sql(FS_CF_SPACES) , ' ' , ' ' , ' ' , E.LOCATION , 0 , 0 , A.CURRENCY_CD , A.GROUP_ASSET_FLAG FROM PS_ASSET A , PS_ASSET_LOCATION E , PS_SP_BU_AM_NONVW F WHERE A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.ASSET_ID = E.ASSET_ID AND A.BUSINESS_UNIT = F.BUSINESS_UNIT AND NOT EXISTS ( SELECT 'X' FROM PS_ASSET_ACQ_DET H WHERE H.BUSINESS_UNIT = A.BUSINESS_UNIT AND H.ASSET_ID = A.ASSET_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_COST C , PS_BUS_UNIT_TBL_AM G WHERE C. BUSINESS_UNIT = A.BUSINESS_UNIT AND C.ASSET_ID = A.ASSET_ID AND C.BUSINESS_UNIT = G.BUSINESS_UNIT AND C.BOOK = G.DEFAULT_BOOK) 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 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    13 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    14 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    15 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    16 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    17 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    18 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    19 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
    20 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
    21 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
    22 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    23 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
    24 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
    25 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
    26 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
    27 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    28 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    29 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
    30 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    31 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    32 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    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