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.

VIEW: JTF.JTY_WEBADI_RESOURCES#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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