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_SHIP_TO_ADDRS_V

Object Details

Object Name:	OKI_SHIP_TO_ADDRS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKI.OKI_SHIP_TO_ADDRS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view shows the ship to addresses for contracts in OKI_SALES_K_HDRS. There may be multiple ship to addresses for the same contract.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SITE_USE_ID	NUMBER	(15)		The internal identifier from HZ_CUST_SITE_USES_ALL
PARTY_SITE_ID	NUMBER	(15)	Yes	The internal identifer for the party site referenced by this address.
LOCATION_ID	NUMBER	(15)	Yes	The identifier from HZ_LOCATIONS for this location.
RULE_ID	VARCHAR2	(0)		The internal identifier of the rule that holds this address.
CONTRACT_ID	NUMBER		Yes	The contract header identifier for this address.
CONTRACT_LINE_ID	NUMBER		Yes	The contract line identifier for this address, if at the line level.
CONTRACT_NUMBER	VARCHAR2	(120)		Contract number for this contract.
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		The contract number modifier in which this address is used.
LINE_NUMBER	VARCHAR2	(150)		The external contract line number to which the address is associated, if at line level.
NAME	VARCHAR2	(40)	Yes	The name associated with the address.
COUNTRY	VARCHAR2	(60)	Yes	The country of the address.
ADDRESS1	VARCHAR2	(240)	Yes	The first address line.
ADDRESS2	VARCHAR2	(240)		The second address line.
ADDRESS3	VARCHAR2	(240)		The third address line.
ADDRESS4	VARCHAR2	(240)		The fourth address line.
CITY	VARCHAR2	(60)		The address city.
POSTAL_CODE	VARCHAR2	(60)		The address postal code.
STATE	VARCHAR2	(60)		The address state, if appropriate.
PROVINCE	VARCHAR2	(60)		The address province, if appropriate.
COUNTY	VARCHAR2	(60)		The address county, if appropriate.
FORMAT_ADDRESS	VARCHAR2	(0)		The address formatted as a string.

Query Text

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


SELECT SITE_USE_ID
,      PARTY_SITE_ID
,      LOCATION_ID
,      RULE_ID
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      LINE_NUMBER
,      NAME
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      FORMAT_ADDRESS
FROM APPS.OKI_SHIP_TO_ADDRS_V;

Dependencies

[top of page]

APPS.OKI_SHIP_TO_ADDRS_V references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; OKC_UTIL - show dependent code; OKI_SOLD_ITM_LINES; OKX_CUST_SITE_USES_V

APPS.OKI_SHIP_TO_ADDRS_V is not referenced by any database object