ZPM_PARTNER_TEAM_V

Details

• Schema: FUSION

• Object owner: ZPM

• Object type: VIEW

Columns

Name
PARTNER_TEAM_ID PARTNER_PARTY_ID TERRITORY_VERSION_ID RESOURCE_ID ADDED_ON_DATE_TIME UPDATED_ON_DATE_TIME TERR_RESOURCE_FLAG PARTNER_RES_IN_TERR_FLAG

Query

SQL_Statement

SELECT /** USE_NL(PARTNER_TERR TERR_RES) */ TERR_RES.TERR_RESOURCE_ID PARTNER_TEAM_ID, PARTNER.PARTY_ID PARTNER_PARTY_ID, TERR_RES.TERRITORY_VERSION_ID, TERR_RES.RESOURCE_ID, PARTNER_TERR.CREATION_DATE ADDED_ON_DATE_TIME, PARTNER_TERR.LAST_UPDATE_DATE UPDATED_ON_DATE_TIME, 'Y' TERR_RESOURCE_FLAG, 'N' PARTNER_RES_IN_TERR_FLAG FROM ZPM_PARTNER_PROFILES PARTNER, ZPM_PARTNER_TERRITORIES PARTNER_TERR, MOT_TERR_RESOURCES TERR_RES WHERE PARTNER.PARTY_ID = PARTNER_TERR.PARTNER_PARTY_ID AND PARTNER_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID UNION ALL SELECT PARTNER_RES.P_ACCT_RESOURCE_ID PARTNER_TEAM_ID, PARTNER.PARTY_ID PARTNER_PARTY_ID, NULL TERRITORY_VERSION_ID, PARTNER_RES.RESOURCE_ID, PARTNER_RES.CREATION_DATE ADDED_ON_DATE_TIME, PARTNER_RES.LAST_UPDATE_DATE UPDATED_ON_DATE_TIME, 'N' TERR_RESOURCE_FLAG, NVL( (SELECT 'Y' FROM ZPM_PARTNER_TERRITORIES PARTNER_TERR, MOT_TERR_RESOURCES TERR_RES WHERE PARTNER_TERR.PARTNER_PARTY_ID = PARTNER_RES.PARTNER_PARTY_ID AND PARTNER_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID AND TERR_RES.RESOURCE_ID = PARTNER_RES.RESOURCE_ID AND ROWNUM = 1), 'N') PARTNER_RES_IN_TERR_FLAG FROM ZPM_PARTNER_PROFILES PARTNER, ZPM_P_ACCT_RESOURCES PARTNER_RES WHERE PARTNER.PARTY_ID = PARTNER_RES.PARTNER_PARTY_ID