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: OKX_INSURER_V

Product:	OKX - Contracts Integration
Description:	Insurance Agency.
Implementation/DBA Data:	APPS.OKX_INSURER_V

View Text

SELECT PRT.PARTY_ID
, '#' ID2
, PRT.PARTY_NAME
, PRT.PARTY_NUMBER
, PRT.CATEGORY_CODE
, PRT.ADDRESS1
, PRT.ADDRESS2
, PRT.ADDRESS3
, PRT.ADDRESS4
, PRT.CITY
, PRT.POSTAL_CODE
, PRT.STATE
, PRT.COUNTRY
, PRT.PROVINCE
, PRT.STATUS
, PRT.COUNTY
, 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
, PRT.ADDRESS1 ||'
, ' ||PRT.ADDRESS2||'
, '||PRT.ADDRESS3||'
, '||PRT.ADDRESS4||'
, '||PRT.CITY||'
, '||PRT.POSTAL_CODE||'
, '||PRT.STATE||'
, '||PRT.COUNTRY||'
, '||PRT.PROVINCE||'
, '||PRT.COUNTY ADDRESS
, HPS.PARTY_SITE_ID
, 'THIRD_PARTY'
FROM HZ_PARTIES PRT
, HZ_PARTY_SITES HPS
WHERE PRT.CATEGORY_CODE = 'INSURER'
AND PRT.PARTY_ID = HPS.PARTY_ID

Columns

Name
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
SITE_ID
INSURER_TYPE