BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
VMI_OM_BUPrompt Table: OM_BU_NONVW
SHIP_TO_CUST_IDIN_VMI_OMSHP_VW(SQL View) |
Index Back |
|---|---|
Inventory LocationsInventory Locations |
| SELECT DISTINCT A.BUSINESS_UNIT , A.VMI_OM_BU , A.SHIP_TO_CUST_ID , C.NAME1 , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 FROM %Table(IN_STOR_LOC_VMI) A , PS_CUSTOMER C , PS_SET_CNTRL_REC CN WHERE CN.SETCNTRLVALUE = A.VMI_OM_BU AND CN.RECNAME = 'CUSTOMER' AND CN.SETID = C.SETID AND C.CUST_STATUS = 'A' AND A.SHIP_TO_CUST_ID = C.CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | VMI_OM_BU |
Character(5) | VARCHAR2(5) NOT NULL |
OM Business Unit Related to VMI
Prompt Table: OM_BU_NONVW |
| 3 | SHIP_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 5 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 6 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 7 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 8 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 9 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |