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