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.PAFV_CUSTOMER_AGREEMENTS

Object Details

Object Name:	PAFV_CUSTOMER_AGREEMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PAFV_CUSTOMER_AGREEMENTS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This shows information about legally binding documents from customers that serve as the basis of work authorization for projects.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AGREEMENT_ID	NUMBER	(15)	Yes	The unique identifier of the agreement.
AGREEMENT_NUMBER	VARCHAR2	(50)	Yes	The agreement number for the agreement.
DESCRIPTION	VARCHAR2	(240)		Description
AMOUNT	NUMBER	(22)	Yes	The amount of revenue authorized for the agreement.
EXPIRATION_DATE	DATE			The date on which the agreement expires.
_LA:REVENUE_LIMIT_FLAG	CHAR	(52)		Revenue Limit flag
_LA:TEMPLATE_FLAG	CHAR	(44)		Template flag
_DF	CHAR	(33)		Descriptive Flexfield
OWNED_BY_PERSON_ID	NUMBER	(9)	Yes	Unique identifier for Owned By Person
OWNED_BY_PERSON	VARCHAR2	(240)		Owned By Person
TERM_ID	NUMBER	(15)	Yes	Unique identifier for Term
PAYMENT_TERM_NAME	VARCHAR2	(15)		Payment Term Name
AGREEMENT_TYPE	VARCHAR2	(30)	Yes	Agreement Type
AGREEMENT_TYPE_DESCRIPTION	VARCHAR2	(250)		Agreement Type Description
CUSTOMER_ID	NUMBER	(15)	Yes	Unique identifier for Customer
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Customer Name
ORG_ID	NUMBER	(15)		Unique identifier for Organization
ORGANIZATION_NAME	VARCHAR2	(240)		Organization Name
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.

Query Text

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


SELECT AGREEMENT_ID
,      AGREEMENT_NUMBER
,      DESCRIPTION
,      AMOUNT
,      EXPIRATION_DATE
,      _LA:REVENUE_LIMIT_FLAG
,      _LA:TEMPLATE_FLAG
,      _DF
,      OWNED_BY_PERSON_ID
,      OWNED_BY_PERSON
,      TERM_ID
,      PAYMENT_TERM_NAME
,      AGREEMENT_TYPE
,      AGREEMENT_TYPE_DESCRIPTION
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      ORG_ID
,      ORGANIZATION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PAFV_CUSTOMER_AGREEMENTS;

Dependencies

[top of page]

APPS.PAFV_CUSTOMER_AGREEMENTS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; HZ_CUST_ACCOUNTS; HZ_PARTIES; PA_AGREEMENTS_ALL; PA_AGREEMENT_TYPES; PER_ALL_PEOPLE_F; RA_TERMS

APPS.PAFV_CUSTOMER_AGREEMENTS is not referenced by any database object