[Home] [Help] [Dependency Information]

TABLE: APPS.OZF_PARTY_MARKET_SEGMENTS_T

Object Details

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

Temporary Table Details

APPS.OZF_PARTY_MARKET_SEGMENTS_T is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_PARTY_MARKET_SEGMENTS_TN1	NORMAL	NONUNIQUE		MARKET_QUALIFIER_REFERENCE MARKET_QUALIFIER_TYPE

Columns

Query Text

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

SELECT AMS_PARTY_MARKET_SEGMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      MARKET_SEGMENT_ID
,      MARKET_SEGMENT_FLAG
,      PARTY_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ORG_ID
,      SECURITY_GROUP_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
FROM APPS.OZF_PARTY_MARKET_SEGMENTS_T;

Dependencies

[top of page]

APPS.OZF_PARTY_MARKET_SEGMENTS_T does not reference any database object

APPS.OZF_PARTY_MARKET_SEGMENTS_T is referenced by following:

APPS

OZF_ALLOCATION_ENGINE_PVT - show dependent code

OZF_PARTY_MKT_SEG_LOADER_PVT - show dependent code