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

Object Details

Object Name:	OKX_AGREEMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_AGREEMENTS_V
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Displays information about customer agreements regarding the accounting and invoicing rules application.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AGREEMENT_ID	NUMBER		Yes	System-generated identifier for the agreement
PRICE_LIST_ID	NUMBER			Price list used for this agreement
AGREEMENT_NUM	VARCHAR2	(50)		User-defined number for this agreement
INVOICING_RULE	NUMBER			Invoicing rule
ACCOUNTING_RULE	NUMBER			Accounting rule
CUSTOMER_ID	NUMBER			Sold-to customer
START_DATE_ACTIVE	DATE			Date this record becomes active, if limited
END_DATE_ACTIVE	DATE			Date this record becomes inactive, if limited
NAME	VARCHAR2	(240)	Yes	Agreement name
DESCRIPTION	VARCHAR2	(30)		Code used to group agreements for reporting
STATUS	VARCHAR2	(1)		Status

Query Text

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


SELECT AGREEMENT_ID
,      PRICE_LIST_ID
,      AGREEMENT_NUM
,      INVOICING_RULE
,      ACCOUNTING_RULE
,      CUSTOMER_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      NAME
,      DESCRIPTION
,      STATUS
FROM APPS.OKX_AGREEMENTS_V;

Dependencies

[top of page]

APPS.OKX_AGREEMENTS_V references the following:

APPS: OE_AGREEMENTS_B; OE_AGREEMENTS_TL

APPS.OKX_AGREEMENTS_V is referenced by following:

APPS: OKC_GVE_PVT - show dependent code; OKS_MASSCHANGE_PVT - show dependent code