View: JTF_TTY_WEBADI_TERR_GRP_V

Product:	JTF - CRM Foundation
Description:	This view is used for Territory Group LOV for Excel
Implementation/DBA Data:	APPS.JTF_TTY_WEBADI_TERR_GRP_V

View Text

SELECT A.TERR_GROUP_NAME
, A.TERR_GROUP_ID
, C.NAME ORG_NAME
FROM JTF_TTY_TERR_GROUPS A
, JTF_TERR_ALL B
, HR_OPERATING_UNITS C
WHERE A.TERR_GROUP_ID = B.TERR_GROUP_ID
AND B.TERR_GROUP_FLAG = 'Y'
AND ( B.NAMED_ACCOUNT_FLAG IS NULL OR B.NAMED_ACCOUNT_FLAG = 'N')
AND ( B.CATCH_ALL_FLAG IS NULL OR B.CATCH_ALL_FLAG = 'N' )
AND A.SELF_SERVICE_TYPE = 'NAMED_ACCOUNT'
AND A.ACTIVE_FROM_DATE <= SYSDATE
AND ( A.ACTIVE_TO_DATE IS NULL OR A.ACTIVE_TO_DATE >= SYSDATE)
AND B.END_DATE_ACTIVE > SYSDATE
AND B.START_DATE_ACTIVE < SYSDATE
AND B.ORG_ID = C.ORGANIZATION_ID

Columns