WM_INPCD_WH1_VW

(SQL View)
 Index Back

Inspection Code Where-Used Vw1

Inspection Codes referenced as calculation parameters by Calculation Codes' detail lines

SELECT A.SETID , A.INSPECTION_CODE , B.INSPECTION_CODE AS INSP_CALCLT_CODE , B.INSP_CALCLT_TYPE , B.DESCR50 , B.EFF_STATUS , B.INSP_VALID_STATUS , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL FROM PS_WM_WO_INSPCD_VW A , PS_WM_INSP_CLC_HDR B WHERE B.SETID = A.SETID AND EXISTS ( SELECT 'X' FROM PS_WM_INSP_CLC_DTL I WHERE I.SETID = B.SETID AND I.INSPECTION_CODE = B.INSPECTION_CODE AND I.CALCLT_PARM_CODE = A.INSPECTION_CODE)

  • Related Language Record: WM_INPCD_WH1_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 INSPECTION_CODE Character(20) VARCHAR2(20) NOT NULL Inspection Code
    3 INSP_CALCLT_CODE Character(20) VARCHAR2(20) NOT NULL Calculation Code
    4 INSP_CALCLT_TYPE Character(2) VARCHAR2(2) NOT NULL Calculation Type
    10=Numeric
    20=Trigger
    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 INSP_VALID_STATUS Character(1) VARCHAR2(1) NOT NULL Validation Status
    0=Invalid
    1=Valid
    2=New
    4=Changed
    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
    10 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    11 MODEL Character(30) VARCHAR2(30) NOT NULL Model