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: JTF.JTY_WEBADI_RESOURCES#

Object Details

Object Name:	JTY_WEBADI_RESOURCES#
Object Type:	VIEW
Owner:	JTF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
LAY_SEQ_NUM	NUMBER
HEADER	VARCHAR2	(15)
INTERFACE_TYPE	VARCHAR2	(1)
USER_SEQUENCE	NUMBER
TERR_ID	NUMBER
TERR_RSC_ID	NUMBER
RESOURCE_TYPE	VARCHAR2	(30)
RESOURCE_NAME	VARCHAR2	(360)
RESOURCE_ID	NUMBER
RESOURCE_GROUP	VARCHAR2	(360)
GROUP_ID	NUMBER
RESOURCE_ROLE	VARCHAR2	(360)
ROLE_CODE	VARCHAR2	(360)
EMAIL	VARCHAR2	(360)
RES_START_DATE	DATE
RES_END_DATE	DATE
TERR_RSC_ACCESS_ID1	NUMBER
TERR_RSC_ACCESS_ID2	NUMBER
TERR_RSC_ACCESS_ID3	NUMBER
TERR_RSC_ACCESS_ID4	NUMBER
TERR_RSC_ACCESS_ID5	NUMBER
TERR_RSC_ACCESS_ID6	NUMBER
TERR_RSC_ACCESS_ID7	NUMBER
TERR_RSC_ACCESS_ID8	NUMBER
TERR_RSC_ACCESS_ID9	NUMBER
TERR_RSC_ACCESS_ID10	NUMBER
TRANS_ACCESS_CODE1	VARCHAR2	(30)
TRANS_ACCESS_CODE2	VARCHAR2	(30)
TRANS_ACCESS_CODE3	VARCHAR2	(30)
TRANS_ACCESS_CODE4	VARCHAR2	(30)
TRANS_ACCESS_CODE5	VARCHAR2	(30)
TRANS_ACCESS_CODE6	VARCHAR2	(30)
TRANS_ACCESS_CODE7	VARCHAR2	(30)
TRANS_ACCESS_CODE8	VARCHAR2	(30)
TRANS_ACCESS_CODE9	VARCHAR2	(30)
TRANS_ACCESS_CODE10	VARCHAR2	(30)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)

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# references the following:

JTF: JTY_WEBADI_RESOURCES

JTF.JTY_WEBADI_RESOURCES# is referenced by following:

APPS: JTY_WEBADI_RESOURCES