[Home] [Help] [Dependency Information]
Object Name: | WSH_OPSM_ASN_ITEMGENEALOGY_REC |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
ITEM_NUMBER | VARCHAR2 | (32000) | |
ITEM_UOM | VARCHAR2 | (100) | |
LOT_NUMBER | VARCHAR2 | (32) | |
GENEALOGY_OBJECT_ID | NUMBER |
|
|
DELIVERY_ID | NUMBER |
|
|
SERIAL_NUMBER | VARCHAR2 | (30) | |
DELIVERY_DETAIL_ID | NUMBER |
|
|
JOB_NAME | VARCHAR2 | (255) | |
HIERARCHY_LEVEL | NUMBER |
|
|
PARENT_HIERARCHY_LEVEL | NUMBER |
|
|
INVENTORY_ITEM_ID | NUMBER |
|
|
ORIGINATION_DATE | DATE |
|
|
BEST_BY_DATE | DATE |
|
|
RETEST_DATE | DATE |
|
|
EXPIRATION_DATE | DATE |
|
|
ORGANIZATION_CODE | VARCHAR2 | (3) | |
ORGANIZATION_ID | NUMBER |
|
|
LOT_CONTROL_CODE | NUMBER |
|
|
SERIAL_NUMBER_CONTROL_CODE | NUMBER |
|
|
OPSM_INTEGRATED_FLAG | VARCHAR2 | (3) | |
SERIAL_TYPE | VARCHAR2 | (150) | |
SERIAL_IDENTIFICATION | VARCHAR2 | (1000) | |
PARENT_IDENTIFICATION | VARCHAR2 | (1000) | |
OPSM_PARENT_IDENTIFICATION | VARCHAR2 | (1000) |
|
|
|