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_UPGRADE_LOG

Object Details

Object Name:	OE_UPGRADE_LOG
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_UPGRADE_LOG
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_UPGRADE_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_LINE_ID NEW_LINE_ID
OE_UPGRADE_LOG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HEADER_ID
OE_UPGRADE_LOG_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MTL_SALES_ORDER_ID OLD_LINE_ID OLD_LINE_DETAIL_ID
OE_UPGRADE_LOG_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MODULE
OE_UPGRADE_LOG_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CYCLE_ID
OE_UPGRADE_LOG_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEW_LINE_ID
OE_UPGRADE_LOG_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_LINE_DETAIL_ID

Columns

Name	Datatype	Length	Comments
HEADER_ID	NUMBER		Header id which is being upgraded.
OLD_LINE_ID	NUMBER		Line id which was used in the previous version.
OLD_LINE_DETAIL_ID	NUMBER		Line detail id used in the previous version.
PICKING_LINE_ID	NUMBER		Picking line id used in the previous version.
NEW_LINE_ID	NUMBER		Line id of the new line created in the 11i system, for the corresponding old line id, old line detail id, old picking line id and old delivery.
RETURN_QTY_AVAILABLE	NUMBER		Temporarily holds the quantity available for marking returns, and used only during upgrade.
NEW_LINE_NUMBER	NUMBER		New line number generated for the new lines, during upgrade.
MTL_SALES_ORDER_ID	NUMBER		The relevant inventory sales order id, which is later used by the upgrade to update the MTL_DEMAND table.
COMMENTS	VARCHAR2	(240)	Remarks
CREATION_DATE	DATE		Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
DELIVERY	NUMBER		Delivery value got from shipping for upgrade.
MODULE	VARCHAR2	(2)	Module of the Upgrade in which error is trapped.
CYCLE_ID	NUMBER		Cycle id upgraded (used for Workflow upgrade log records).

Query Text

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


SELECT HEADER_ID
,      OLD_LINE_ID
,      OLD_LINE_DETAIL_ID
,      PICKING_LINE_ID
,      NEW_LINE_ID
,      RETURN_QTY_AVAILABLE
,      NEW_LINE_NUMBER
,      MTL_SALES_ORDER_ID
,      COMMENTS
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELIVERY
,      MODULE
,      CYCLE_ID
FROM ONT.OE_UPGRADE_LOG;

Dependencies

[top of page]

ONT.OE_UPGRADE_LOG does not reference any database object

ONT.OE_UPGRADE_LOG is referenced by following:

ONT: OE_UPGRADE_LOG#