MKL_LEAD_TEAM_V

Details

• Schema: FUSION

• Object owner: MKL

• Object type: VIEW

Columns

Name
LEAD_TEAM_ID LEAD_ID TERRITORY_VERSION_ID RESOURCE_ID ADDED_ON_DATE_TIME UPDATED_ON_DATE_TIME TERR_RESOURCE_FLAG LEAD_RES_IN_TERR_FLAG

Query

SQL_Statement

SELECT /*+ USE_NL(LEAD_TERR TERR_RESS) */ TERR_RES.TERR_RESOURCE_ID LEAD_TEAM_ID, LEAD_TERR.LEAD_ID, TERR_RES.TERRITORY_VERSION_ID, TERR_RES.RESOURCE_ID, LEAD_TERR.CREATION_DATE ADDED_ON_DATE_TIME, LEAD_TERR.LAST_UPDATE_DATE UPDATED_ON_DATE_TIME, 'Y' TERR_RESOURCE_FLAG, 'N' LEAD_RES_IN_TERR_FLAG FROM MKL_LEAD_TERRITORIES LEAD_TERR, MOT_TERR_RESOURCES TERR_RES WHERE LEAD_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID UNION ALL SELECT LEAD_RES.LEAD_RESOURCE_ID LEAD_TEAM_ID, LEAD_RES.LEAD_ID, null, LEAD_RES.RESOURCE_ID, LEAD_RES.CREATION_DATE ADDED_ON_DATE_TIME, LEAD_RES.LAST_UPDATE_DATE UPDATED_ON_DATE_TIME, 'N' TERR_RESOURCE_FLAG, nvl( (SELECT 'Y' FROM MKL_LEAD_TERRITORIES LEAD_TERR, MOT_TERR_RESOURCES TERR_RES WHERE LEAD_TERR.LEAD_ID = LEAD_RES.LEAD_ID AND LEAD_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID AND TERR_RES.RESOURCE_ID = LEAD_RES.RESOURCE_ID AND ROWNUM =1), 'N') LEAD_RES_IN_TERR_FLAG FROM MKL_LEAD_RESOURCES LEAD_RES