WM_BUPCR_EFF_VW

(SQL View)
 Index Back

WO BU Prob Grp Eff View

Work Order Bus Unit Problem Group Effective View: cross references WO Bus Units with corresponding active PCR Problem Group definitions

SELECT A.BUSINESS_UNIT , B.SETID , B.PROBLEM_GROUP , B.DESCR50 FROM PS_BUS_UNIT_TBL_WM A , PS_WM_PCR_GROUP B WHERE B.SETID = ( SELECT DISTINCT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.REC_GROUP_ID = 'WM_01' AND I.SETCNTRLVALUE = A.BUSINESS_UNIT) AND B.EFF_STATUS = 'A'

  • Related Language Record: WM_BUPCR_EFF_LV

    • # 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    3 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50