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: AMS_MET_TPL_HEADERS_VL

Product:	AMS - Marketing
Description:	This view returns the metric template headers name and description in the current language.
Implementation/DBA Data:	APPS.AMS_MET_TPL_HEADERS_VL

View Text

SELECT MTHB.METRIC_TPL_HEADER_ID
, MTHB.LAST_UPDATE_DATE
, MTHB.LAST_UPDATED_BY
, MTHB.CREATION_DATE
, MTHB.CREATED_BY
, MTHB.LAST_UPDATE_LOGIN
, MTHB.OBJECT_VERSION_NUMBER
, MTHB.ENABLED_FLAG
, MTHB.APPLICATION_ID
, MTHTL.METRIC_TPL_HEADER_NAME
, MTHTL.DESCRIPTION
, MTHB.OBJECT_TYPE
, MTHB.ASSOCIATION_TYPE
, MTHB.USED_BY_ID
, MTHB.USED_BY_CODE
FROM AMS_MET_TPL_HEADERS_B MTHB
, AMS_MET_TPL_HEADERS_TL MTHTL
WHERE MTHB.METRIC_TPL_HEADER_ID = MTHTL.METRIC_TPL_HEADER_ID
AND MTHTL.LANGUAGE = USERENV('LANG')

Columns

Name
METRIC_TPL_HEADER_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
ENABLED_FLAG
APPLICATION_ID
METRIC_TPL_HEADER_NAME
DESCRIPTION
OBJECT_TYPE
ASSOCIATION_TYPE
USED_BY_ID
USED_BY_CODE