VIEW: APPS.CSC_HZ_CONTACT_POINTS_V

Source

View Text - Preformatted

SELECT CONT_POINT.ROWID , CONT_POINT.CONTACT_POINT_ID , PARTY.PARTY_ID , PARTY.PARTY_NUMBER , PARTY.PARTY_NAME , PARTY.PERSON_FIRST_NAME , PARTY.PERSON_LAST_NAME , PARTY.PARTY_TYPE , CONT_POINT.LAST_UPDATE_DATE , CONT_POINT.OBJECT_VERSION_NUMBER , CONT_POINT.CONTACT_POINT_PURPOSE , CONT_POINT.LAST_UPDATED_BY , CONT_POINT.CREATION_DATE , CONT_POINT.CREATED_BY , CONT_POINT.PHONE_NUMBER , CONT_POINT.STATUS , CONT_POINT.TELEPHONE_TYPE , CONT_POINT.CONTACT_POINT_TYPE , CONT_POINT.PHONE_LINE_TYPE , CONT_POINT.LAST_UPDATE_LOGIN , CONT_POINT.PHONE_COUNTRY_CODE , CONT_POINT.PHONE_AREA_CODE , CONT_POINT.PHONE_EXTENSION , CONT_POINT.PRIMARY_FLAG , CONT_POINT.EMAIL_FORMAT , CONT_POINT.EMAIL_ADDRESS , CONT_POINT.ORIG_SYSTEM_REFERENCE , CONT_POINT.REQUEST_ID , CONT_POINT.PROGRAM_APPLICATION_ID , CONT_POINT.PROGRAM_ID , CONT_POINT.PROGRAM_UPDATE_DATE , CONT_POINT.TIME_ZONE , CONT_POINT.EDI_TRANSACTION_HANDLING , CONT_POINT.EDI_ID_NUMBER , CONT_POINT.EDI_PAYMENT_METHOD , CONT_POINT.EDI_PAYMENT_FORMAT , CONT_POINT.EDI_REMITTANCE_METHOD , CONT_POINT.EDI_REMITTANCE_INSTRUCTION , CONT_POINT.EDI_TP_HEADER_ID , CONT_POINT.EDI_ECE_TP_LOCATION_CODE , CONT_POINT.BEST_TIME_TO_CONTACT_START , CONT_POINT.BEST_TIME_TO_CONTACT_END , CONT_POINT.URL , CONT_POINT.WEB_TYPE , NULL , CONT_POINT.ATTRIBUTE_CATEGORY , CONT_POINT.ATTRIBUTE1 , CONT_POINT.ATTRIBUTE2 , CONT_POINT.ATTRIBUTE3 , CONT_POINT.ATTRIBUTE4 , CONT_POINT.ATTRIBUTE5 , CONT_POINT.ATTRIBUTE6 , CONT_POINT.ATTRIBUTE7 , CONT_POINT.ATTRIBUTE8 , CONT_POINT.ATTRIBUTE9 , CONT_POINT.ATTRIBUTE10 , CONT_POINT.ATTRIBUTE11 , CONT_POINT.ATTRIBUTE12 , CONT_POINT.ATTRIBUTE13 , CONT_POINT.ATTRIBUTE14 , CONT_POINT.ATTRIBUTE15 , PARTY.COUNTRY , CONT_POINT.TIMEZONE_ID FROM HZ_PARTIES PARTY, HZ_CONTACT_POINTS CONT_POINT WHERE CONT_POINT.OWNER_TABLE_ID = PARTY.PARTY_ID AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

View Text - HTML Formatted

SELECT CONT_POINT.ROWID
, CONT_POINT.CONTACT_POINT_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PARTY_TYPE
, CONT_POINT.LAST_UPDATE_DATE
, CONT_POINT.OBJECT_VERSION_NUMBER
, CONT_POINT.CONTACT_POINT_PURPOSE
, CONT_POINT.LAST_UPDATED_BY
, CONT_POINT.CREATION_DATE
, CONT_POINT.CREATED_BY
, CONT_POINT.PHONE_NUMBER
, CONT_POINT.STATUS
, CONT_POINT.TELEPHONE_TYPE
, CONT_POINT.CONTACT_POINT_TYPE
, CONT_POINT.PHONE_LINE_TYPE
, CONT_POINT.LAST_UPDATE_LOGIN
, CONT_POINT.PHONE_COUNTRY_CODE
, CONT_POINT.PHONE_AREA_CODE
, CONT_POINT.PHONE_EXTENSION
, CONT_POINT.PRIMARY_FLAG
, CONT_POINT.EMAIL_FORMAT
, CONT_POINT.EMAIL_ADDRESS
, CONT_POINT.ORIG_SYSTEM_REFERENCE
, CONT_POINT.REQUEST_ID
, CONT_POINT.PROGRAM_APPLICATION_ID
, CONT_POINT.PROGRAM_ID
, CONT_POINT.PROGRAM_UPDATE_DATE
, CONT_POINT.TIME_ZONE
, CONT_POINT.EDI_TRANSACTION_HANDLING
, CONT_POINT.EDI_ID_NUMBER
, CONT_POINT.EDI_PAYMENT_METHOD
, CONT_POINT.EDI_PAYMENT_FORMAT
, CONT_POINT.EDI_REMITTANCE_METHOD
, CONT_POINT.EDI_REMITTANCE_INSTRUCTION
, CONT_POINT.EDI_TP_HEADER_ID
, CONT_POINT.EDI_ECE_TP_LOCATION_CODE
, CONT_POINT.BEST_TIME_TO_CONTACT_START
, CONT_POINT.BEST_TIME_TO_CONTACT_END
, CONT_POINT.URL
, CONT_POINT.WEB_TYPE
, NULL
, CONT_POINT.ATTRIBUTE_CATEGORY
, CONT_POINT.ATTRIBUTE1
, CONT_POINT.ATTRIBUTE2
, CONT_POINT.ATTRIBUTE3
, CONT_POINT.ATTRIBUTE4
, CONT_POINT.ATTRIBUTE5
, CONT_POINT.ATTRIBUTE6
, CONT_POINT.ATTRIBUTE7
, CONT_POINT.ATTRIBUTE8
, CONT_POINT.ATTRIBUTE9
, CONT_POINT.ATTRIBUTE10
, CONT_POINT.ATTRIBUTE11
, CONT_POINT.ATTRIBUTE12
, CONT_POINT.ATTRIBUTE13
, CONT_POINT.ATTRIBUTE14
, CONT_POINT.ATTRIBUTE15
, PARTY.COUNTRY
, CONT_POINT.TIMEZONE_ID
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS CONT_POINT
WHERE CONT_POINT.OWNER_TABLE_ID = PARTY.PARTY_ID
AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'