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_ORDER_CANCELLATIONS

Object Details

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

View Type

A Business Intelligence System view

This view shows a history of any cancellation of a sales order line.

[View Source]

Columns

Name	Datatype	Length	Comments
_LA:CANCEL_REASON	CHAR	(69)
CANCEL_COMMENT	VARCHAR2	(2000)
DATE_CANCELLED	DATE
QUANTITY_CANCELLED	NUMBER
QUANTITY_CANCELLED2	NUMBER
HEADER_ID	NUMBER
LINE_ID	NUMBER
ORG_ID	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
CHARGE_PERIODICITY_CODE	VARCHAR2	(3)	This column is used to determine the price for an order line with a recurring charge item

Query Text

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


SELECT _LA:CANCEL_REASON
,      CANCEL_COMMENT
,      DATE_CANCELLED
,      QUANTITY_CANCELLED
,      QUANTITY_CANCELLED2
,      HEADER_ID
,      LINE_ID
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      CHARGE_PERIODICITY_CODE
FROM APPS.OEBV_ORDER_CANCELLATIONS;

Dependencies

[top of page]

APPS.OEBV_ORDER_CANCELLATIONS references the following:

APPS: OE_ORDER_LINES_HISTORY

APPS.OEBV_ORDER_CANCELLATIONS is not referenced by any database object