WM_ARM_PCR_VW

(SQL View)
 Index Back

WO ARM Problem Group View

Work Order Asset Repository Problem Group View: cross references ARM assets with corresponding active PCR Problem Group definitions

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT_AM , B.ASSET_ID , C.PROBLEM_GROUP , C.DESCR50 FROM PS_WM_BU_AM_VW A , PS_WM_ARM_CLSF_VW B , PS_WM_BUPCR_EFF_VW C WHERE B.BUSINESS_UNIT_AM = A.BUSINESS_UNIT_AM AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND ((EXISTS ( SELECT 'X' FROM PS_WM_GROUP_ASSET J WHERE J.SETID = C.SETID AND J.PROBLEM_GROUP = C.PROBLEM_GROUP AND J.ASSET_TYPE = B.ASSET_TYPE AND J.ASSET_SUBTYPE IN (B.ASSET_SUBTYPE, ' ') AND J.MFG_ID IN (B.MFG_ID, ' ') AND J.MODEL IN (B.MODEL, ' '))) OR (NOT EXISTS ( SELECT 'X' FROM PS_WM_GROUP_ASSET K WHERE K.SETID = C.SETID AND K.PROBLEM_GROUP = C.PROBLEM_GROUP)))

  • Related Language Record: WM_ARM_PCR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    2 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    4 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50