VIEW: APPS.JTF_TTY_WEBADI_TERR_GRP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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