[Home] [Help]
View: WMS_DEPTS_V
Product: | WMS - Warehouse Management |
Description: | View of existing departments |
Implementation/DBA Data: |
APPS.WMS_DEPTS_V
|
View Text
SELECT DISTINCT ORGANIZATION_ID
, ORGANIZATION_CODE
, DEPARTMENT_ID
, DEPARTMENT_CODE
, DEPARTMENT_DESCRIPTION
FROM WMS_DEPT_SUBINVENTORIES_V
Columns
Name |
ORGANIZATION_ID |
ORGANIZATION_CODE |
DEPARTMENT_ID |
DEPARTMENT_CODE |
DEPARTMENT_DESCRIPTION |