eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TYPE: APPS.WSH_OPSM_ASN_ITEMGENEALOGY_REC

Object Details

Object Name:	WSH_OPSM_ASN_ITEMGENEALOGY_REC
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
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)

Dependencies

[top of page]

APPS.WSH_OPSM_ASN_ITEMGENEALOGY_REC references the following:

SYS: STANDARD - show dependent code

APPS.WSH_OPSM_ASN_ITEMGENEALOGY_REC is referenced by following:

APPS: WSH_OPSM_ASN_BE_PKG - show dependent code; WSH_OPSM_ASN_ITEMGENEALOGY_TBL