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

Product:	JTF - CRM Foundation
Description:	This is the translated view for JTF Assignment Manager JTF_AM_SCREEN_SETUPS_B and JTF_AM_SCREEN_SETUPS_TL tables
Implementation/DBA Data:	APPS.JTF_AM_SCREEN_SETUPS_VL

View Text

SELECT B.ROWID ROW_ID
, B.SCREEN_SETUP_ID
, B.DOCUMENT_TYPE
, B.MODE_ASSIST
, B.MODE_UNASSIST
, B.CONTRACTS
, B.INSTALLED_BASE
, B.TERRITORY
, B.AVAILABILITY
, B.DOC_DETAILS
, B.WINDOW_WIDTH
, B.WINDOW_HEIGHT
, B.WINDOW_X_POSITION
, B.WINDOW_Y_POSITION
, B.DOC_DTLS_USER_VALUES
, B.SHOW_SELECTED_TIME
, B.OBJECT_VERSION_NUMBER
, B.USER_ID
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE_CATEGORY
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.PREFERENCE_NAME
FROM JTF_AM_SCREEN_SETUPS_B B
, JTF_AM_SCREEN_SETUPS_TL T
WHERE B.SCREEN_SETUP_ID = T.SCREEN_SETUP_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
SCREEN_SETUP_ID
DOCUMENT_TYPE
MODE_ASSIST
MODE_UNASSIST
CONTRACTS
INSTALLED_BASE
TERRITORY
AVAILABILITY
DOC_DETAILS
WINDOW_WIDTH
WINDOW_HEIGHT
WINDOW_X_POSITION
WINDOW_Y_POSITION
DOC_DTLS_USER_VALUES
SHOW_SELECTED_TIME
OBJECT_VERSION_NUMBER
USER_ID
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE_CATEGORY
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PREFERENCE_NAME