DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_OPSM_ASN_ITEM_GENEALOGY_V

Object Details
Object Name: WSH_OPSM_ASN_ITEM_GENEALOGY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_OPSM_ASN_ITEM_GENEALOGY_V
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.WSH_OPSM_ASN_ITEM_GENEALOGY_V references the following:

SchemaAPPS
TYPESYS_PLSQL_34FF91EB_306_1
ViewWSH_OPSM_ASN_ITEM_DETAILS_V
PL/SQL PackageWSH_OPSM_ASN_ITEM_GENEALOGY - show dependent code
APPS.WSH_OPSM_ASN_ITEM_GENEALOGY_V is referenced by following:

SchemaAPPS
Package BodyWSH_OPSM_ASN_BE_PKG - show dependent code