FND Design Data [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: ViewAPPS.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