VIEW: APPS.CS_INST_DETAIL_CONTACTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'