View: JTF_IH_MEDIA_ITEM_LC_SEGS_V

Product:	JTF - CRM Foundation
Description:	Used for generating reports for records in table JTF_IH_MEDIA_ITEM_LC_SEGS.
Implementation/DBA Data:	APPS.JTF_IH_MEDIA_ITEM_LC_SEGS_V

View Text

SELECT LC.ROWID ROW_ID
, LC.MILCS_ID
, LC.OBJECT_VERSION_NUMBER
, LC.CREATED_BY
, LC.CREATION_DATE
, LC.LAST_UPDATED_BY
, LC.LAST_UPDATE_DATE
, LC.LAST_UPDATE_LOGIN
, LC.START_DATE_TIME
, LC.TYPE_TYPE
, LC.TYPE_ID
, LC.DURATION
, LC.END_DATE_TIME
, LC.MILCS_TYPE_ID
, LC.MEDIA_ID
, LC.HANDLER_ID
, LC.RESOURCE_ID
, TYS.MILCS_CODE
, TYS.SHORT_DESCRIPTION
, LC.BULK_WRITER_CODE
, LC.BULK_BATCH_TYPE
, LC.BULK_BATCH_ID
, LC.BULK_INTERACTION_ID
FROM JTF_IH_MEDIA_ITEM_LC_SEGS LC
, JTF_IH_MEDIA_ITM_LC_SEG_TYS TYS
WHERE LC.MILCS_TYPE_ID = TYS.MILCS_TYPE_ID(+)

Columns