[Home] [Help]
View: JTF_IH_MEDIA_ITEMS_V
Product: | JTF - CRM Foundation |
Description: | Used for generating reports for records in table JTF_IH_MEDIA_ITEMS. |
Implementation/DBA Data: |
APPS.JTF_IH_MEDIA_ITEMS_V
|
View Text
SELECT MED.ROWID ROW_ID
, MED.MEDIA_ID
, MED.OBJECT_VERSION_NUMBER
, MED.CREATION_DATE
, MED.LAST_UPDATE_DATE
, MED.CREATED_BY
, MED.LAST_UPDATED_BY
, MED.LAST_UPDATE_LOGIN
, MED.DURATION
, MED.DIRECTION
, MED.END_DATE_TIME
, MED.SOURCE_ITEM_CREATE_DATE_TIME
, MED.INTERACTION_PERFORMED
, MED.SOURCE_ITEM_ID
, MED.START_DATE_TIME
, MED.SOURCE_ID
, MED.MEDIA_ITEM_TYPE
, MED.MEDIA_ITEM_REF
, MED.MEDIA_DATA
, MED.ACTIVE
, MED.BULK_WRITER_CODE
, MED.BULK_BATCH_TYPE
, MED.BULK_BATCH_ID
, MED.BULK_INTERACTION_ID
, MED.ADDRESS
FROM JTF_IH_MEDIA_ITEMS MED
Columns
Name |
ROW_ID |
MEDIA_ID |
OBJECT_VERSION_NUMBER |
CREATION_DATE |
LAST_UPDATE_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
DURATION |
DIRECTION |
END_DATE_TIME |
SOURCE_ITEM_CREATE_DATE_TIME |
INTERACTION_PERFORMED |
SOURCE_ITEM_ID |
START_DATE_TIME |
SOURCE_ID |
MEDIA_ITEM_TYPE |
MEDIA_ITEM_REF |
MEDIA_DATA |
ACTIVE |
BULK_WRITER_CODE |
BULK_BATCH_TYPE |
BULK_BATCH_ID |
BULK_INTERACTION_ID |
ADDRESS |