1. Tables and Views for Common Features
  2. FND_INDUSTRY_IN_TERRITORY_VL

FND_INDUSTRY_IN_TERRITORY_VL

Details

  • Schema: REFDATA

  • Object owner: FND

  • Object type: VIEW

Columns

Name

CODE

NAME

Query

SQL_Statement

select I.INDUSTRY_CODE||'_'||T.TERRITORY_CODE code,

I.INDUSTRY_NAME||', '||T.TERRITORY_SHORT_NAME name

from FND_INDUSTRY_IN_TERRITORY IT,

FND_TERRITORIES_VL T, FND_INDUSTRIES_VL I

where IT.TERRITORY_CODE = T.TERRITORY_CODE

and IT.INDUSTRY_CODE = I.INDUSTRY_CODE and IT.ENABLED_FLAG='Y'