VIEW: APPS.AS_SF_PTR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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