VIEW: APPS.IEU_UWQ_MEDIA_ACTIONS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')