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.

[Home] [Help]

View: IEU_UWQ_MEDIA_ACTIONS_VL

Product:	IEU - Universal Work Queue
Description:	View of media actions for forms.
Implementation/DBA Data:	APPS.IEU_UWQ_MEDIA_ACTIONS_VL

View Text

SELECT B.ROWID ROW_ID
, B.MEDIA_ACTION_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.MEDIA_TYPE_ID
, B.MACTION_DEF_ID
, B.APPLICATION_ID
, B.CLASSIFICATION
, B.OTHER_PARAMS
, T1.ACTION_USER_LABEL
, T2.MEDIA_TYPE_NAME
FROM IEU_UWQ_MACTION_DEFS_TL T1
, IEU_UWQ_MEDIA_TYPES_TL T2
, IEU_UWQ_MEDIA_ACTIONS B
WHERE B.MACTION_DEF_ID = T1.MACTION_DEF_ID
AND B.MEDIA_TYPE_ID = T2.MEDIA_TYPE_ID
AND T1.LANGUAGE = USERENV('LANG')
AND T2.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
MEDIA_ACTION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
MEDIA_TYPE_ID
MACTION_DEF_ID
APPLICATION_ID
CLASSIFICATION
OTHER_PARAMS
ACTION_USER_LABEL
MEDIA_TYPE_NAME