[Home] [Help] [Dependency Information]
Object Name: | WSH_OPSM_ASN_ITEM_GENEALOGY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSH_OPSM_ASN_ITEM_GENEALOGY_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NUMBER | VARCHAR2 | (4000) | ||
ITEM_UOM | VARCHAR2 | (100) | ||
LOT_NUMBER | VARCHAR2 | (255) | ||
GENEALOGY_OBJECT_ID | NUMBER | |||
DELIVERY_ID | NUMBER | |||
SERIAL_NUMBER | VARCHAR2 | (255) | ||
DELIVERY_DETAIL_ID | NUMBER | Yes | ||
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 | (4) | ||
ORGANIZATION_ID | NUMBER | |||
LOT_CONTROL_CODE | NUMBER | |||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | |||
OPSM_INTEGRATED_FLAG | VARCHAR2 | (3) | ||
SERIAL_TYPE | VARCHAR2 | (150) | ||
PARENT_LOT_NUMBER | VARCHAR2 | (255) | ||
PARENT_SERIAL_NUMBER | VARCHAR2 | (255) | ||
PARENT_INVENTORY_ITEM_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_NUMBER
, ITEM_UOM
, LOT_NUMBER
, GENEALOGY_OBJECT_ID
, DELIVERY_ID
, SERIAL_NUMBER
, DELIVERY_DETAIL_ID
, JOB_NAME
, HIERARCHY_LEVEL
, PARENT_HIERARCHY_LEVEL
, INVENTORY_ITEM_ID
, ORIGINATION_DATE
, BEST_BY_DATE
, RETEST_DATE
, EXPIRATION_DATE
, ORGANIZATION_CODE
, ORGANIZATION_ID
, LOT_CONTROL_CODE
, SERIAL_NUMBER_CONTROL_CODE
, OPSM_INTEGRATED_FLAG
, SERIAL_TYPE
, PARENT_LOT_NUMBER
, PARENT_SERIAL_NUMBER
, PARENT_INVENTORY_ITEM_ID
FROM APPS.WSH_OPSM_ASN_ITEM_GENEALOGY_V;
|
|
|