[Home] [Help]
View: JTF_TERR_RSC_ACCESS_V
Product: | JTF - CRM Foundation |
Description: | This shows the access types that a resource has to a territory. |
Implementation/DBA Data: |
APPS.JTF_TERR_RSC_ACCESS_V
|
View Text
SELECT J1.ROWID ROW_ID
, J1.TERR_RSC_ACCESS_ID TERR_RSC_ACCESS_ID
, J1.LAST_UPDATE_DATE LAST_UPDATE_DATE
, J1.LAST_UPDATED_BY LAST_UPDATED_BY
, J1.CREATION_DATE CREATION_DATE
, J1.CREATED_BY CREATED_BY
, J1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, J1.TERR_RSC_ID TERR_RSC_ID
, J1.ACCESS_TYPE ACCESS_TYPE
, J1.ORG_ID ORG_ID
, J2.DESCRIPTION MEANING
FROM JTF_TERR_RSC_ACCESS J1
, JTF_QUAL_TYPES J2
WHERE J1.ACCESS_TYPE = J2.NAME
Columns
Name |
ROW_ID |
TERR_RSC_ACCESS_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
TERR_RSC_ID |
ACCESS_TYPE |
ORG_ID |
MEANING |