WM_WO_IN_BU_VW

(SQL View)
Index Back

WM Inventory BU Prompt view

Prompt view based on Work Order Business Unit GL. Inventory business unit's GL business unit must match the Work Order's GL business unit.

SELECT B.BUSINESS_UNIT , C.BUSINESS_UNIT_GL , C.BUSINESS_UNIT , D.DESCR , D.DESCRSHORT FROM PS_SET_CNTRL_REC A , PS_BUS_UNIT_TBL_FS B , PS_BUS_UNIT_TBL_IN C , PS_BUS_UNIT_TBL_FS D WHERE A.SETCNTRLVALUE = B.BUSINESS_UNIT AND A.RECNAME = 'MASTER_ITEM_TBL' AND A.SETID = ( SELECT DISTINCT X.SETID FROM PS_SET_CNTRL_REC X WHERE X.SETCNTRLVALUE = C.BUSINESS_UNIT AND X.RECNAME = 'MASTER_ITEM_TBL') AND C.BUSINESS_UNIT = D.BUSINESS_UNIT

  • Related Language Record: BUS_UNIT_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    3 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description