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

Object Details

Object Name:	OKL_INSURANCE_AGENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_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)		(Multi-part) Primary Key
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
STATUS	VARCHAR2	(1)	Yes	Party status flag.
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.
FIRST_NAME	VARCHAR2	(150)		First name of the person
MIDDLE_NAME	VARCHAR2	(60)		Middle name of the person
LAST_NAME	VARCHAR2	(150)		Last or surname 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
AGENT_TYPE	CHAR	(11)		The Type of Agent, i.e. Third Party

Query Text

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


SELECT PARTY_ID
,      ID2
,      PARTY_NAME
,      PARTY_NUMBER
,      CATEGORY_CODE
,      STATUS
,      THIRD_PARTY_FLAG
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      TITLE
,      ACADEMIC_TITLE
,      EMAIL_ADDRESS
,      AGENT_TYPE
FROM APPS.OKL_INSURANCE_AGENT_V;

Dependencies

[top of page]

APPS.OKL_INSURANCE_AGENT_V references the following:

APPS: HZ_PARTIES

APPS.OKL_INSURANCE_AGENT_V is not referenced by any database object