BUSINESS_UNITPrompt Table: SP_BU_WM_NONVW
SHOP_IDPrompt Table: WM_SHOP_DEFN
CREW_IDPrompt Table: WM_CREW_DEFN
SCHED_PATTERNWM_PTRNMTRCS_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT S.BUSINESS_UNIT , S.SHOP_ID , S.CREW_ID , SCHED_PATTERN FROM PS_WM_CREWSCHED S WHERE 1 <= ( SELECT COUNT(*) FROM PS_WM_CREWSCHED_MT M WHERE %Join(COMMON_FIELDS, WM_CREWSCHED S, WM_CREWSCHED_MT M)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 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
Prompt Table: WM_CREW_DEFN |
| 4 | SCHED_PATTERN |
Character(5) | VARCHAR2(5) NOT NULL | Schedule Pattern |