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

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CMGT_DNB_ELEMENTS_VL

View Text

SELECT B.ROWID ROW_ID
, B.DATA_ELEMENT_ID
, T.DATA_ELEMENT_NAME
, B.SCORABLE_FLAG
, B.SOURCE_TABLE_NAME
, B.SOURCE_COLUMN_NAME
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, B.APPLICATION_ID
, B.RETURN_DATA_TYPE
, B.RETURN_DATE_FORMAT
FROM AR_CMGT_DNB_ELEMENTS_B B
, AR_CMGT_DNB_ELEMENTS_TL T
WHERE B.DATA_ELEMENT_ID = T.DATA_ELEMENT_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
DATA_ELEMENT_ID
DATA_ELEMENT_NAME
SCORABLE_FLAG
SOURCE_TABLE_NAME
SOURCE_COLUMN_NAME
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
APPLICATION_ID
RETURN_DATA_TYPE
RETURN_DATE_FORMAT