VIEW: POS.POS_CONTACT_REQUESTS#

Source

View Text - Preformatted

select CONTACT_REQUEST_ID CONTACT_REQUEST_ID, MAPPING_ID MAPPING_ID, CONTACT_PARTY_ID CONTACT_PARTY_ID, REQUEST_STATUS REQUEST_STATUS, REQUEST_TYPE REQUEST_TYPE, HAS_BACKING_DOC HAS_BACKING_DOC, CONTACT_TITLE CONTACT_TITLE, FIRST_NAME FIRST_NAME, LAST_NAME LAST_NAME, MIDDLE_NAME MIDDLE_NAME, JOB_TITLE JOB_TITLE, EMAIL_ADDRESS EMAIL_ADDRESS, PHONE_AREA_CODE PHONE_AREA_CODE, PHONE_NUMBER PHONE_NUMBER, PHONE_EXTENSION PHONE_EXTENSION, FAX_AREA_CODE FAX_AREA_CODE, FAX_NUMBER FAX_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATE_USER_ACCOUNT CREATE_USER_ACCOUNT, DO_NOT_DELETE DO_NOT_DELETE, DEPARTMENT DEPARTMENT, ALT_CONTACT_NAME ALT_CONTACT_NAME, ALT_AREA_CODE ALT_AREA_CODE, ALT_PHONE_NUMBER ALT_PHONE_NUMBER, URL URL from "POS"."POS_CONTACT_REQUESTS"

View Text - HTML Formatted

SELECT CONTACT_REQUEST_ID CONTACT_REQUEST_ID
, MAPPING_ID MAPPING_ID
, CONTACT_PARTY_ID CONTACT_PARTY_ID
, REQUEST_STATUS REQUEST_STATUS
, REQUEST_TYPE REQUEST_TYPE
, HAS_BACKING_DOC HAS_BACKING_DOC
, CONTACT_TITLE CONTACT_TITLE
, FIRST_NAME FIRST_NAME
, LAST_NAME LAST_NAME
, MIDDLE_NAME MIDDLE_NAME
, JOB_TITLE JOB_TITLE
, EMAIL_ADDRESS EMAIL_ADDRESS
, PHONE_AREA_CODE PHONE_AREA_CODE
, PHONE_NUMBER PHONE_NUMBER
, PHONE_EXTENSION PHONE_EXTENSION
, FAX_AREA_CODE FAX_AREA_CODE
, FAX_NUMBER FAX_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATE_USER_ACCOUNT CREATE_USER_ACCOUNT
, DO_NOT_DELETE DO_NOT_DELETE
, DEPARTMENT DEPARTMENT
, ALT_CONTACT_NAME ALT_CONTACT_NAME
, ALT_AREA_CODE ALT_AREA_CODE
, ALT_PHONE_NUMBER ALT_PHONE_NUMBER
, URL URL
FROM "POS"."POS_CONTACT_REQUESTS"