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]

VIEW: APPS.OKE_AGREEMENTS_V

Object Details

Object Name:	OKE_AGREEMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKE.OKE_AGREEMENTS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AGREEMENT_ID	NUMBER	(15)	Yes	Project agreement unique identifier
DESCRIPTION	VARCHAR2	(240)		Description of project agreement
AGREEMENT_NUM	VARCHAR2	(50)	Yes	Project agreement number
AGREEMENT_TYPE	VARCHAR2	(30)	Yes	Agreement type
CUSTOMER_ID	NUMBER	(15)	Yes	Customer who is authorizing this agreement
PARTY_ID	NUMBER	(15)	Yes	Party identifier corresponding to the agreement customer
PARTY_NAME	VARCHAR2	(360)	Yes	Party name
PARTY_NUMBER	VARCHAR2	(30)	Yes	Party number
AMOUNT	NUMBER	(22)	Yes	Agreement amount
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)	Yes	Agreement functional currency
AGREEMENT_CURRENCY_CODE	VARCHAR2	(15)		Agreement currency
EXPIRATION_DATE	DATE			Date when agreement expires
PM_PRODUCT_CODE	VARCHAR2	(25)		Identifier of the external system from which the agreement is imported
PM_AGREEMENT_REFERENCE	VARCHAR2	(25)		Identifier of the agreement in the external system from which the agreement was imported
TERM_ID	NUMBER	(15)	Yes	Receivables payment term applicable to the project agreement
ORG_ID	NUMBER	(15)		Operating unit unique identifier
OWNED_BY_PERSON_ID	NUMBER	(9)	Yes	Identifier of the person that enters and owns the agreement
REVENUE_LIMIT_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether revenue for projects funded by this agreement can exceed the allocated funding amount
INVOICE_LIMIT_FLAG	VARCHAR2	(1)		Flag indicating whether invoices for projects funded by this agreement can exceed the allocated funding amount
TEMPLATE_FLAG	VARCHAR2	(1)		Flag indicating whether this project agreement is part of a template
OWNING_ORGANIZATION_ID	NUMBER	(15)		Agreement owning organization unique identifier
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	(240)		Descriptive flexfield attribute
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield attribute
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield attribute

Query Text

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


SELECT AGREEMENT_ID
,      DESCRIPTION
,      AGREEMENT_NUM
,      AGREEMENT_TYPE
,      CUSTOMER_ID
,      PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      AMOUNT
,      FUNCTIONAL_CURRENCY_CODE
,      AGREEMENT_CURRENCY_CODE
,      EXPIRATION_DATE
,      PM_PRODUCT_CODE
,      PM_AGREEMENT_REFERENCE
,      TERM_ID
,      ORG_ID
,      OWNED_BY_PERSON_ID
,      REVENUE_LIMIT_FLAG
,      INVOICE_LIMIT_FLAG
,      TEMPLATE_FLAG
,      OWNING_ORGANIZATION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
FROM APPS.OKE_AGREEMENTS_V;

Dependencies

[top of page]

APPS.OKE_AGREEMENTS_V references the following:

APPS: GL_SETS_OF_BOOKS; HZ_CUST_ACCOUNTS; HZ_PARTIES; PA_AGREEMENTS_ALL; PA_IMPLEMENTATIONS_ALL

APPS.OKE_AGREEMENTS_V is referenced by following:

APPS: OKE_FUNDSOURCE_PVT - show dependent code