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

VIEW: OSM.AS_TERRITORY_VALUES_ALL#

Object Details
Object Name: AS_TERRITORY_VALUES_ALL#
Object Type: VIEW
Owner: OSM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TERRITORY_VALUE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
TERRITORY_ID NUMBER
Yes
SEEDED_QUALIFIER_ID NUMBER
Yes
LOW_VALUE_CHAR VARCHAR2 (60)
HIGH_VALUE_CHAR VARCHAR2 (60)
LOW_VALUE_NUMBER NUMBER

HIGH_VALUE_NUMBER NUMBER

ROLLUP_TERRITORY_ID NUMBER

CUSTOMER_ID NUMBER

ADDRESS_ID NUMBER

STATE_PROVINCE_CODE VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
INTEREST_TYPE_ID NUMBER

PRIMARY_INTEREST_CODE_ID NUMBER

SECONDARY_INTEREST_CODE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

MATCH_CODE VARCHAR2 (30)
ORG_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
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# references the following:

SchemaOSM
TableAS_TERRITORY_VALUES_ALL
OSM.AS_TERRITORY_VALUES_ALL# is referenced by following:

SchemaAPPS
SynonymAS_TERRITORY_VALUES_ALL