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: OKE.OKE_POOL_PARTIES

Object Details

Object Name:	OKE_POOL_PARTIES
Object Type:	TABLE
Owner:	OKE
FND Design Data:	OKE.OKE_POOL_PARTIES
Subobject Name:
Status:	VALID

OKE_POOL_PARTIES stores information on the funding contributions to the funding pool.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKE_POOL_PARTIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	POOL_PARTY_ID
OKE_POOL_PARTIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNDING_POOL_ID PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POOL_PARTY_ID	NUMBER		Yes	Funding pool party unique identifier
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
FUNDING_POOL_ID	NUMBER		Yes	Funding pool unique identifier
PARTY_ID	NUMBER		Yes	Party associated to this funding pool
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
CONVERSION_TYPE	VARCHAR2	(30)		Exchange rate type for conversion to funding pool currency
CONVERSION_DATE	DATE			Date of currency exchange rate to funding pool currency
CONVERSION_RATE	NUMBER			Currency exchange rate to funding pool currency
INITIAL_AMOUNT	NUMBER		Yes	Initial funding pool amount
AMOUNT	NUMBER		Yes	Funding pool amount
AVAILABLE_AMOUNT	NUMBER		Yes	Available, unallocated amount
START_DATE_ACTIVE	DATE			Date this funding pool party becomes active
END_DATE_ACTIVE	DATE			Date this funding pool party becomes inactive
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield attribute context
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield attribute
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield attribute

Query Text

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


SELECT POOL_PARTY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUNDING_POOL_ID
,      PARTY_ID
,      CURRENCY_CODE
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      INITIAL_AMOUNT
,      AMOUNT
,      AVAILABLE_AMOUNT
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM OKE.OKE_POOL_PARTIES;

Dependencies

[top of page]

OKE.OKE_POOL_PARTIES does not reference any database object

OKE.OKE_POOL_PARTIES is referenced by following:

APPS: OKE_POOL_PARTIES