eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: JTF.JTF_IH_MEDIA_ITEMS#

Source

View Text - Preformatted


select MEDIA_ID MEDIA_ID, 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, ANI ANI, DNIS DNIS, SERVER_GROUP_ID SERVER_GROUP_ID, CLASSIFICATION CLASSIFICATION, BULK_WRITER_CODE BULK_WRITER_CODE, BULK_BATCH_TYPE BULK_BATCH_TYPE, BULK_BATCH_ID BULK_BATCH_ID, BULK_INTERACTION_ID BULK_INTERACTION_ID, ADDRESS ADDRESS, AO_UPDATE_PENDING AO_UPDATE_PENDING, SOFT_CLOSED SOFT_CLOSED from "JTF"."JTF_IH_MEDIA_ITEMS"

View Text - HTML Formatted

SELECT MEDIA_ID MEDIA_ID
, 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
, ANI ANI
, DNIS DNIS
, SERVER_GROUP_ID SERVER_GROUP_ID
, CLASSIFICATION CLASSIFICATION
, BULK_WRITER_CODE BULK_WRITER_CODE
, BULK_BATCH_TYPE BULK_BATCH_TYPE
, BULK_BATCH_ID BULK_BATCH_ID
, BULK_INTERACTION_ID BULK_INTERACTION_ID
, ADDRESS ADDRESS
, AO_UPDATE_PENDING AO_UPDATE_PENDING
, SOFT_CLOSED SOFT_CLOSED
FROM "JTF"."JTF_IH_MEDIA_ITEMS"