[Home] [Help]
View: OKX_INS_PROVIDER_V
Product: | OKX - Contracts Integration |
Description: | Insurance providers |
Implementation/DBA Data: |
APPS.OKX_INS_PROVIDER_V
|
View Text
SELECT VEN.VENDOR_ID PARTY_ID
, '#' ID2
, VEN.VENDOR_NAME PARTY_NAME
, VEN.SEGMENT1 PARTY_NUMBER
, VEN.VENDOR_TYPE_LOOKUP_CODE CATEGORY_CODE
, 'INS_PROVIDER' INSURER_TYPE
FROM PO_VENDORS VEN
WHERE VEN.VENDOR_TYPE_LOOKUP_CODE = 'INSURER'
Columns
Name |
PARTY_ID |
ID2 |
PARTY_NAME |
PARTY_NUMBER |
CATEGORY_CODE |
INSURER_TYPE |