[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_WMS_CURR_UTZ_SUB_STG |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Fact table that stores the details of all the exceptions created in the warehouse by pick tasks and Operation plans, and the reasons for the exceptions.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization ID to which the subinventory belongs. | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory to which the locator belongs. | |
LOCATOR_ID | NUMBER | Locator whose capacities are being calculated. | ||
WEIGHT_CAPACITY_B | NUMBER | Weight Capacity in the locator weight UOM. | ||
WEIGHT_UOM_CODE | VARCHAR2 | (3) | UOM code of the locator volume capacity. | |
WEIGHT_CAPACITY_REP | NUMBER | Weight Capacity in the weight reporting UOM. | ||
VOLUME_CAPACITY_B | NUMBER | Volume Capacity in the locator volume UOM. | ||
VOLUME_UOM_CODE | VARCHAR2 | (3) | Volume unit of measure code. | |
VOLUME_CAPACITY_REP | NUMBER | Volume Capacity in the volume reporting UOM. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, WEIGHT_CAPACITY_B
, WEIGHT_UOM_CODE
, WEIGHT_CAPACITY_REP
, VOLUME_CAPACITY_B
, VOLUME_UOM_CODE
, VOLUME_CAPACITY_REP
FROM OPI.OPI_DBI_WMS_CURR_UTZ_SUB_STG;
OPI.OPI_DBI_WMS_CURR_UTZ_SUB_STG does not reference any database object
OPI.OPI_DBI_WMS_CURR_UTZ_SUB_STG is referenced by following:
|
|
|