MOO_OPTY_TEAM_V

Details

• Schema: FUSION

• Object owner: MOO

• Object type: VIEW

Columns

Name
OPTY_ID TERRITORY_VERSION_ID RESOURCE_ID TERR_RESOURCE_FLAG OPTY_RES_IN_TERR_FLAG

Query

SQL_Statement

SELECT /*+ USE_NL(REVN REVN_TERR TERR_RES) */ REVN.OPTY_ID, TERR_RES.TERRITORY_VERSION_ID, TERR_RES.RESOURCE_ID, 'Y' TERR_RESOURCE_FLAG, 'N' OPTY_RES_IN_TERR_FLAG FROM MOO_REVN REVN, MOO_REVN_TERR REVN_TERR, MOT_TERR_RESOURCES TERR_RES WHERE REVN.REVN_ID = REVN_TERR.REVN_ID AND REVN_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID AND REVN.PRIMARY_FLAG = 'Y' UNION ALL SELECT OPTY_ID, ASGN_TERRITORY_VERSION_ID, RESOURCE_ID, 'N' TERR_RESOURCE_FLAG, nvl( (SELECT 'Y' FROM MOO_REVN REVN, MOO_REVN_TERR REVN_TERR, MOT_TERR_RESOURCES TERR_RES WHERE REVN.OPTY_ID = OPTY_RES.OPTY_ID AND REVN.PRIMARY_FLAG = 'Y' AND REVN.REVN_ID = REVN_TERR.REVN_ID AND REVN_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID AND TERR_RES.RESOURCE_ID = OPTY_RES.RESOURCE_ID AND ROWNUM =1), 'N' ) OPTY_RES_IN_TERR_FLAG FROM MOO_OPTY_RESOURCES OPTY_RES