Product: | JTF - CRM Foundation |
---|---|
Description: | This view stores all the informations of the resources assigned to territories . |
Implementation/DBA Data: | APPS.JTF_TERR_RESOURCES_V |
SELECT JTRA.ROWID
, JTRA.TERR_RSC_ID
, JTRA.LAST_UPDATE_DATE
, JTRA.LAST_UPDATED_BY
, JTRA.CREATION_DATE
, JTRA.CREATED_BY
, JTRA.LAST_UPDATE_LOGIN
, JTRA.TERR_ID
, JTRA.RESOURCE_ID
, JTRA.RESOURCE_TYPE
, JO.NAME RESOURCE_TYPE_NAME
, JTRA.GROUP_ID
, JTF_TERRITORY_RESOURCE_PVT.GET_GROUP_NAME(JTRA.GROUP_ID) GROUP_NAME
, JTRA.ROLE
, JTRA.PRIMARY_CONTACT_FLAG
, JTRA.START_DATE_ACTIVE
, JTRA.END_DATE_ACTIVE
, JTRA.FULL_ACCESS_FLAG
, JTRA.ORG_ID
, JTF_TERRITORY_RESOURCE_PVT.GET_RESOURCE_NAME( JTRA.RESOURCE_ID
, DECODE( JTRA.RESOURCE_TYPE
, 'RS_SUPPLIER'
, 'RS_SUPPLIER_CONTACT'
, JTRA.RESOURCE_TYPE ) ) RESOURCE_NAME
, JRRV.ROLE_NAME
, JTRA.PERSON_ID
FROM JTF_TERR_RSC JTRA
, JTF_OBJECTS_VL JO
, JTF_RS_ROLES_VL JRRV
WHERE DECODE( JTRA.RESOURCE_TYPE
, 'RS_SUPPLIER'
, 'RS_SUPPLIER_CONTACT'
, JTRA.RESOURCE_TYPE ) = JO.OBJECT_CODE
AND JTRA.ROLE = JRRV.ROLE_CODE (+)