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_ADDRESSES_V

Object Details

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

View Type

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

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADDRESS_USE	CHAR	(7)		Specifies either a bill-to or ship-to address.
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.
RGP_ID	VARCHAR2	(0)		The id from OKC_RULE_GROUPS_B for the rule group in which the rule appeared.
RUL_ID	VARCHAR2	(0)		The identifier from OKC_RULES_B for the rule that holds this address.
CHR_ID	NUMBER		Yes	The contract header identifier for this address.
CLE_ID	NUMBER		Yes	The contract line identifier for this address, if at the line level.
CONTRACT_NUMBER	VARCHAR2	(120)		The contract number in which this address is used.
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.
SCS_CODE	VARCHAR2	(30)		The category (sub-class) code for the contract.

Query Text

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


SELECT ADDRESS_USE
,      SITE_USE_ID
,      PARTY_SITE_ID
,      LOCATION_ID
,      RGP_ID
,      RUL_ID
,      CHR_ID
,      CLE_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      LINE_NUMBER
,      NAME
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      FORMAT_ADDRESS
,      SCS_CODE
FROM APPS.OKI_ADDRESSES_V;

Dependencies

[top of page]

APPS.OKI_ADDRESSES_V references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; OKI_SOLD_ITM_LINES; OKX_CUST_SITE_USES_V

APPS.OKI_ADDRESSES_V is not referenced by any database object