[Home] [Help] [Dependency Information]

TABLE: OSM.AS_CHANGED_TERRITORIES_ALL

Object Details

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

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_CHANGED_TERRITORIES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TERRITORY_ID
AS_CHANGED_TERRITORIES_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TERRITORY_VALUE_ID
AS_CHANGED_TERRITORIES_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TRANSFER_ONLY_FLAG
AS_CHANGED_TERRITORIES_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SEEDED_QUALIFIER_ID

Columns

Query Text

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

SELECT TERRITORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DISABLE_FLAG
,      TERRITORY_VALUE_ID
,      SEEDED_QUALIFIER_ID
,      OLD_VALUE_NUMBER1
,      OLD_VALUE_NUMBER2
,      OLD_VALUE_NUMBER3
,      OLD_VALUE_LOW
,      OLD_VALUE_HIGH
,      TRANSFER_ONLY_FLAG
,      TRANSFER_TO_SALESFORCE_ID
,      ORG_ID
,      CURRENCY_CODE
FROM OSM.AS_CHANGED_TERRITORIES_ALL;

Dependencies

[top of page]

OSM.AS_CHANGED_TERRITORIES_ALL does not reference any database object

OSM.AS_CHANGED_TERRITORIES_ALL is referenced by following:

APPS

AS_CHANGED_TERRITORIES_ALL