VIEW: MSD.MSD_ST_LEVEL_ORG_ASSCNS#

Source

View Text - Preformatted

select INSTANCE INSTANCE, LEVEL_ID LEVEL_ID, SR_LEVEL_PK SR_LEVEL_PK, ORG_LEVEL_ID ORG_LEVEL_ID, ORG_SR_LEVEL_PK ORG_SR_LEVEL_PK, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SR_INSTANCE_CODE SR_INSTANCE_CODE, LEVEL_NAME LEVEL_NAME, LEVEL_VALUE LEVEL_VALUE, ORG_LEVEL_NAME ORG_LEVEL_NAME, ORG_LEVEL_VALUE ORG_LEVEL_VALUE, BATCH_ID BATCH_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID from "MSD"."MSD_ST_LEVEL_ORG_ASSCNS"

View Text - HTML Formatted

SELECT INSTANCE INSTANCE
, LEVEL_ID LEVEL_ID
, SR_LEVEL_PK SR_LEVEL_PK
, ORG_LEVEL_ID ORG_LEVEL_ID
, ORG_SR_LEVEL_PK ORG_SR_LEVEL_PK
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, LEVEL_NAME LEVEL_NAME
, LEVEL_VALUE LEVEL_VALUE
, ORG_LEVEL_NAME ORG_LEVEL_NAME
, ORG_LEVEL_VALUE ORG_LEVEL_VALUE
, BATCH_ID BATCH_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ERROR_TEXT ERROR_TEXT
, MESSAGE_ID MESSAGE_ID
FROM "MSD"."MSD_ST_LEVEL_ORG_ASSCNS"