[Home] [Help]
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
Name |
LINE_INST_DETAIL_ID |
CONTACT_TYPE_CODE |
CONTACT_TYPE |
CONTACT_NAME |
CONT_FIRST_NAME |
CONT_LAST_NAME |
CONTACT_ID |
OBJECT_VERSION_NUMBER |
CS_CONTACT_ID |
CONTACT_CATEGORY |