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_OTM_LOCATIONS_REC_TYPE

Object Details

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

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
TXN_CODE	VARCHAR2	(10)
LOCATION_XID	VARCHAR2	(50)
LOCATION_DN	VARCHAR2	(50)
LOCATION_NAME	VARCHAR2	(120)
CITY	VARCHAR2	(30)
PROVINCE	VARCHAR2	(30)
PROVINCE_CODE	VARCHAR2	(2)
POSTAL_CODE	VARCHAR2	(15)
COUNTRY_CODE_XID	VARCHAR2	(3)
COUNTRY_CODE_DN	VARCHAR2	(50)
CORPORATION	VARCHAR2	(30)
IS_SHIPPER_KNOWN	VARCHAR2	(1)
LOCATION_ROLE_XID	VARCHAR2	(30)
LOCATION_ROLE_DN	VARCHAR2	(50)
PARENT_LOCATION_XID	VARCHAR2	(50)
PARENT_LOCATION_DN	VARCHAR2	(50)
SUBSTITUTE_LOCATION_XID	VARCHAR2	(50)
SUBSTITUTE_LOCATION_DN	VARCHAR2	(50)
SERVICE_PROV_TBL	WSH_OTM_SERVICE_PROV_TBL_TYPE
LOC_ADDR_TBL	WSH_OTM_LOC_ADDR_TBL_TYPE
LOC_REF_NUM_TBL	WSH_OTM_LOC_REF_NUM_TBL_TYPE
LOC_CONTACT_TBL	WSH_OTM_LOC_CONTACT_TBL_TYPE

Dependencies

[top of page]

APPS.WSH_OTM_LOCATIONS_REC_TYPE references the following:

APPS: WSH_OTM_LOC_ADDR_TBL_TYPE; WSH_OTM_LOC_CONTACT_TBL_TYPE; WSH_OTM_LOC_REF_NUM_TBL_TYPE; WSH_OTM_SERVICE_PROV_TBL_TYPE
SYS: STANDARD - show dependent code

APPS.WSH_OTM_LOCATIONS_REC_TYPE is referenced by following:

APPS: WSH_OTM_LOCATIONS_TBL_TYPE; WSH_OTM_REF_DATA_GEN_PKG - show dependent code