View: CS_INST_DETAIL_CONTACTS_V

Product:	CS - Service
Description:	This view lists the contact information pertaining to the Installation Details
Implementation/DBA Data:	APPS.CS_INST_DETAIL_CONTACTS_V

View Text

SELECT CS_CONTACT_ID
, CONTACT_ID
, CONTACT_TYPE
, SOURCE_OBJECT_ID LINE_INST_DETAIL_ID
, OBJECT_VERSION_NUMBER
, CONTACT_CATEGORY
FROM CS_CONTACTS
WHERE NVL(SVC_PROVIDER_FLAG
, 'N') = 'N'
AND SOURCE_OBJECT_CODE = 'INST_DETAIL'

Columns