WM_CREW_DEF2_VW

(SQL View)
 Index Back

Crew Definition


SELECT BUSINESS_UNIT , SHOP_ID , CREW_ID , DESCR FROM PS_WM_CREW_DEFN WHERE EXISTS ( SELECT 'X' FROM PS_WM_CREW_HDR B WHERE PS_WM_CREW_DEFN.BUSINESS_UNIT = B.BUSINESS_UNIT AND PS_WM_CREW_DEFN.SHOP_ID = B.SHOP_ID AND PS_WM_CREW_DEFN.CREW_ID = B.CREW_ID AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_WM_CREW_HDR C WHERE C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.SHOP_ID = B.SHOP_ID AND C.CREW_ID = B.CREW_ID AND C.EFFDT <= %CurrentDateIn ))

  • Related Language Record: WM_CREWDEF2_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
    2 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

    Prompt Table: WM_SHOP_DEFN

    3 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description