[Home] [Help] [Dependency Information]
Object Name: | AS_TERRITORY_VALUES_ALL |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_TERRITORY_VALUES_ALL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
OSM.AS_TERRITORY_VALUES_ALL does not reference any database object
OSM.AS_TERRITORY_VALUES_ALL is referenced by following:
|
|
|