Product: | AS - Sales Foundation |
---|---|
Description: | This view shows all PARTNER salesforce information |
Implementation/DBA Data: | APPS.AS_SF_PTR_V |
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(+)