VIEW: PV.PV_REFERRALS_B#

Source

View Text - Preformatted

select REFERRAL_ID REFERRAL_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BENEFIT_ID BENEFIT_ID, REFERRAL_CODE REFERRAL_CODE, REFERRAL_STATUS REFERRAL_STATUS, PARTNER_ID PARTNER_ID, PARTNER_CONTACT_RESOURCE_ID PARTNER_CONTACT_RESOURCE_ID, CUSTOMER_PARTY_ID CUSTOMER_PARTY_ID, CUSTOMER_ORG_CONTACT_ID CUSTOMER_ORG_CONTACT_ID, CUSTOMER_CONTACT_PARTY_ID CUSTOMER_CONTACT_PARTY_ID, CUSTOMER_PARTY_SITE_ID CUSTOMER_PARTY_SITE_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_ADDRESS_TYPE CUSTOMER_ADDRESS_TYPE, CUSTOMER_ADDRESS1 CUSTOMER_ADDRESS1, CUSTOMER_ADDRESS2 CUSTOMER_ADDRESS2, CUSTOMER_ADDRESS3 CUSTOMER_ADDRESS3, CUSTOMER_ADDRESS4 CUSTOMER_ADDRESS4, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC, CUSTOMER_CITY CUSTOMER_CITY, CUSTOMER_STATE CUSTOMER_STATE, CUSTOMER_PROVINCE CUSTOMER_PROVINCE, CUSTOMER_POSTAL_CODE CUSTOMER_POSTAL_CODE, CUSTOMER_COUNTY CUSTOMER_COUNTY, CUSTOMER_COUNTRY CUSTOMER_COUNTRY, CUSTOMER_CONTACT_TITLE CUSTOMER_CONTACT_TITLE, CUSTOMER_CONTACT_FIRST_NAME CUSTOMER_CONTACT_FIRST_NAME, CUSTOMER_CONTACT_LAST_NAME CUSTOMER_CONTACT_LAST_NAME, CUSTOMER_CONTACT_CNTRY_CODE CUSTOMER_CONTACT_CNTRY_CODE, CUSTOMER_CONTACT_AREA_CODE CUSTOMER_CONTACT_AREA_CODE, CUSTOMER_CONTACT_PHONE_NO CUSTOMER_CONTACT_PHONE_NO, CUSTOMER_CONTACT_PHONE_TYPE CUSTOMER_CONTACT_PHONE_TYPE, CUSTOMER_CONTACT_EMAIL_ADDRESS CUSTOMER_CONTACT_EMAIL_ADDRESS, CUSTOMER_CONTACT_PHONE_EXT CUSTOMER_CONTACT_PHONE_EXT, DECLINE_REASON_CODE DECLINE_REASON_CODE, ENTITY_TYPE ENTITY_TYPE, ENTITY_ID_LINKED_TO ENTITY_ID_LINKED_TO, ORDER_ID ORDER_ID, CLAIM_ID CLAIM_ID, CLAIM_NUMBER CLAIM_NUMBER, EST_COMPENSATION_AMT EST_COMPENSATION_AMT, CURRENCY_CODE CURRENCY_CODE, ACTUAL_COMPENSATION_AMT ACTUAL_COMPENSATION_AMT, ACTUAL_CURRENCY_CODE ACTUAL_CURRENCY_CODE, BENEFIT_TYPE_CODE BENEFIT_TYPE_CODE, STATUS_CHANGE_DATE STATUS_CHANGE_DATE, DUPLICATE_CUSTOMER_FLAG DUPLICATE_CUSTOMER_FLAG, ORG_ID ORG_ID, PARTNER_CUST_ACCOUNT_ID PARTNER_CUST_ACCOUNT_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, CUSTOMER_NAME_PRONOUNCIATION CUSTOMER_NAME_PRONOUNCIATION, RETURN_REASON_CODE RETURN_REASON_CODE, 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, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24 from "PV"."PV_REFERRALS_B"

View Text - HTML Formatted

SELECT REFERRAL_ID REFERRAL_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BENEFIT_ID BENEFIT_ID
, REFERRAL_CODE REFERRAL_CODE
, REFERRAL_STATUS REFERRAL_STATUS
, PARTNER_ID PARTNER_ID
, PARTNER_CONTACT_RESOURCE_ID PARTNER_CONTACT_RESOURCE_ID
, CUSTOMER_PARTY_ID CUSTOMER_PARTY_ID
, CUSTOMER_ORG_CONTACT_ID CUSTOMER_ORG_CONTACT_ID
, CUSTOMER_CONTACT_PARTY_ID CUSTOMER_CONTACT_PARTY_ID
, CUSTOMER_PARTY_SITE_ID CUSTOMER_PARTY_SITE_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_ADDRESS_TYPE CUSTOMER_ADDRESS_TYPE
, CUSTOMER_ADDRESS1 CUSTOMER_ADDRESS1
, CUSTOMER_ADDRESS2 CUSTOMER_ADDRESS2
, CUSTOMER_ADDRESS3 CUSTOMER_ADDRESS3
, CUSTOMER_ADDRESS4 CUSTOMER_ADDRESS4
, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC
, CUSTOMER_CITY CUSTOMER_CITY
, CUSTOMER_STATE CUSTOMER_STATE
, CUSTOMER_PROVINCE CUSTOMER_PROVINCE
, CUSTOMER_POSTAL_CODE CUSTOMER_POSTAL_CODE
, CUSTOMER_COUNTY CUSTOMER_COUNTY
, CUSTOMER_COUNTRY CUSTOMER_COUNTRY
, CUSTOMER_CONTACT_TITLE CUSTOMER_CONTACT_TITLE
, CUSTOMER_CONTACT_FIRST_NAME CUSTOMER_CONTACT_FIRST_NAME
, CUSTOMER_CONTACT_LAST_NAME CUSTOMER_CONTACT_LAST_NAME
, CUSTOMER_CONTACT_CNTRY_CODE CUSTOMER_CONTACT_CNTRY_CODE
, CUSTOMER_CONTACT_AREA_CODE CUSTOMER_CONTACT_AREA_CODE
, CUSTOMER_CONTACT_PHONE_NO CUSTOMER_CONTACT_PHONE_NO
, CUSTOMER_CONTACT_PHONE_TYPE CUSTOMER_CONTACT_PHONE_TYPE
, CUSTOMER_CONTACT_EMAIL_ADDRESS CUSTOMER_CONTACT_EMAIL_ADDRESS
, CUSTOMER_CONTACT_PHONE_EXT CUSTOMER_CONTACT_PHONE_EXT
, DECLINE_REASON_CODE DECLINE_REASON_CODE
, ENTITY_TYPE ENTITY_TYPE
, ENTITY_ID_LINKED_TO ENTITY_ID_LINKED_TO
, ORDER_ID ORDER_ID
, CLAIM_ID CLAIM_ID
, CLAIM_NUMBER CLAIM_NUMBER
, EST_COMPENSATION_AMT EST_COMPENSATION_AMT
, CURRENCY_CODE CURRENCY_CODE
, ACTUAL_COMPENSATION_AMT ACTUAL_COMPENSATION_AMT
, ACTUAL_CURRENCY_CODE ACTUAL_CURRENCY_CODE
, BENEFIT_TYPE_CODE BENEFIT_TYPE_CODE
, STATUS_CHANGE_DATE STATUS_CHANGE_DATE
, DUPLICATE_CUSTOMER_FLAG DUPLICATE_CUSTOMER_FLAG
, ORG_ID ORG_ID
, PARTNER_CUST_ACCOUNT_ID PARTNER_CUST_ACCOUNT_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CUSTOMER_NAME_PRONOUNCIATION CUSTOMER_NAME_PRONOUNCIATION
, RETURN_REASON_CODE RETURN_REASON_CODE
, 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
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
FROM "PV"."PV_REFERRALS_B"