eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OSM.AS_TERRITORY_VALUES_ALL

Object Details

Object Name:	AS_TERRITORY_VALUES_ALL
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_TERRITORY_VALUES_ALL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_TERRITORY_VALUES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	TERRITORY_VALUE_ID
AS_TERRITORY_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SEEDED_QUALIFIER_ID
AS_TERRITORY_VALUES_N10	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORGANIZATION_ID INVENTORY_ITEM_ID
AS_TERRITORY_VALUES_N11	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TERRITORY_ID SEEDED_QUALIFIER_ID
AS_TERRITORY_VALUES_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	LOW_VALUE_CHAR HIGH_VALUE_CHAR
AS_TERRITORY_VALUES_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CUSTOMER_ID
AS_TERRITORY_VALUES_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ADDRESS_ID
AS_TERRITORY_VALUES_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	STATE_PROVINCE_CODE
AS_TERRITORY_VALUES_N7	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	COUNTRY
AS_TERRITORY_VALUES_N8	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	LOW_VALUE_NUMBER HIGH_VALUE_NUMBER
AS_TERRITORY_VALUES_N9	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	INTEREST_TYPE_ID PRIMARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TERRITORY_VALUE_ID	NUMBER		Yes	Territory qualifier value identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column
TERRITORY_ID	NUMBER		Yes	The identifier of the territory
SEEDED_QUALIFIER_ID	NUMBER		Yes	Identifier of the seeded qualifier
LOW_VALUE_CHAR	VARCHAR2	(60)		The low value for this territory qualifier
HIGH_VALUE_CHAR	VARCHAR2	(60)		The high value for this territory qualifier
LOW_VALUE_NUMBER	NUMBER			The low number value for this qualifier
HIGH_VALUE_NUMBER	NUMBER			The high number value for this qualifier
ROLLUP_TERRITORY_ID	NUMBER			If the qualifier is TERRITORY_NAME, this stores the rollup territory identifier.
CUSTOMER_ID	NUMBER			Customer/prospect identifier
ADDRESS_ID	NUMBER			Account identifier
STATE_PROVINCE_CODE	VARCHAR2	(60)		State/province value
COUNTRY	VARCHAR2	(60)		Country value for the qualifier COUNTRY
INTEREST_TYPE_ID	NUMBER			Interest type identifier
PRIMARY_INTEREST_CODE_ID	NUMBER			Primary interest code identifier
SECONDARY_INTEREST_CODE_ID	NUMBER			Secondary interest code identifier
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
ORGANIZATION_ID	NUMBER			Organization identifier
MATCH_CODE	VARCHAR2	(30)		The kind of matching done between interest values in the territory and the interest values in the account/lead.
ORG_ID	NUMBER			Operating unit which performed this transaction
CURRENCY_CODE	VARCHAR2	(15)		Currency code.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TERRITORY_VALUE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TERRITORY_ID
,      SEEDED_QUALIFIER_ID
,      LOW_VALUE_CHAR
,      HIGH_VALUE_CHAR
,      LOW_VALUE_NUMBER
,      HIGH_VALUE_NUMBER
,      ROLLUP_TERRITORY_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      STATE_PROVINCE_CODE
,      COUNTRY
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      MATCH_CODE
,      ORG_ID
,      CURRENCY_CODE
FROM OSM.AS_TERRITORY_VALUES_ALL;

Dependencies

[top of page]

OSM.AS_TERRITORY_VALUES_ALL does not reference any database object

OSM.AS_TERRITORY_VALUES_ALL is referenced by following:

APPS: AS_TERRITORY_VALUES_ALL