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]

VIEW: APPS.OKI_HSHIPTO_DTL_V

Object Details

Object Name:	OKI_HSHIPTO_DTL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

Shipping information for a contract. Includes information like shipping party, location ,party account etc

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SHIP_SITE_ID	NUMBER	(15)	Yes	identifier used to identify the shipping address of the customer account
SHIP_TO_PARTY_ACCOUNT	VARCHAR2	(603)		Shipping Party Account
SHIP_TO_LOCATION	VARCHAR2	(40)	Yes	Shipping Location
SHIP_TO_ADDRESS1	VARCHAR2	(240)	Yes	Shipping Address1
SHIP_TO_ADDRESS2	VARCHAR2	(240)		Shipping Address2
SHIP_TO_ADDRESS3	VARCHAR2	(240)		Shipping Address3
SHIP_TO_CITY	VARCHAR2	(60)		City for shipping
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)		Postal Code of Shipping Site
SHIP_TO_STATE	VARCHAR2	(60)		Ship to State
SHIP_TO_COUNTRY	VARCHAR2	(60)	Yes	Ship to Country

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SHIP_SITE_ID
,      SHIP_TO_PARTY_ACCOUNT
,      SHIP_TO_LOCATION
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_CITY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_STATE
,      SHIP_TO_COUNTRY
FROM APPS.OKI_HSHIPTO_DTL_V;

Dependencies

[top of page]

APPS.OKI_HSHIPTO_DTL_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES

APPS.OKI_HSHIPTO_DTL_V is not referenced by any database object