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

Object Details

Object Name:	OEBV_CUSTOMER_AGREEMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OE.OEBV_CUSTOMER_AGREEMENTS ONT.OEBV_CUSTOMER_AGREEMENTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows agreements which specify terms such as price lists, and purchase order numbers to be used on any order placed under this agreement.

[View Source]

Columns

Name	Datatype	Length	Mandatory
AGREEMENT_NUMBER	VARCHAR2	(50)
AGREEMENT_NAME	VARCHAR2	(240)	Yes
_LA:AGREEMENT_TYPE	CHAR	(70)
_LA:OVERRIDE_ACCOUNTING_RULE	CHAR	(49)
_LA:OVERRIDE_INVOICING_RULE	CHAR	(49)
START_DATE	DATE
END_DATE	DATE
SIGNATURE_DATE	DATE
PURCHASE_ORDER_NUMBER	VARCHAR2	(50)
_DF	CHAR	(30)
AGREEMENT_ID	NUMBER		Yes
CUSTOMER_ID	NUMBER
INVOICE_CONTACT_ID	NUMBER
AGREEMENT_CONTACT_ID	NUMBER
INVOICING_RULE_ID	NUMBER
ACCOUNTING_RULE_ID	NUMBER
INVOICE_TO_ORG_ID	NUMBER
INVOICE_TO_SITE_ID	NUMBER	(15)
SALESREP_ID	NUMBER
TERM_ID	NUMBER
PRICE_LIST_ID	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
AGREEMENT_REVISION	VARCHAR2	(50)	Yes

Query Text

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


SELECT AGREEMENT_NUMBER
,      AGREEMENT_NAME
,      _LA:AGREEMENT_TYPE
,      _LA:OVERRIDE_ACCOUNTING_RULE
,      _LA:OVERRIDE_INVOICING_RULE
,      START_DATE
,      END_DATE
,      SIGNATURE_DATE
,      PURCHASE_ORDER_NUMBER
,      _DF
,      AGREEMENT_ID
,      CUSTOMER_ID
,      INVOICE_CONTACT_ID
,      AGREEMENT_CONTACT_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      INVOICE_TO_ORG_ID
,      INVOICE_TO_SITE_ID
,      SALESREP_ID
,      TERM_ID
,      PRICE_LIST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      AGREEMENT_REVISION
FROM APPS.OEBV_CUSTOMER_AGREEMENTS;

Dependencies

[top of page]

APPS.OEBV_CUSTOMER_AGREEMENTS references the following:

APPS: HZ_CUST_SITE_USES_ALL; OE_AGREEMENTS_B; OE_AGREEMENTS_TL

APPS.OEBV_CUSTOMER_AGREEMENTS is not referenced by any database object