ZCA_ACCOUNT_TEAM_V

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
ACCOUNT_TEAM_ID PARTY_ID SALES_ACCOUNT_ID TERRITORY_VERSION_ID RESOURCE_ID ADDED_ON_DATE_TIME UPDATED_ON_DATE_TIME TERR_RESOURCE_FLAG ACCNT_RES_IN_TERR_FLAG

Query

SQL_Statement

SELECT /*+ USE_NL(ACCT_TERR TERR_RES) */ TERR_RES.TERR_RESOURCE_ID ACCOUNT_TEAM_ID, ACCT.PARTY_ID, ACCT_TERR.SALES_ACCOUNT_ID, TERR_RES.TERRITORY_VERSION_ID, TERR_RES.RESOURCE_ID, ACCT_TERR.CREATION_DATE ADDED_ON_DATE_TIME, ACCT_TERR.LAST_UPDATE_DATE UPDATED_ON_DATE_TIME, 'Y' TERR_RESOURCE_FLAG, 'N' ACCNT_RES_IN_TERR_FLAG FROM ZCA_SALES_ACCOUNTS ACCT, ZCA_S_ACCT_TERRITORIES ACCT_TERR, MOT_TERR_RESOURCES TERR_RES WHERE ACCT.SALES_ACCOUNT_ID = ACCT_TERR.SALES_ACCOUNT_ID AND ACCT_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID UNION ALL SELECT ACCT_RES.S_ACCT_RESOURCE_ID ACCOUNT_TEAM_ID, ACCT.PARTY_ID, ACCT_RES.SALES_ACCOUNT_ID, null, ACCT_RES.RESOURCE_ID, ACCT_RES.CREATION_DATE ADDED_ON_DATE_TIME, ACCT_RES.LAST_UPDATE_DATE UPDATED_ON_DATE_TIME, 'N' TERR_RESOURCE_FLAG, nvl( (SELECT 'Y' FROM ZCA_S_ACCT_TERRITORIES ACCT_TERR, MOT_TERR_RESOURCES TERR_RES WHERE ACCT_TERR.SALES_ACCOUNT_ID = ACCT_RES.SALES_ACCOUNT_ID AND ACCT_TERR.TERRITORY_VERSION_ID = TERR_RES.TERRITORY_VERSION_ID and TERR_RES.RESOURCE_ID = ACCT_RES.RESOURCE_ID AND ROWNUM =1), 'N' ) ACCNT_RES_IN_TERR_FLAG FROM ZCA_SALES_ACCOUNTS ACCT, ZCA_S_ACCT_RESOURCES ACCT_RES WHERE ACCT.SALES_ACCOUNT_ID = ACCT_RES.SALES_ACCOUNT_ID