VIEW: POS.POS_ADDRESS_REQUESTS#

Source

View Text - Preformatted

select ADDRESS_REQUEST_ID ADDRESS_REQUEST_ID, MAPPING_ID MAPPING_ID, PARTY_SITE_ID PARTY_SITE_ID, REQUEST_STATUS REQUEST_STATUS, REQUEST_TYPE REQUEST_TYPE, HAS_BACKING_DOC HAS_BACKING_DOC, PARTY_SITE_NAME PARTY_SITE_NAME, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_LINE4 ADDRESS_LINE4, CITY CITY, POSTAL_CODE POSTAL_CODE, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, COUNTRY COUNTRY, 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, RFQ_FLAG RFQ_FLAG, PAY_FLAG PAY_FLAG, PUR_FLAG PUR_FLAG, PRIMARY_PAY_FLAG PRIMARY_PAY_FLAG, 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, END_DATE_ACTIVE END_DATE_ACTIVE from "POS"."POS_ADDRESS_REQUESTS"

View Text - HTML Formatted

SELECT ADDRESS_REQUEST_ID ADDRESS_REQUEST_ID
, MAPPING_ID MAPPING_ID
, PARTY_SITE_ID PARTY_SITE_ID
, REQUEST_STATUS REQUEST_STATUS
, REQUEST_TYPE REQUEST_TYPE
, HAS_BACKING_DOC HAS_BACKING_DOC
, PARTY_SITE_NAME PARTY_SITE_NAME
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_LINE4 ADDRESS_LINE4
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, COUNTRY COUNTRY
, 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
, RFQ_FLAG RFQ_FLAG
, PAY_FLAG PAY_FLAG
, PUR_FLAG PUR_FLAG
, PRIMARY_PAY_FLAG PRIMARY_PAY_FLAG
, 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
, END_DATE_ACTIVE END_DATE_ACTIVE
FROM "POS"."POS_ADDRESS_REQUESTS"