WM_INCLC_CP_VW

(SQL View)
 Index Back

Inspection Calc Parm View


SELECT A.SETID , A.INSPECTION_CODE AS CALCLT_PARM_CODE , '1' , A.INSP_MEASMT_TYPE AS INSP_CODE_SUBTYPE , A1.XLATLONGNAME AS INSP_CD_SUBTYP_LBL , A.DESCR50 , A.EFF_STATUS , A.MEASMT_DEVICE_TYPE , A.BASE_UOM , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MODEL FROM PS_WM_INSP_MMT_HDR A , PS_WM_INSP_CDSB_VW A1 WHERE A1.INSP_CODE_TYPE = '1' AND A1.INSP_CODE_SUBTYPE = A.INSP_MEASMT_TYPE UNION SELECT B.SETID , B.INSPECTION_CODE AS CALCLT_PARM_CODE , '2' , B.INSP_OBSRVN_TYPE AS INSP_CODE_SUBTYPE , B1.XLATLONGNAME AS INSP_CD_SUBTYP_LBL , B.DESCR50 , B.EFF_STATUS , ' ' , ' ' , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL FROM PS_WM_INSP_OBS_HDR B , PS_WM_INSP_CDSB_VW B1 WHERE B1.INSP_CODE_TYPE = '2' AND B1.INSP_CODE_SUBTYPE = B.INSP_OBSRVN_TYPE UNION SELECT C.SETID , C.INSPECTION_CODE AS CALCLT_PARM_CODE , '3' , C.INSP_CALCLT_TYPE AS INSP_CODE_SUBTYPE , C1.XLATLONGNAME AS INSP_CD_SUBTYP_LBL , C.DESCR50 , C.EFF_STATUS , ' ' , C.BASE_UOM , C.ASSET_TYPE , C.ASSET_SUBTYPE , C.MFG_ID , C.MODEL FROM PS_WM_INSP_CLC_HDR C , PS_WM_INSP_CDSB_VW C1 WHERE C.INSP_CALCLT_TYPE = '10' AND C1.INSP_CODE_TYPE = '3' AND C1.INSP_CODE_SUBTYPE = C.INSP_CALCLT_TYPE

  • Related Language Record: WM_INCLC_CP_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 CALCLT_PARM_CODE Character(20) VARCHAR2(20) NOT NULL Inspection Code
    3 INSP_CODE_TYPE Character(1) VARCHAR2(1) NOT NULL Inspection Code Type
    1=Measurement
    2=Observation
    3=Calculation
    4 INSP_CODE_SUBTYPE Character(2) VARCHAR2(2) NOT NULL Inspection Code Subtype

    Prompt Table: WM_INSP_CDSB_VW

    5 INSP_CD_SUBTYP_LBL Character(30) VARCHAR2(30) NOT NULL Inspection Code Subtype
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    8 MEASMT_DEVICE_TYPE Character(30) VARCHAR2(30) NOT NULL Measurement Device Type
    9 BASE_UOM Character(3) VARCHAR2(3) NOT NULL Base Unit of Measure

    Prompt Table: UNITS_TBL

    10 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
    11 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

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

    Prompt Table: WM_MANUFACTURER

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

    Prompt Table: WM_WO_MFGMOD_VW