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: OZF.OZF_TP_TERRUSG_MAP

Object Details

Object Name:	OZF_TP_TERRUSG_MAP
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_TP_TERRUSG_MAP
Subobject Name:
Status:	VALID

Table to store the territory and store mappings

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_TP_TERRUSG_MAP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MARKET_QUALIFIER_TYPE MARKET_QUALIFIER_REFERENCE
OZF_TP_TERRUSG_MAP_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OZF_TP_TERRUSG_MAP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OZF_TP_TERRUSG_MAP_ID	NUMBER		Yes	Primary Key Column
PARTY_ID	NUMBER		Yes	Party Id
START_DATE_ACTIVE	DATE			Active Start Date
END_DATE_ACTIVE	DATE			End Date Active
TERRITORY_ID	NUMBER			Territory Id
MARKET_QUALIFIER_TYPE	VARCHAR2	(240)		Market Qualifier Type
MARKET_QUALIFIER_REFERENCE	NUMBER			Market Qualifier Reference
CUST_ACCOUNT_ID	NUMBER			Customer Account Id
CUST_ACCT_SITE_ID	NUMBER			Cust Account Site id
SITE_USE_CODE	VARCHAR2	(240)		Site use code
BILL_TO_SITE_USE_ID	NUMBER			Bill to Site Use Id
ROLLUP_PARTY_ID	NUMBER			ROLLUP_PARTY_ID
SITE_USE_ID	NUMBER			Site use Id
USER_ADDED	VARCHAR2	(1)	Yes	User Added
LOCATION_ID	NUMBER	(15)		Location Id
LAST_UPDATE_DATE	DATE		Yes	Audit column
LAST_UPDATED_BY	NUMBER		Yes	Audit Column
CREATION_DATE	DATE		Yes	Audit Date
CREATED_BY	NUMBER		Yes	Audit Column
LAST_UPDATE_LOGIN	NUMBER			Audit Column

Query Text

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


SELECT OZF_TP_TERRUSG_MAP_ID
,      PARTY_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TERRITORY_ID
,      MARKET_QUALIFIER_TYPE
,      MARKET_QUALIFIER_REFERENCE
,      CUST_ACCOUNT_ID
,      CUST_ACCT_SITE_ID
,      SITE_USE_CODE
,      BILL_TO_SITE_USE_ID
,      ROLLUP_PARTY_ID
,      SITE_USE_ID
,      USER_ADDED
,      LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM OZF.OZF_TP_TERRUSG_MAP;

Dependencies

[top of page]

OZF.OZF_TP_TERRUSG_MAP does not reference any database object

OZF.OZF_TP_TERRUSG_MAP is referenced by following:

APPS: OZF_TP_TERRUSG_MAP