View: AS_SF_PTR_V

Product:	AS - Sales Foundation
Description:	This view shows all PARTNER salesforce information
Implementation/DBA Data:	APPS.AS_SF_PTR_V

View Text

SELECT RES.RESOURCE_ID
, RES.RESOURCE_NUMBER
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATED_BY
, RES.CREATION_DATE
, RES.CREATED_BY
, RES.LAST_UPDATE_LOGIN
, RES.CATEGORY
, ROLEB.ROLE_ID
, ROLETL.ROLE_NAME
, ROLEB.ROLE_TYPE_CODE
, ROLEB.MEMBER_FLAG
, ROLEB.ADMIN_FLAG
, ROLEB.MANAGER_FLAG
, RREL.START_DATE_ACTIVE
, RREL.END_DATE_ACTIVE
, RES.MANAGING_EMPLOYEE_ID
, RES.SOURCE_ID
, RES.ADDRESS_ID
, RREL.DELETE_FLAG
, RES.ATTRIBUTE_CATEGORY
, RES.ATTRIBUTE1
, RES.ATTRIBUTE2
, RES.ATTRIBUTE3
, RES.ATTRIBUTE4
, RES.ATTRIBUTE5
, RES.ATTRIBUTE6
, RES.ATTRIBUTE7
, RES.ATTRIBUTE8
, RES.ATTRIBUTE9
, RES.ATTRIBUTE10
, RES.ATTRIBUTE11
, RES.ATTRIBUTE12
, RES.ATTRIBUTE13
, RES.ATTRIBUTE14
, RES.ATTRIBUTE15
, HZORG.INTERNAL_FLAG
FROM JTF_RS_RESOURCE_EXTNS RES
, JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_ROLES_B ROLEB
, JTF_RS_ROLES_TL ROLETL
, HZ_ORGANIZATION_PROFILES HZORG
WHERE ROLEB.ROLE_TYPE_CODE IN ('SALES'
, 'TELESALES'
, 'FIELDSALES'
, 'PRM')
AND RES.RESOURCE_ID = RREL.ROLE_RESOURCE_ID
AND RREL.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
AND RREL.ROLE_ID = ROLEB.ROLE_ID
AND ROLEB.ROLE_ID = ROLETL.ROLE_ID
AND ROLETL.LANGUAGE = USERENV('LANG')
AND RES.CATEGORY = 'PARTNER'
AND RES.SOURCE_ID = HZORG.PARTY_ID(+)

Columns