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]

TABLE: ONT.OE_LINES_EBS_LOG

Object Details

Object Name:	OE_LINES_EBS_LOG
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_LINES_EBS_LOG
Subobject Name:
Status:	VALID

Log table for the Euro conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent program.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_LINES_EBS_LOG_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	EURO_LINE_ID
OE_LINES_EBS_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	OLD_LINE_ID

Columns

Name	Datatype	Mandatory	Comments
OLD_LINE_ID	NUMBER	Yes	NCU Line Id That Has Been Converted To Euro.
OLD_HEADER_ID	NUMBER		NCU Header ID That The NCU Line Belongs.
ORG_ID	NUMBER		Organization ID ( For Reporting Purposes ).
OLD_PRICE_LIST_ID	NUMBER		NCU Price List ID.
OLD_TAX_VALUE	NUMBER		NCU Tax Value.
OLD_UNIT_SELLING_PRICE	NUMBER		NCU Selling Price.
OLD_UNIT_LIST_PRICE	NUMBER		NCU List Price.
EURO_LINE_ID	NUMBER	Yes	Corresponding Euro Line ID.
EURO_HEADER_ID	NUMBER		Corresponding Euro Header ID.
EURO_PRICE_LIST_ID	NUMBER		Corresponding Euro Price List ID That Is associated with the Euro order line.
EURO_TAX_VALUE	NUMBER		Euro Converted Tax Value.
EURO_UNIT_SELLING_PRICE	NUMBER		Euro Converted Selling Price.
EURO_UNIT_LIST_PRICE	NUMBER		Euro Converted Unit Price.
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER		Application of concurrent program that last updated row.
PROGRAM_ID	NUMBER		Last date changed by concurrent program
PROGRAM_UPDATE_DATE	DATE		Last date changed by concurrent program
REQUEST_ID	NUMBER		Concurrent request that last changed row

Query Text

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


SELECT OLD_LINE_ID
,      OLD_HEADER_ID
,      ORG_ID
,      OLD_PRICE_LIST_ID
,      OLD_TAX_VALUE
,      OLD_UNIT_SELLING_PRICE
,      OLD_UNIT_LIST_PRICE
,      EURO_LINE_ID
,      EURO_HEADER_ID
,      EURO_PRICE_LIST_ID
,      EURO_TAX_VALUE
,      EURO_UNIT_SELLING_PRICE
,      EURO_UNIT_LIST_PRICE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM ONT.OE_LINES_EBS_LOG;

Dependencies

[top of page]

ONT.OE_LINES_EBS_LOG does not reference any database object

ONT.OE_LINES_EBS_LOG is referenced by following:

ONT: OE_LINES_EBS_LOG#