View: OKL_AM_REMARKET_TEAMS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_REMARKET_TEAMS_UV

View Text

SELECT T.TEAM_NAME DISPLAY_NAME
, T.TEAM_ID ORIG_SYSTEM_ID
, T.TEAM_DESC TEAM_DESC
, T.TEAM_NUMBER TEAM_NUMBER
, T.EMAIL_ADDRESS EMAIL_ADDRESS
, JTFR.ROLE_RESOURCE_TYPE RESOURCE_TYPE
, JTFR.ROLE_CODE ROLE_CODE
FROM JTF_RS_TEAMS_VL T
, JTF_RS_ROLE_RELATIONS_VL JTFR
WHERE NVL (T.START_DATE_ACTIVE
, SYSDATE - 1) <= SYSDATE
AND NVL (T.END_DATE_ACTIVE
, SYSDATE + 1) >= SYSDATE
AND JTFR.ROLE_CODE = 'REMARKETER'
AND ROLE_RESOURCE_TYPE = 'RS_TEAM'
AND JTFR.ROLE_RESOURCE_ID = T.TEAM_ID

Columns