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.

[Home] [Help]

View: OKL_INSURANCE_AGENT_V

Product:	OKL - Leasing and Finance Management
Description:	This view stores Insurance Agent information
Implementation/DBA Data:	APPS.OKL_INSURANCE_AGENT_V

View Text

SELECT PRT.PARTY_ID
, '#' ID2
, PRT.PARTY_NAME
, PRT.PARTY_NUMBER
, PRT.CATEGORY_CODE
, PRT.STATUS
, PRT.THIRD_PARTY_FLAG
, PRT.PERSON_FIRST_NAME
, PRT.PERSON_MIDDLE_NAME
, PRT.PERSON_LAST_NAME
, PRT.PERSON_TITLE
, PRT.PERSON_ACADEMIC_TITLE
, PRT.EMAIL_ADDRESS
, 'THIRD_PARTY'
FROM HZ_PARTIES PRT
WHERE PRT.CATEGORY_CODE = 'INSURANCE_AGENT'
AND PRT.STATUS ='A'

Columns

Name
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