WM_INSTP_WHR_VW

(SQL View)
 Index Back

Instrument Type Where-Used Vw


SELECT A.SETID , A.MEAS_INSTRMT_TYPE , B.INSPECTION_CODE , B.INSP_MEASMT_TYPE , B.DESCR50 , B.EFF_STATUS , B.MEASMT_DEVICE_TYPE , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , B.BASE_UOM , B.MEASMT_PRECIS_INT , B.MEASMT_NEGINT_FLG , B.MEASMT_PRECIS_DEC , B.MEASMT_TOLER_OPT , B.LOWER_TOLERANCE , B.UPPER_TOLERANCE FROM PS_WM_INSTRMT_TYPE A , PS_WM_INSP_MMT_HDR B WHERE B.SETID = A.SETID AND B.INSP_MEASMT_TYPE = '2' AND B.MEASMT_DEVICE_TYPE = A.MEAS_INSTRMT_TYPE

  • Related Language Record: WM_INSTP_WHR_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 MEAS_INSTRMT_TYPE Character(30) VARCHAR2(30) NOT NULL Measuring Instrument Type
    3 INSPECTION_CODE Character(20) VARCHAR2(20) NOT NULL Inspection Code
    4 INSP_MEASMT_TYPE Character(1) VARCHAR2(1) NOT NULL Measurement Type
    1=Asset Meter
    2=Instrument
    3=Non-Technical
    4=Sample
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 MEASMT_DEVICE_TYPE Character(30) VARCHAR2(30) NOT NULL Measurement Device Type

    Prompt Table: %EDITTABLE

    8 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    9 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    10 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: WM_MANUFACTURER

    11 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: WM_WO_MFGMOD_VW

    12 BASE_UOM Character(3) VARCHAR2(3) NOT NULL Base Unit of Measure

    Prompt Table: %EDITTABLE2

    13 MEASMT_PRECIS_INT Number(2,0) SMALLINT NOT NULL Integer Digits
    14 MEASMT_NEGINT_FLG Character(1) VARCHAR2(1) NOT NULL Allow Negative Value

    Y/N Table Edit

    15 MEASMT_PRECIS_DEC Number(1,0) SMALLINT NOT NULL Decimal Digits
    16 MEASMT_TOLER_OPT Character(1) VARCHAR2(1) NOT NULL Measurement Tolerance Option
    0=None
    1=Range
    17 LOWER_TOLERANCE Signed Number(21,4) DECIMAL(19,4) NOT NULL Lower Tolerance
    18 UPPER_TOLERANCE Signed Number(21,4) DECIMAL(19,4) NOT NULL Upper Tolerance