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

TABLE: OKE.OKE_K_FUND_ALLOCATIONS

Object Details
Object Name: OKE_K_FUND_ALLOCATIONS
Object Type: TABLE
Owner: OKE
FND Design Data: TableOKE.OKE_K_FUND_ALLOCATIONS
Subobject Name:
Status: VALID


OKE_K_FUND_ALLOCATIONS stores the funding allocation information of the contract documents.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_K_FUND_ALLOCATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUND_ALLOCATION_ID
OKE_K_FUND_ALLOCATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
OKE_K_FUND_ALLOCATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
OKE_K_FUND_ALLOCATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
OKE_K_FUND_ALLOCATIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUNDING_SOURCE_ID
Columns
Name Datatype Length Mandatory Comments
FUND_ALLOCATION_ID NUMBER
Yes System generated unique identifier for funding allocation
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_SOURCE_ID NUMBER
Yes Unique identifier of the funding source for this allocation
OBJECT_ID NUMBER
Yes Contract document unique identifier
K_LINE_ID NUMBER

Contract document line item unique identifier
PROJECT_ID NUMBER

System generated project unique identifier
TASK_ID NUMBER

System generated task unique identifier
AMOUNT NUMBER
Yes Contract funding allocation amount
PREVIOUS_AMOUNT NUMBER
Yes Amount from the previous version of the funding allocation
HARD_LIMIT NUMBER

Invoice hard limit
PA_CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type from funding currency to project functional currency
PA_CONVERSION_DATE DATE

Exchange rate date from funding currency to project functional currency
PA_CONVERSION_RATE NUMBER

Exchange rate from funding currency to project functional currency
FUND_TYPE VARCHAR2 (30)
User-defined funding type using lookup FUND_TYPE
FUNDING_STATUS VARCHAR2 (30)
Funding status
START_DATE_ACTIVE DATE

Date this funding allocation becomes active
END_DATE_ACTIVE DATE

Date this funding allocation becomes inactive
FISCAL_YEAR NUMBER

Fiscal year that corresponds to this funding allocation
REFERENCE1 VARCHAR2 (80)
Funding reference
REFERENCE2 VARCHAR2 (80)
Funding reference
REFERENCE3 VARCHAR2 (80)
Funding reference
AGREEMENT_VERSION NUMBER

Count of how many times this allocation has been interfaced with Oracle Projects
INSERT_UPDATE_FLAG VARCHAR2 (1)
Flag indicating whether this allocation is created or updated after its last interface with Oracle Projects
CREATED_IN_VERSION NUMBER

Version of the contract document when this funding allocation was first created
UPDATED_IN_VERSION NUMBER

Version of the contract document when this funding allocation was last updated
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
PA_FLAG VARCHAR2 (1)
Flag indicating whether this allocation has been interfaced with Oracle Projects
REVENUE_HARD_LIMIT NUMBER

Revenue hard limit
PA_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Project funding descriptive flexfield attribute category
PA_ATTRIBUTE1 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE2 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE3 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE4 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE5 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE6 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE7 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE8 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE9 VARCHAR2 (150)
Project funding descriptive flexfield attribute
PA_ATTRIBUTE10 VARCHAR2 (150)
Project funding descriptive flexfield attribute
FUNDING_CATEGORY VARCHAR2 (30)
Funding category using lookup FUNDING CATEGORY TYPE
Query Text

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


SELECT FUND_ALLOCATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUNDING_SOURCE_ID
,      OBJECT_ID
,      K_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      AMOUNT
,      PREVIOUS_AMOUNT
,      HARD_LIMIT
,      PA_CONVERSION_TYPE
,      PA_CONVERSION_DATE
,      PA_CONVERSION_RATE
,      FUND_TYPE
,      FUNDING_STATUS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      FISCAL_YEAR
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      AGREEMENT_VERSION
,      INSERT_UPDATE_FLAG
,      CREATED_IN_VERSION
,      UPDATED_IN_VERSION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PA_FLAG
,      REVENUE_HARD_LIMIT
,      PA_ATTRIBUTE_CATEGORY
,      PA_ATTRIBUTE1
,      PA_ATTRIBUTE2
,      PA_ATTRIBUTE3
,      PA_ATTRIBUTE4
,      PA_ATTRIBUTE5
,      PA_ATTRIBUTE6
,      PA_ATTRIBUTE7
,      PA_ATTRIBUTE8
,      PA_ATTRIBUTE9
,      PA_ATTRIBUTE10
,      FUNDING_CATEGORY
FROM OKE.OKE_K_FUND_ALLOCATIONS;

Dependencies

[top of page]

OKE.OKE_K_FUND_ALLOCATIONS does not reference any database object

OKE.OKE_K_FUND_ALLOCATIONS is referenced by following:

SchemaOKE
ViewOKE_K_FUND_ALLOCATIONS#