VIEW: APPS.IGS_PE_CONTACTS_V

Source

View Text - Preformatted

SELECT CP.ROWID ROW_ID, CP.CONTACT_POINT_ID, CP.CONTACT_POINT_TYPE, CP.STATUS, L1.MEANING STATUS_MEANING, CP.OWNER_TABLE_NAME, CP.OWNER_TABLE_ID, CP.PRIMARY_FLAG, CP.ORIG_SYSTEM_REFERENCE, CP.LAST_UPDATE_DATE, CP.LAST_UPDATED_BY, CP.CREATION_DATE, CP.CREATED_BY, CP.LAST_UPDATE_LOGIN, TO_DATE(NULL) WH_UPDATE_DATE, CP.REQUEST_ID, CP.PROGRAM_APPLICATION_ID, CP.PROGRAM_ID, CP.PROGRAM_UPDATE_DATE, CP.ATTRIBUTE_CATEGORY, CP.ATTRIBUTE1, CP.ATTRIBUTE2, CP.ATTRIBUTE3, CP.ATTRIBUTE4, CP.ATTRIBUTE5, CP.ATTRIBUTE6, CP.ATTRIBUTE7, CP.ATTRIBUTE8, CP.ATTRIBUTE9, CP.ATTRIBUTE10, CP.ATTRIBUTE11, CP.ATTRIBUTE12, CP.ATTRIBUTE13, CP.ATTRIBUTE14, CP.ATTRIBUTE15, CP.ATTRIBUTE16, CP.ATTRIBUTE17, CP.ATTRIBUTE18, CP.ATTRIBUTE19, CP.ATTRIBUTE20, CP.EDI_TRANSACTION_HANDLING, CP.EDI_ID_NUMBER, CP.EDI_PAYMENT_METHOD, CP.EDI_PAYMENT_FORMAT, CP.EDI_REMITTANCE_METHOD, CP.EDI_REMITTANCE_INSTRUCTION, CP.EDI_TP_HEADER_ID, CP.EDI_ECE_TP_LOCATION_CODE, L3.MEANING EMAIL_FORMAT_MEANING, CP.EMAIL_FORMAT, CP.EMAIL_ADDRESS, CP.BEST_TIME_TO_CONTACT_START, CP.BEST_TIME_TO_CONTACT_END, CP.PHONE_CALLING_CALENDAR, CP.CONTACT_ATTEMPTS, CP.CONTACTS, CP.DECLARED_BUSINESS_PHONE_FLAG, CP.DO_NOT_USE_FLAG, CP.DO_NOT_USE_REASON, CP.LAST_CONTACT_DT_TIME, CP.PHONE_PREFERRED_ORDER, CP.PRIORITY_OF_USE_CODE, CP.TELEPHONE_TYPE, CP.TIME_ZONE, CP.PHONE_TOUCH_TONE_TYPE_FLAG, CP.PHONE_AREA_CODE, CP.PHONE_COUNTRY_CODE, CP.PHONE_NUMBER, CP.PHONE_EXTENSION, CP.PHONE_LINE_TYPE, L2.MEANING PHONE_LINE_TYPE_MEANING, CP.TELEX_NUMBER, CP.WEB_TYPE, CP.URL, CP.CONTENT_SOURCE_TYPE, CP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM HZ_CONTACT_POINTS CP, FND_LOOKUP_VALUES L1, FND_LOOKUP_VALUES L2, FND_LOOKUP_VALUES L3 WHERE CP.STATUS = L1.LOOKUP_CODE (+) AND L1.LOOKUP_TYPE (+) = 'REGISTRY_STATUS' AND l1.LANGUAGE (+) = USERENV('LANG') AND L1.VIEW_APPLICATION_ID (+) = 222 AND L1.SECURITY_GROUP_ID (+) = 0 AND CP.PHONE_LINE_TYPE = L2.LOOKUP_CODE (+) AND L2.LOOKUP_TYPE (+) = 'PHONE_LINE_TYPE' AND L2.LANGUAGE (+) = USERENV('LANG') AND L2.VIEW_APPLICATION_ID (+) = 222 AND L2.SECURITY_GROUP_ID (+) = 0 AND CP.EMAIL_FORMAT = L3.LOOKUP_CODE (+) AND L3.LOOKUP_TYPE (+) = 'EMAIL_FORMAT' AND L3.LANGUAGE (+) = USERENV('LANG') AND L3.VIEW_APPLICATION_ID (+) = 222 AND L3.SECURITY_GROUP_ID (+) = 0

View Text - HTML Formatted

SELECT CP.ROWID ROW_ID
, CP.CONTACT_POINT_ID
, CP.CONTACT_POINT_TYPE
, CP.STATUS
, L1.MEANING STATUS_MEANING
, CP.OWNER_TABLE_NAME
, CP.OWNER_TABLE_ID
, CP.PRIMARY_FLAG
, CP.ORIG_SYSTEM_REFERENCE
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_LOGIN
, TO_DATE(NULL) WH_UPDATE_DATE
, CP.REQUEST_ID
, CP.PROGRAM_APPLICATION_ID
, CP.PROGRAM_ID
, CP.PROGRAM_UPDATE_DATE
, CP.ATTRIBUTE_CATEGORY
, CP.ATTRIBUTE1
, CP.ATTRIBUTE2
, CP.ATTRIBUTE3
, CP.ATTRIBUTE4
, CP.ATTRIBUTE5
, CP.ATTRIBUTE6
, CP.ATTRIBUTE7
, CP.ATTRIBUTE8
, CP.ATTRIBUTE9
, CP.ATTRIBUTE10
, CP.ATTRIBUTE11
, CP.ATTRIBUTE12
, CP.ATTRIBUTE13
, CP.ATTRIBUTE14
, CP.ATTRIBUTE15
, CP.ATTRIBUTE16
, CP.ATTRIBUTE17
, CP.ATTRIBUTE18
, CP.ATTRIBUTE19
, CP.ATTRIBUTE20
, CP.EDI_TRANSACTION_HANDLING
, CP.EDI_ID_NUMBER
, CP.EDI_PAYMENT_METHOD
, CP.EDI_PAYMENT_FORMAT
, CP.EDI_REMITTANCE_METHOD
, CP.EDI_REMITTANCE_INSTRUCTION
, CP.EDI_TP_HEADER_ID
, CP.EDI_ECE_TP_LOCATION_CODE
, L3.MEANING EMAIL_FORMAT_MEANING
, CP.EMAIL_FORMAT
, CP.EMAIL_ADDRESS
, CP.BEST_TIME_TO_CONTACT_START
, CP.BEST_TIME_TO_CONTACT_END
, CP.PHONE_CALLING_CALENDAR
, CP.CONTACT_ATTEMPTS
, CP.CONTACTS
, CP.DECLARED_BUSINESS_PHONE_FLAG
, CP.DO_NOT_USE_FLAG
, CP.DO_NOT_USE_REASON
, CP.LAST_CONTACT_DT_TIME
, CP.PHONE_PREFERRED_ORDER
, CP.PRIORITY_OF_USE_CODE
, CP.TELEPHONE_TYPE
, CP.TIME_ZONE
, CP.PHONE_TOUCH_TONE_TYPE_FLAG
, CP.PHONE_AREA_CODE
, CP.PHONE_COUNTRY_CODE
, CP.PHONE_NUMBER
, CP.PHONE_EXTENSION
, CP.PHONE_LINE_TYPE
, L2.MEANING PHONE_LINE_TYPE_MEANING
, CP.TELEX_NUMBER
, CP.WEB_TYPE
, CP.URL
, CP.CONTENT_SOURCE_TYPE
, CP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM HZ_CONTACT_POINTS CP
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L3
WHERE CP.STATUS = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'REGISTRY_STATUS'
AND L1.LANGUAGE (+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID (+) = 222
AND L1.SECURITY_GROUP_ID (+) = 0
AND CP.PHONE_LINE_TYPE = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'PHONE_LINE_TYPE'
AND L2.LANGUAGE (+) = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID (+) = 222
AND L2.SECURITY_GROUP_ID (+) = 0
AND CP.EMAIL_FORMAT = L3.LOOKUP_CODE (+)
AND L3.LOOKUP_TYPE (+) = 'EMAIL_FORMAT'
AND L3.LANGUAGE (+) = USERENV('LANG')
AND L3.VIEW_APPLICATION_ID (+) = 222
AND L3.SECURITY_GROUP_ID (+) = 0