VIEW: AP.AP_SUP_SITE_CONTACT_INT#

Source

View Text - Preformatted

select LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_SITE_CODE VENDOR_SITE_CODE, ORG_ID ORG_ID, OPERATING_UNIT_NAME OPERATING_UNIT_NAME, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, CONTACT_NAME_ALT CONTACT_NAME_ALT, FIRST_NAME_ALT FIRST_NAME_ALT, LAST_NAME_ALT LAST_NAME_ALT, DEPARTMENT DEPARTMENT, IMPORT_REQUEST_ID IMPORT_REQUEST_ID, STATUS STATUS, REJECT_CODE REJECT_CODE, EMAIL_ADDRESS EMAIL_ADDRESS, URL URL, ALT_AREA_CODE ALT_AREA_CODE, ALT_PHONE ALT_PHONE, FAX_AREA_CODE FAX_AREA_CODE, FAX FAX, VENDOR_INTERFACE_ID VENDOR_INTERFACE_ID, VENDOR_ID VENDOR_ID, VENDOR_CONTACT_INTERFACE_ID VENDOR_CONTACT_INTERFACE_ID, PARTY_SITE_ID PARTY_SITE_ID, PARTY_SITE_NAME PARTY_SITE_NAME, PARTY_ORIG_SYSTEM PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE PARTY_ORIG_SYSTEM_REFERENCE, PARTY_SITE_ORIG_SYSTEM PARTY_SITE_ORIG_SYSTEM, PARTY_SITE_ORIG_SYS_REFERENCE PARTY_SITE_ORIG_SYS_REFERENCE, SUPPLIER_SITE_ORIG_SYSTEM SUPPLIER_SITE_ORIG_SYSTEM, SUP_SITE_ORIG_SYSTEM_REFERENCE SUP_SITE_ORIG_SYSTEM_REFERENCE, CONTACT_ORIG_SYSTEM CONTACT_ORIG_SYSTEM, CONTACT_ORIG_SYSTEM_REFERENCE CONTACT_ORIG_SYSTEM_REFERENCE, SDH_BATCH_ID SDH_BATCH_ID, PARTY_ID PARTY_ID, PER_PARTY_ID PER_PARTY_ID, REL_PARTY_ID REL_PARTY_ID, RELATIONSHIP_ID RELATIONSHIP_ID, ORG_CONTACT_ID ORG_CONTACT_ID from "AP"."AP_SUP_SITE_CONTACT_INT"

View Text - HTML Formatted

SELECT LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, ORG_ID ORG_ID
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, CONTACT_NAME_ALT CONTACT_NAME_ALT
, FIRST_NAME_ALT FIRST_NAME_ALT
, LAST_NAME_ALT LAST_NAME_ALT
, DEPARTMENT DEPARTMENT
, IMPORT_REQUEST_ID IMPORT_REQUEST_ID
, STATUS STATUS
, REJECT_CODE REJECT_CODE
, EMAIL_ADDRESS EMAIL_ADDRESS
, URL URL
, ALT_AREA_CODE ALT_AREA_CODE
, ALT_PHONE ALT_PHONE
, FAX_AREA_CODE FAX_AREA_CODE
, FAX FAX
, VENDOR_INTERFACE_ID VENDOR_INTERFACE_ID
, VENDOR_ID VENDOR_ID
, VENDOR_CONTACT_INTERFACE_ID VENDOR_CONTACT_INTERFACE_ID
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_SITE_NAME PARTY_SITE_NAME
, PARTY_ORIG_SYSTEM PARTY_ORIG_SYSTEM
, PARTY_ORIG_SYSTEM_REFERENCE PARTY_ORIG_SYSTEM_REFERENCE
, PARTY_SITE_ORIG_SYSTEM PARTY_SITE_ORIG_SYSTEM
, PARTY_SITE_ORIG_SYS_REFERENCE PARTY_SITE_ORIG_SYS_REFERENCE
, SUPPLIER_SITE_ORIG_SYSTEM SUPPLIER_SITE_ORIG_SYSTEM
, SUP_SITE_ORIG_SYSTEM_REFERENCE SUP_SITE_ORIG_SYSTEM_REFERENCE
, CONTACT_ORIG_SYSTEM CONTACT_ORIG_SYSTEM
, CONTACT_ORIG_SYSTEM_REFERENCE CONTACT_ORIG_SYSTEM_REFERENCE
, SDH_BATCH_ID SDH_BATCH_ID
, PARTY_ID PARTY_ID
, PER_PARTY_ID PER_PARTY_ID
, REL_PARTY_ID REL_PARTY_ID
, RELATIONSHIP_ID RELATIONSHIP_ID
, ORG_CONTACT_ID ORG_CONTACT_ID
FROM "AP"."AP_SUP_SITE_CONTACT_INT"