VIEW: JTF.JTF_IH_MEDIA_ITEMS_STG#

Source

View Text - Preformatted

select MEDIA_ID MEDIA_ID, SESSION_NO SESSION_NO, SESSION_DATE SESSION_DATE, STATUS_FL STATUS_FL, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DURATION DURATION, DIRECTION DIRECTION, END_DATE_TIME END_DATE_TIME, SOURCE_ITEM_CREATE_DATE_TIME SOURCE_ITEM_CREATE_DATE_TIME, INTERACTION_PERFORMED INTERACTION_PERFORMED, SOURCE_ITEM_ID SOURCE_ITEM_ID, START_DATE_TIME START_DATE_TIME, SOURCE_ID SOURCE_ID, MEDIA_ITEM_TYPE MEDIA_ITEM_TYPE, MEDIA_ITEM_REF MEDIA_ITEM_REF, MEDIA_DATA MEDIA_DATA, ACTIVE ACTIVE, SECURITY_GROUP_ID SECURITY_GROUP_ID, MEDIA_ABANDON_FLAG MEDIA_ABANDON_FLAG, MEDIA_TRANSFERRED_FLAG MEDIA_TRANSFERRED_FLAG, SERVER_GROUP_ID SERVER_GROUP_ID, CLASSIFICATION CLASSIFICATION, DNIS DNIS, ANI ANI, ADDRESS ADDRESS from "JTF"."JTF_IH_MEDIA_ITEMS_STG"

View Text - HTML Formatted

SELECT MEDIA_ID MEDIA_ID
, SESSION_NO SESSION_NO
, SESSION_DATE SESSION_DATE
, STATUS_FL STATUS_FL
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DURATION DURATION
, DIRECTION DIRECTION
, END_DATE_TIME END_DATE_TIME
, SOURCE_ITEM_CREATE_DATE_TIME SOURCE_ITEM_CREATE_DATE_TIME
, INTERACTION_PERFORMED INTERACTION_PERFORMED
, SOURCE_ITEM_ID SOURCE_ITEM_ID
, START_DATE_TIME START_DATE_TIME
, SOURCE_ID SOURCE_ID
, MEDIA_ITEM_TYPE MEDIA_ITEM_TYPE
, MEDIA_ITEM_REF MEDIA_ITEM_REF
, MEDIA_DATA MEDIA_DATA
, ACTIVE ACTIVE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, MEDIA_ABANDON_FLAG MEDIA_ABANDON_FLAG
, MEDIA_TRANSFERRED_FLAG MEDIA_TRANSFERRED_FLAG
, SERVER_GROUP_ID SERVER_GROUP_ID
, CLASSIFICATION CLASSIFICATION
, DNIS DNIS
, ANI ANI
, ADDRESS ADDRESS
FROM "JTF"."JTF_IH_MEDIA_ITEMS_STG"