View: CS_INST_CONTACT_DTLS_V

Product:	CS - Service
Description:	This view lists the details of the contacts pertaining to Installation Details
Implementation/DBA Data:	APPS.CS_INST_CONTACT_DTLS_V

View Text

SELECT IDC.LINE_INST_DETAIL_ID
, IDC.CONTACT_TYPE
, CSLK.MEANING
, P.PERSON_FIRST_NAME || DECODE(P.PERSON_FIRST_NAME
, NULL
, NULL
, ' ') || P.PERSON_LAST_NAME CONTACT_NAME
, P.PERSON_FIRST_NAME
, P.PERSON_LAST_NAME
, IDC.CONTACT_ID
, IDC.OBJECT_VERSION_NUMBER
, IDC.CS_CONTACT_ID
, IDC.CONTACT_CATEGORY
FROM CS_INST_DETAIL_CONTACTS_V IDC
, HZ_PARTIES P
, CS_LOOKUPS CSLK
WHERE IDC.CONTACT_ID = P.PARTY_ID
AND CSLK.LOOKUP_TYPE = 'CS_CONTACT_TYPE'
AND CSLK.LOOKUP_CODE = IDC.CONTACT_TYPE

Columns