VIEW: APPS.JTF_IH_MEDIA_ITEM_LC_SEGS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)