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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.JTF_AM_SCREEN_SETUPS_VL

Object Details

Object Name:	JTF_AM_SCREEN_SETUPS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_AM_SCREEN_SETUPS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

This is the translated view for JTF Assignment Manager JTF_AM_SCREEN_SETUPS_B and JTF_AM_SCREEN_SETUPS_TL tables

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROWID from Base Table
SCREEN_SETUP_ID	NUMBER		Yes	Unique Id for the row in screen setups table
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Document from where AM is being called. For example, SR (Service Request)
MODE_ASSIST	VARCHAR2	(30)		Denotes whether the assisted mode will be available
MODE_UNASSIST	VARCHAR2	(30)		Denotes whether the unassisted mode will be available
CONTRACTS	VARCHAR2	(30)		In assited mode specifies if Contracts checkbox will be displayed
INSTALLED_BASE	VARCHAR2	(30)		In assited mode specifies if IB checkbox will be displayed
TERRITORY	VARCHAR2	(30)		In assited mode specifies if Territory checkbox will be displayed
AVAILABILITY	VARCHAR2	(30)		In assited mode specifies if Reource Availabilitycheckbox will be displayed
DOC_DETAILS	VARCHAR2	(30)		This will specify whether Document details will be displayed
WINDOW_WIDTH	NUMBER			Specifies the width of the main window
WINDOW_HEIGHT	NUMBER			Specifies the height of the main window
WINDOW_X_POSITION	NUMBER			Specifies the x position of the main window
WINDOW_Y_POSITION	NUMBER			Specifies the y position of the main window
DOC_DTLS_USER_VALUES	VARCHAR2	(30)		Indiates whether the name value pairs passed in will be displayed for Document details
SHOW_SELECTED_TIME	VARCHAR2	(30)		Specifies whether the Selected resource time field will be displayed
OBJECT_VERSION_NUMBER	NUMBER		Yes	the revision number for the row
USER_ID	NUMBER			Specifies the user id for the setup.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(150)
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign
PREFERENCE_NAME	VARCHAR2	(60)	Yes	The name for the setup preference. This is the translated name.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.JTF_AM_SCREEN_SETUPS_VL;

Dependencies

[top of page]

APPS.JTF_AM_SCREEN_SETUPS_VL references the following:

APPS: JTF_AM_SCREEN_SETUPS_B; JTF_AM_SCREEN_SETUPS_TL

APPS.JTF_AM_SCREEN_SETUPS_VL is referenced by following:

APPS: JTF_AM_SCREEN_SETUPS_PKG - show dependent code