VIEW: APPS.JTF_TERR_RESOURCES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)