BUSINESS_UNITWAVE_CDDEMANDSLIP_VW9A(SQL View) |
Index Back |
|---|---|
Demand Packing Slip View |
| SELECT DISTINCT a.business_unit , b.wave_cd FROM PS_IN_DEMAND a , ps_wave_route_inv b WHERE in_fulfill_state BETWEEN '20' AND '70' AND ship_id <> ' ' AND DEPLETE_INV_FLG = 'Y' AND EXISTS ( SELECT 'X' FROM ps_wave_route_inv c WHERE a.business_unit = b.business_unit AND b.business_unit = c.business_unit AND b.wave_cd = c.wave_cd AND a.route_cd = b.route_cd AND b.route_cd = c.route_cd) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WAVE_CD |
Character(6) | VARCHAR2(6) NOT NULL | A unique identifier used to group together one or more delivery route codes. |