OMBCK_DSNSBU_VW(SQL View) |
Index Back |
|---|---|
OM DS Network SBU VWOM DS Network SBU VW |
| SELECT DISTINCT B.BUSINESS_UNIT, D.DS_NETWORK_CODE, D.BUSINESS_UNIT_IN FROM PS_BUS_UNIT_TBL_OM B, PS_SET_CNTRL_REC S, PS_DS_NETDET_TBL D WHERE S.SETID = D.SETID AND S.SETCNTRLVALUE = B.BUSINESS_UNIT AND S.RECNAME = 'DS_NETDET_TBL' AND D.PRIORITY_NBR = (SELECT MIN(D2.PRIORITY_NBR) FROM PS_DS_NETDET_TBL D2 WHERE D2.SETID = D.SETID AND D2.DS_NETWORK_CODE = D.DS_NETWORK_CODE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DS_NETWORK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Distribution Network Code |
| 3 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |