[Home] [Help]
View: OKL_INSURANCE_AGENT_V
Product: | OKL - Lease 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 |