WM_BUPCR_EFF_LV

(SQL View)
 Index Back

WO BU Prob Grp Eff RL View

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

SELECT A.BUSINESS_UNIT , B.SETID , B.PROBLEM_GROUP , B.LANGUAGE_CD , B.DESCR50 FROM PS_BUS_UNIT_TBL_WM A , PS_WM_PCR_GROUP_LG 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)

  • Related Language Record for WM_BUPCR_EFF_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50