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.OKX_INSURANCE_AGENT_V

Object Details

Object Name:	OKX_INSURANCE_AGENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_INSURANCE_AGENT_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	Party identifier
ID2	CHAR	(1)		Reserved for future use.
PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party.
PARTY_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
CATEGORY_CODE	VARCHAR2	(30)		User-definable category. Lookup type is CUSTOMER_CATEGORY.
ADDRESS1	VARCHAR2	(240)		First line of the identifying address.
ADDRESS2	VARCHAR2	(240)		Second line of the identifying address.
ADDRESS3	VARCHAR2	(240)		Third line of the identifying address.
ADDRESS4	VARCHAR2	(240)		Fourth line of the identifying address.
CITY	VARCHAR2	(60)		City of the identifying address.
POSTAL_CODE	VARCHAR2	(60)		Code of the identifying address
STATE	VARCHAR2	(60)		State of the identifying address
COUNTRY	VARCHAR2	(60)		Country of the identifying address.
PROVINCE	VARCHAR2	(60)		Province of the identifying address.
STATUS	VARCHAR2	(1)	Yes	Party status flag.
COUNTY	VARCHAR2	(60)		County of the identifying address.
THIRD_PARTY_FLAG	VARCHAR2	(1)		Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory.
FIRST_NAME	VARCHAR2	(150)		First name of the person.
MIDDLE_NAME	VARCHAR2	(60)		Middle name of the person
LAST_NAME	VARCHAR2	(150)		Last name of the person
TITLE	VARCHAR2	(60)		A professional or family title. For example, Don or The Right Honorable.
ACADEMIC_TITLE	VARCHAR2	(30)		Academic title that is part of a person's name, such as Dr. John Smith.
EMAIL_ADDRESS	VARCHAR2	(2000)		E- mail address.
ADDRESS	VARCHAR2	(1329)		Identifying address.
AGENT_SITE_ID	NUMBER	(15)	Yes	Agent party site identifier.
AGENT_TYPE	CHAR	(11)		Not used.

Query Text

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


SELECT PARTY_ID
,      ID2
,      PARTY_NAME
,      PARTY_NUMBER
,      CATEGORY_CODE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      COUNTRY
,      PROVINCE
,      STATUS
,      COUNTY
,      THIRD_PARTY_FLAG
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      TITLE
,      ACADEMIC_TITLE
,      EMAIL_ADDRESS
,      ADDRESS
,      AGENT_SITE_ID
,      AGENT_TYPE
FROM APPS.OKX_INSURANCE_AGENT_V;

Dependencies

[top of page]

APPS.OKX_INSURANCE_AGENT_V references the following:

APPS: HZ_PARTIES; HZ_PARTY_SITES

APPS.OKX_INSURANCE_AGENT_V is referenced by following:

APPS: OKL_INS_POLICIES_UV