[Home] [Help] [Dependency Information]
Object Name: | OE_UPGRADE_LOG |
---|---|
Object Type: | TABLE |
Owner: | ONT |
FND Design Data: | ONT.OE_UPGRADE_LOG |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | 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). |
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;
ONT.OE_UPGRADE_LOG does not reference any database object
ONT.OE_UPGRADE_LOG is referenced by following:
|
|
|