VIEW: AP.AP_SUPPLIER_CONTACTS#

Source

View Text - Preformatted

select VENDOR_CONTACT_ID VENDOR_CONTACT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, VENDOR_SITE_ID VENDOR_SITE_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, INACTIVE_DATE INACTIVE_DATE, FIRST_NAME FIRST_NAME, MIDDLE_NAME MIDDLE_NAME, LAST_NAME LAST_NAME, PREFIX PREFIX, TITLE TITLE, MAIL_STOP MAIL_STOP, AREA_CODE AREA_CODE, PHONE PHONE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONTACT_NAME_ALT CONTACT_NAME_ALT, FIRST_NAME_ALT FIRST_NAME_ALT, LAST_NAME_ALT LAST_NAME_ALT, DEPARTMENT DEPARTMENT, EMAIL_ADDRESS EMAIL_ADDRESS, URL URL, ALT_AREA_CODE ALT_AREA_CODE, ALT_PHONE ALT_PHONE, FAX_AREA_CODE FAX_AREA_CODE, FAX FAX, PER_PARTY_ID PER_PARTY_ID, RELATIONSHIP_ID RELATIONSHIP_ID, REL_PARTY_ID REL_PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, ORG_CONTACT_ID ORG_CONTACT_ID, ORG_PARTY_SITE_ID ORG_PARTY_SITE_ID from "AP"."AP_SUPPLIER_CONTACTS"

View Text - HTML Formatted

SELECT VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, VENDOR_SITE_ID VENDOR_SITE_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, INACTIVE_DATE INACTIVE_DATE
, FIRST_NAME FIRST_NAME
, MIDDLE_NAME MIDDLE_NAME
, LAST_NAME LAST_NAME
, PREFIX PREFIX
, TITLE TITLE
, MAIL_STOP MAIL_STOP
, AREA_CODE AREA_CODE
, PHONE PHONE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONTACT_NAME_ALT CONTACT_NAME_ALT
, FIRST_NAME_ALT FIRST_NAME_ALT
, LAST_NAME_ALT LAST_NAME_ALT
, DEPARTMENT DEPARTMENT
, EMAIL_ADDRESS EMAIL_ADDRESS
, URL URL
, ALT_AREA_CODE ALT_AREA_CODE
, ALT_PHONE ALT_PHONE
, FAX_AREA_CODE FAX_AREA_CODE
, FAX FAX
, PER_PARTY_ID PER_PARTY_ID
, RELATIONSHIP_ID RELATIONSHIP_ID
, REL_PARTY_ID REL_PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, ORG_CONTACT_ID ORG_CONTACT_ID
, ORG_PARTY_SITE_ID ORG_PARTY_SITE_ID
FROM "AP"."AP_SUPPLIER_CONTACTS"