VIEW: AR.RA_CUSTOMER_MERGES#

Source

View Text - Preformatted

select CUSTOMER_MERGE_ID CUSTOMER_MERGE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROCESS_FLAG PROCESS_FLAG, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, CUSTOMER_REF CUSTOMER_REF, CUSTOMER_ADDRESS_ID CUSTOMER_ADDRESS_ID, CUSTOMER_ADDRESS CUSTOMER_ADDRESS, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_SITE_CODE CUSTOMER_SITE_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CUSTOMER_LOCATION CUSTOMER_LOCATION, CUSTOMER_PRIMARY_FLAG CUSTOMER_PRIMARY_FLAG, DELETE_DUPLICATE_FLAG DELETE_DUPLICATE_FLAG, DUPLICATE_ADDRESS DUPLICATE_ADDRESS, DUPLICATE_ADDRESS_ID DUPLICATE_ADDRESS_ID, DUPLICATE_ID DUPLICATE_ID, DUPLICATE_LOCATION DUPLICATE_LOCATION, DUPLICATE_NAME DUPLICATE_NAME, DUPLICATE_NUMBER DUPLICATE_NUMBER, DUPLICATE_PRIMARY_FLAG DUPLICATE_PRIMARY_FLAG, DUPLICATE_REF DUPLICATE_REF, DUPLICATE_SITE_CODE DUPLICATE_SITE_CODE, DUPLICATE_SITE_ID DUPLICATE_SITE_ID, SET_NUMBER SET_NUMBER, CUSTOMER_MERGE_HEADER_ID CUSTOMER_MERGE_HEADER_ID, CUSTOMER_FIRST_NAME CUSTOMER_FIRST_NAME, CUSTOMER_LAST_NAME CUSTOMER_LAST_NAME, CUSTOMER_TYPE CUSTOMER_TYPE, DUPLICATE_FIRST_NAME DUPLICATE_FIRST_NAME, DUPLICATE_LAST_NAME DUPLICATE_LAST_NAME, DUPLICATE_TYPE DUPLICATE_TYPE, CUSTOMER_CREATESAME CUSTOMER_CREATESAME, DUPLICATE_SITE_NUMBER DUPLICATE_SITE_NUMBER, CUSTOMER_SITE_NUMBER CUSTOMER_SITE_NUMBER, ORG_ID ORG_ID from "AR"."RA_CUSTOMER_MERGES"

View Text - HTML Formatted

SELECT CUSTOMER_MERGE_ID CUSTOMER_MERGE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROCESS_FLAG PROCESS_FLAG
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, CUSTOMER_REF CUSTOMER_REF
, CUSTOMER_ADDRESS_ID CUSTOMER_ADDRESS_ID
, CUSTOMER_ADDRESS CUSTOMER_ADDRESS
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_SITE_CODE CUSTOMER_SITE_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CUSTOMER_LOCATION CUSTOMER_LOCATION
, CUSTOMER_PRIMARY_FLAG CUSTOMER_PRIMARY_FLAG
, DELETE_DUPLICATE_FLAG DELETE_DUPLICATE_FLAG
, DUPLICATE_ADDRESS DUPLICATE_ADDRESS
, DUPLICATE_ADDRESS_ID DUPLICATE_ADDRESS_ID
, DUPLICATE_ID DUPLICATE_ID
, DUPLICATE_LOCATION DUPLICATE_LOCATION
, DUPLICATE_NAME DUPLICATE_NAME
, DUPLICATE_NUMBER DUPLICATE_NUMBER
, DUPLICATE_PRIMARY_FLAG DUPLICATE_PRIMARY_FLAG
, DUPLICATE_REF DUPLICATE_REF
, DUPLICATE_SITE_CODE DUPLICATE_SITE_CODE
, DUPLICATE_SITE_ID DUPLICATE_SITE_ID
, SET_NUMBER SET_NUMBER
, CUSTOMER_MERGE_HEADER_ID CUSTOMER_MERGE_HEADER_ID
, CUSTOMER_FIRST_NAME CUSTOMER_FIRST_NAME
, CUSTOMER_LAST_NAME CUSTOMER_LAST_NAME
, CUSTOMER_TYPE CUSTOMER_TYPE
, DUPLICATE_FIRST_NAME DUPLICATE_FIRST_NAME
, DUPLICATE_LAST_NAME DUPLICATE_LAST_NAME
, DUPLICATE_TYPE DUPLICATE_TYPE
, CUSTOMER_CREATESAME CUSTOMER_CREATESAME
, DUPLICATE_SITE_NUMBER DUPLICATE_SITE_NUMBER
, CUSTOMER_SITE_NUMBER CUSTOMER_SITE_NUMBER
, ORG_ID ORG_ID
FROM "AR"."RA_CUSTOMER_MERGES"