VIEW: PO.PO_ENTITY_DIFFERENCES#

Source

View Text - Preformatted

select DIFF_ID DIFF_ID, DOCUMENT_TYPE DOCUMENT_TYPE, ENTITY_NAME ENTITY_NAME, MOD_DOC_SOURCE_NAME MOD_DOC_SOURCE_NAME, COLUMN_NAME COLUMN_NAME, MOD_DOC_PK1_VAL MOD_DOC_PK1_VAL, MOD_DOC_PK2_VAL MOD_DOC_PK2_VAL, MOD_DOC_PK3_VAL MOD_DOC_PK3_VAL, MOD_DOC_PK4_VAL MOD_DOC_PK4_VAL, MOD_DOC_PK5_VAL MOD_DOC_PK5_VAL, BASE_DOC_PK1_VAL BASE_DOC_PK1_VAL, BASE_DOC_PK2_VAL BASE_DOC_PK2_VAL, BASE_DOC_PK3_VAL BASE_DOC_PK3_VAL, BASE_DOC_PK4_VAL BASE_DOC_PK4_VAL, BASE_DOC_PK5_VAL BASE_DOC_PK5_VAL, MOD_VALUE MOD_VALUE, ORIG_VALUE ORIG_VALUE, MOD_VALUE_DESC MOD_VALUE_DESC, ORIG_VALUE_DESC ORIG_VALUE_DESC, RUN_ID RUN_ID, 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 from "PO"."PO_ENTITY_DIFFERENCES"

View Text - HTML Formatted

SELECT DIFF_ID DIFF_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, ENTITY_NAME ENTITY_NAME
, MOD_DOC_SOURCE_NAME MOD_DOC_SOURCE_NAME
, COLUMN_NAME COLUMN_NAME
, MOD_DOC_PK1_VAL MOD_DOC_PK1_VAL
, MOD_DOC_PK2_VAL MOD_DOC_PK2_VAL
, MOD_DOC_PK3_VAL MOD_DOC_PK3_VAL
, MOD_DOC_PK4_VAL MOD_DOC_PK4_VAL
, MOD_DOC_PK5_VAL MOD_DOC_PK5_VAL
, BASE_DOC_PK1_VAL BASE_DOC_PK1_VAL
, BASE_DOC_PK2_VAL BASE_DOC_PK2_VAL
, BASE_DOC_PK3_VAL BASE_DOC_PK3_VAL
, BASE_DOC_PK4_VAL BASE_DOC_PK4_VAL
, BASE_DOC_PK5_VAL BASE_DOC_PK5_VAL
, MOD_VALUE MOD_VALUE
, ORIG_VALUE ORIG_VALUE
, MOD_VALUE_DESC MOD_VALUE_DESC
, ORIG_VALUE_DESC ORIG_VALUE_DESC
, RUN_ID RUN_ID
, 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
FROM "PO"."PO_ENTITY_DIFFERENCES"