BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
WAVE_CDBOL_WAVE2_VW(SQL View) |
Index Back |
|---|---|
BOL Dmd Wave 20-70 |
| SELECT DISTINCT a.business_unit , b.wave_cd FROM PS_IN_DEMAND a , ps_wave_route_inv b WHERE a.in_fulfill_state BETWEEN '20' AND '70' AND a.bill_of_lading = ' ' AND a.route_cd <> ' ' 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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | WAVE_CD |
Character(6) | VARCHAR2(6) NOT NULL | A unique identifier used to group together one or more delivery route codes. |