[Home] [Help] [Dependency Information]
Object Name: | CSI_INV_DISCREPANCY_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | CSI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISCREPANCY_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
INV_REVISION | VARCHAR2 | (3) | ||
INV_LOT_NUMBER | VARCHAR2 | (80) | ||
INV_QUANTITY | NUMBER | |||
INV_ORGANIZATION_ID | NUMBER | |||
INV_SUBINVENTORY_NAME | VARCHAR2 | (10) | ||
INV_LOCATOR_ID | NUMBER | |||
INSTANCE_ID | NUMBER | |||
II_REVISION | VARCHAR2 | (3) | ||
II_LOT_NUMBER | VARCHAR2 | (80) | ||
II_QUANTITY | NUMBER | |||
II_LOCATION_TYPE_CODE | VARCHAR2 | (30) | ||
II_ORGANIZATION_ID | NUMBER | |||
II_SUBINVENTORY_NAME | VARCHAR2 | (10) | ||
II_LOCATOR_ID | NUMBER | |||
INSTANCE_USAGE_CODE | VARCHAR2 | (30) | ||
MASTER_ORG_TRACKABLE_FLAG | VARCHAR2 | (1) | ||
CHILD_ORG_TRACKABLE_FLAG | VARCHAR2 | (1) | ||
ERROR_TEXT | VARCHAR2 | (500) |
Cut, paste (and edit) the following text to query this object:
SELECT DISCREPANCY_ID
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, INV_REVISION
, INV_LOT_NUMBER
, INV_QUANTITY
, INV_ORGANIZATION_ID
, INV_SUBINVENTORY_NAME
, INV_LOCATOR_ID
, INSTANCE_ID
, II_REVISION
, II_LOT_NUMBER
, II_QUANTITY
, II_LOCATION_TYPE_CODE
, II_ORGANIZATION_ID
, II_SUBINVENTORY_NAME
, II_LOCATOR_ID
, INSTANCE_USAGE_CODE
, MASTER_ORG_TRACKABLE_FLAG
, CHILD_ORG_TRACKABLE_FLAG
, ERROR_TEXT
FROM CSI.CSI_INV_DISCREPANCY_TEMP#;
|
|
|