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.JTY_WEBADI_RESOURCES

Object Details

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

Interface table to store data that needs to be displayed in Excel

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTY_WEBADI_RESOURCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAY_SEQ_NUM USER_SEQUENCE HEADER INTERFACE_TYPE
JTY_WEBADI_RESOURCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID USER_SEQUENCE HEADER INTERFACE_TYPE

Columns

Name	Datatype	Length	Comments
LAY_SEQ_NUM	NUMBER		Unique identifier for upload
HEADER	VARCHAR2	(15)	Indicate whether the row is territory definition, resource or matching attribute
INTERFACE_TYPE	VARCHAR2	(1)	Indicate whether the row is upload or download
USER_SEQUENCE	NUMBER		foreign key to JTY_WEBADI_OTH_TERR_INTF.USER_SEQUENCE
TERR_ID	NUMBER		foreign key to JTF_TERR_ALL.TERR_ID
TERR_RSC_ID	NUMBER		foreign key to JTF_TERR_RSC_ALL.TERR_RSC_ID
RESOURCE_TYPE	VARCHAR2	(30)	foreign key to JTF_TERR_RSC_ALL.RESOURCE_TYPE
RESOURCE_NAME	VARCHAR2	(360)	foreign key to JTF_RS_RESOURCE_EXTNS.SOURCE_NAME
RESOURCE_ID	NUMBER		foreign key to JTF_TERR_RSC_ALL.RESOURCE_ID
RESOURCE_GROUP	VARCHAR2	(360)	foreign key to JTF_RS_GROUPS_TL.GROUP_NAME
GROUP_ID	NUMBER		foreign key to JTF_TERR_RSC_ALL.GROUP_ID
RESOURCE_ROLE	VARCHAR2	(360)	foreign key to JTF_RS_ROLES_TL.ROLE_DESC
ROLE_CODE	VARCHAR2	(360)	foreign key to JTF_TERR_RSC_ALL.ROLE
EMAIL	VARCHAR2	(360)	foreign key to JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL
RES_START_DATE	DATE		foreign key to JTF_TERR_RSC_ALL.START_DATE_ACTIVE
RES_END_DATE	DATE		foreign key to JTF_TERR_RSC_ALL.END_DATE_ACTIVE
TERR_RSC_ACCESS_ID1	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID2	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID3	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID4	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID5	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID6	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID7	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID8	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID9	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TERR_RSC_ACCESS_ID10	NUMBER		foreign key to JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ACCESS_ID
TRANS_ACCESS_CODE1	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE2	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE3	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE4	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE5	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE6	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE7	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE8	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE9	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
TRANS_ACCESS_CODE10	VARCHAR2	(30)	foreign key to FND_LOOKUPS.DESCRIPTION
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment column.
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment column.

Query Text

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


SELECT LAY_SEQ_NUM
,      HEADER
,      INTERFACE_TYPE
,      USER_SEQUENCE
,      TERR_ID
,      TERR_RSC_ID
,      RESOURCE_TYPE
,      RESOURCE_NAME
,      RESOURCE_ID
,      RESOURCE_GROUP
,      GROUP_ID
,      RESOURCE_ROLE
,      ROLE_CODE
,      EMAIL
,      RES_START_DATE
,      RES_END_DATE
,      TERR_RSC_ACCESS_ID1
,      TERR_RSC_ACCESS_ID2
,      TERR_RSC_ACCESS_ID3
,      TERR_RSC_ACCESS_ID4
,      TERR_RSC_ACCESS_ID5
,      TERR_RSC_ACCESS_ID6
,      TERR_RSC_ACCESS_ID7
,      TERR_RSC_ACCESS_ID8
,      TERR_RSC_ACCESS_ID9
,      TERR_RSC_ACCESS_ID10
,      TRANS_ACCESS_CODE1
,      TRANS_ACCESS_CODE2
,      TRANS_ACCESS_CODE3
,      TRANS_ACCESS_CODE4
,      TRANS_ACCESS_CODE5
,      TRANS_ACCESS_CODE6
,      TRANS_ACCESS_CODE7
,      TRANS_ACCESS_CODE8
,      TRANS_ACCESS_CODE9
,      TRANS_ACCESS_CODE10
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM JTF.JTY_WEBADI_RESOURCES;

Dependencies

[top of page]

JTF.JTY_WEBADI_RESOURCES does not reference any database object

JTF.JTY_WEBADI_RESOURCES is referenced by following:

JTF: JTY_WEBADI_RESOURCES#