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_WSH_IFACE

Object Details

Object Name:	OE_UPGRADE_WSH_IFACE
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_UPGRADE_WSH_IFACE
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:	1
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_UPGRADE_WSH_IFACE	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID
OE_UPGRADE_WSH_IFACE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_DETAIL_ID	NUMBER		Yes	Line detail id - for sales order upgrade
PICKING_LINE_ID	NUMBER			Picking line id - for sales order upgrade
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LINE_ID	NUMBER		Yes	Line id - for sales order upgrade
INVENTORY_ITEM_ID	NUMBER			Inventory item id - for sales order upgrade
INCLUDED_ITEM_FLAG	VARCHAR2	(1)		Included item flag - for sales order upgrade
COMPONENT_SEQUENCE_ID	NUMBER			Component sequence id - for sales order upgrade
COMPONENT_CODE	VARCHAR2	(1000)		Component code - for sales order upgrade
SHIPPABLE_FLAG	VARCHAR2	(1)		Shippable flag - for sales order upgrade
TRANSACTABLE_FLAG	VARCHAR2	(1)		Transactable flag - for sales order upgrade
RESERVABLE_FLAG	VARCHAR2	(1)		Reservable flag - for sales order upgrade
UNIT_CODE	VARCHAR2	(3)		Unit Code - for sales order upgrade
RELEASED_FLAG	VARCHAR2	(1)	Yes	Released flag - for sales order upgrade
REQUIRED_FOR_REVENUE_FLAG	VARCHAR2	(1)		Required for revenue flag - for sales order upgrade
QUANTITY	NUMBER			Quantity - for sales order upgrade
WAREHOUSE_ID	NUMBER			Warehouse Id - for sales order upgrade
SUBINVENTORY	VARCHAR2	(10)
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand Class Code - for sales order upgrade
SCHEDULE_DATE	DATE			Schedule date - for sales order upgrade
REVISION	VARCHAR2	(3)		Revision - for sales order upgrade
SCHEDULE_STATUS_CODE	VARCHAR2	(30)		Schedule status code - for sales order upgrade
SCHEDULE_LEVEL_CODE	NUMBER			Schedule level code - for sales order upgrade
INVENTORY_LOCATION_ID	NUMBER			Inventory location id - for sales order upgrade
CONFIGURATION_ITEM_FLAG	VARCHAR2	(1)		Configuration item flag - for sales order upgrade
LATEST_ACCEPTABLE_DATE	DATE			Latest acceptable date - for sales order upgrade
DEP_PLAN_REQUIRED_FLAG	VARCHAR2	(1)		Departure plan required flag - for sales order upgrade
DPW_ASSIGNED_FLAG	VARCHAR2	(1)		DPW assigned flag - for sales order upgrade
CUSTOMER_ITEM_ID	NUMBER			Customer item id - for sales order upgrade
DEPARTURE_ID	NUMBER			Departure id - for sales order upgrade
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield segment
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
SHIPPED_QUANTITY	VARCHAR2	(240)		Shipped quantity - for sales order upgrade
SHIP_METHOD_CODE	VARCHAR2	(30)		Ship method code - for sales order upgrade
ACTUAL_DEPARTURE_DATE	DATE			Actual departure date - for sales order upgrade
DELIVERY	NUMBER			Delivery - for sales order upgrade
INVOICED_QUANTITY	NUMBER			Invoiced Quantity in Picking
RECEIPT_STATUS_CODE	VARCHAR2	(30)		This is for receipt status code.

Query Text

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


SELECT LINE_DETAIL_ID
,      PICKING_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LINE_ID
,      INVENTORY_ITEM_ID
,      INCLUDED_ITEM_FLAG
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      SHIPPABLE_FLAG
,      TRANSACTABLE_FLAG
,      RESERVABLE_FLAG
,      UNIT_CODE
,      RELEASED_FLAG
,      REQUIRED_FOR_REVENUE_FLAG
,      QUANTITY
,      WAREHOUSE_ID
,      SUBINVENTORY
,      DEMAND_CLASS_CODE
,      SCHEDULE_DATE
,      REVISION
,      SCHEDULE_STATUS_CODE
,      SCHEDULE_LEVEL_CODE
,      INVENTORY_LOCATION_ID
,      CONFIGURATION_ITEM_FLAG
,      LATEST_ACCEPTABLE_DATE
,      DEP_PLAN_REQUIRED_FLAG
,      DPW_ASSIGNED_FLAG
,      CUSTOMER_ITEM_ID
,      DEPARTURE_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHIPPED_QUANTITY
,      SHIP_METHOD_CODE
,      ACTUAL_DEPARTURE_DATE
,      DELIVERY
,      INVOICED_QUANTITY
,      RECEIPT_STATUS_CODE
FROM ONT.OE_UPGRADE_WSH_IFACE;

Dependencies

[top of page]

ONT.OE_UPGRADE_WSH_IFACE does not reference any database object

ONT.OE_UPGRADE_WSH_IFACE is referenced by following:

ONT: OE_UPGRADE_WSH_IFACE#