[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | Territory values view |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TERRVAL.ROWID
, TERRVAL.TERRITORY_VALUE_ID
, TERRVAL.SEEDED_QUALIFIER_ID
, TERRVAL.TERRITORY_ID
, TERRVAL.LAST_UPDATE_DATE
, TERRVAL.LAST_UPDATED_BY
, TERRVAL.CREATION_DATE
, TERRVAL.CREATED_BY
, TERRVAL.LAST_UPDATE_LOGIN
, TERRVAL.LOW_VALUE_CHAR
, TERRVAL.HIGH_VALUE_CHAR
, TERRVAL.LOW_VALUE_NUMBER
, TERRVAL.HIGH_VALUE_NUMBER
, TERRVAL.ROLLUP_TERRITORY_ID
, TERRVAL.CUSTOMER_ID
, TERRVAL.ADDRESS_ID
, TERRVAL.STATE_PROVINCE_CODE
, TERRVAL.COUNTRY
, TERRVAL.INTEREST_TYPE_ID
, TERRVAL.PRIMARY_INTEREST_CODE_ID
, TERRVAL.SECONDARY_INTEREST_CODE_ID
, TERRVAL.INVENTORY_ITEM_ID
, TERRVAL.ORGANIZATION_ID
, TERRVAL.MATCH_CODE
, TERRQUAL.NAME
, TERRQUAL.TYPE
, TERRQUAL.FORMAT
, TERRQUAL.ENABLED_FLAG
, TERRQUAL.ACCESS_TYPE
, CUST.CUSTOMER_NAME
, INTTYPE.INTEREST_TYPE
, PRI_INTCODE.CODE
, SEC_INTCODE.CODE
, FND.TERRITORY_SHORT_NAME
, PRI_INTCODE.DESCRIPTION
, SEC_INTCODE.DESCRIPTION
FROM AS_TERRITORY_VALUES TERRVAL
, AS_TERR_SEED_QUALIFIERS_VL TERRQUAL
, RA_CUSTOMERS CUST
, AS_INTEREST_TYPES_VL INTTYPE
, AS_INTEREST_CODES_VL PRI_INTCODE
, AS_INTEREST_CODES_VL SEC_INTCODE
, FND_TERRITORIES_TL FND
WHERE TERRVAL.SEEDED_QUALIFIER_ID = TERRQUAL.SEEDED_QUALIFIER_ID
AND TERRVAL.CUSTOMER_ID = CUST.CUSTOMER_ID(+)
AND TERRVAL.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID(+)
AND TERRVAL.PRIMARY_INTEREST_CODE_ID = PRI_INTCODE.INTEREST_CODE_ID(+)
AND TERRVAL.SECONDARY_INTEREST_CODE_ID=SEC_INTCODE.INTEREST_CODE_ID(+)
AND TERRVAL.COUNTRY = FND.TERRITORY_CODE(+)
AND FND.LANGUAGE(+) = USERENV('LANG')