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]

TABLE: JTF.JTF_AM_SCREEN_SETUPS_B

Object Details

Object Name:	JTF_AM_SCREEN_SETUPS_B
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_AM_SCREEN_SETUPS_B
Subobject Name:
Status:	VALID

This table is the setup table to modify the Assignment Manager UI layout

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_AM_SCREEN_SETUPS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCREEN_SETUP_ID
JTF_AM_SCREEN_SETUPS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SCREEN_SETUP_ID	NUMBER		Yes	Unique id for the table
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Document from where AM is being called. For example, SR (Service Request). This will be unique for the table.
MODE_ASSIST	VARCHAR2	(30)		The value in this column will decide if UI should display Assisted mode radio button or not. Valid values Y/N.
MODE_UNASSIST	VARCHAR2	(30)		The value in this column will decide if UI should display Unassisted mode radio button or not. Valid values Y/N.
CONTRACTS	VARCHAR2	(30)		The value in this column will decide if UI should display Contracts checkbox or not. Valid values Y/N.
INSTALLED_BASE	VARCHAR2	(30)		The value in this column will decide if UI should display Install Base checkbox or not. Valid values Y/N.
TERRITORY	VARCHAR2	(30)		The value in this column will decide if UI should display Territories checkbox or not. Valid values Y/N.
AVAILABILITY	VARCHAR2	(30)		The value in this column will decide if UI should display Resource Availability checkbox or not. Valid values Y/N.
DOC_DETAILS	VARCHAR2	(30)		The value in this column will decide if UI should display Document Details or not. Valid values Y/N.
WINDOW_WIDTH	NUMBER			Width of the window for AM screen (in inches).
WINDOW_HEIGHT	NUMBER			Height of the window for AM screen (in inches).
WINDOW_X_POSITION	NUMBER			AM screen position's X co-ordinates.
WINDOW_Y_POSITION	NUMBER			AM screen position's Y co-ordinates.
DOC_DTLS_USER_VALUES	VARCHAR2	(30)		This gives products team the flexibility to customize what UI should display in Document Details. Valid values are Y/N. This will work only if doc_details is set to Y.
SHOW_SELECTED_TIME	VARCHAR2	(30)		The value in this column will decide if UI should display selected resource's start and end time or not. Valid values are Y/N.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number of the record
USER_ID	NUMBER			User Id of the user whose prefrence is stored.
ATTRIBUTE1	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE2	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE3	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE4	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE5	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE6	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE7	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE8	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE9	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE10	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE11	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE12	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE13	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE14	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE15	VARCHAR2	(150)		Standard Flex Field Columns
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Standard Flex Field Columns
CREATED_BY	NUMBER		Yes	Standard Who Coloumn
CREATION_DATE	DATE		Yes	Standard Who Coloumn
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Coloumn
LAST_UPDATE_DATE	DATE		Yes	Standard Who Coloumn
LAST_UPDATE_LOGIN	NUMBER			Standard Who Coloumn
SECURITY_GROUP_ID	NUMBER			Standard Who Coloumn

Query Text

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


SELECT 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
,      SECURITY_GROUP_ID
FROM JTF.JTF_AM_SCREEN_SETUPS_B;

Dependencies

[top of page]

JTF.JTF_AM_SCREEN_SETUPS_B does not reference any database object

JTF.JTF_AM_SCREEN_SETUPS_B is referenced by following:

APPS: JTF_AM_SCREEN_SETUPS_B