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: OE.WSH_REPORT_TEMP

Object Details

Object Name:	WSH_REPORT_TEMP
Object Type:	TABLE
Owner:	OE
FND Design Data:	OE.WSH_REPORT_TEMP
Subobject Name:
Status:	VALID

WSH_REPORT_TEMP is a temporary table used during calculations for
reports.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_REPORT_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	REPORT_TEMP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_TEMP_ID	NUMBER			Unique identifier generated for the table
DEPARTURE_ID	NUMBER			Departure identifier
DELIVERY_ID	NUMBER			Delivery identifier
LINE_ID	NUMBER			Delivery line identifier
ORGANIZATION_ID	NUMBER			Organization identifier
ITEM_CATEGORIES	NUMBER			Item category
ITEM_INDENTATION	NUMBER			Item indentation
INVENTORY_ITEM_ID	NUMBER			Inventory item
CUSTOMER_ITEM_ID	NUMBER			Customer item
COMPONENT_RATIO	NUMBER			Component ratio
COMPONENT_CODE	VARCHAR2	(1000)		Component code
COMPONENT_SEQUENCE_ID	NUMBER			Component sequence identifier
PURCHASE_ORDER_NUM	VARCHAR2	(50)		Purchase order number
ORDER_NUMBER	NUMBER			Order number
SHIP_TO_CONTACT_ID	NUMBER			Contact for shipping
SELLING_PRICE	NUMBER			Selling price
UNIT_OF_MEASURE	VARCHAR2	(3)		Unit of measure
CURRENCY_CODE	VARCHAR2	(3)		Currency code
QUANTITY_TO_INVOICE	NUMBER			Quantity to invoice
SHIPPED_QUANTITY	NUMBER			Shipped quantity
TOTAL_SHIPPED_TODATE	NUMBER			Total shipped quantity
TOTAL_ALREADY_SHIPPED	NUMBER			Total quantity already shipped
ORDERED_QUANTITY	NUMBER			Ordered quantity
SHIPPED_FLAG	VARCHAR2	(1)		Indicates whether shipped or not
CHILD_RFR_FLAG	VARCHAR2	(1)		Child required for revenue flag
REQUIRED_FOR_REVENUE_FLAG	VARCHAR2	(1)		Required for revenue flag
CONFIGURATION_ITEM_FLAG	VARCHAR2	(1)		Configuration item flag
INCLUDE_ON_SHIP_DOCS	NUMBER			Include in shipping documents
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column

Query Text

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


SELECT REPORT_TEMP_ID
,      DEPARTURE_ID
,      DELIVERY_ID
,      LINE_ID
,      ORGANIZATION_ID
,      ITEM_CATEGORIES
,      ITEM_INDENTATION
,      INVENTORY_ITEM_ID
,      CUSTOMER_ITEM_ID
,      COMPONENT_RATIO
,      COMPONENT_CODE
,      COMPONENT_SEQUENCE_ID
,      PURCHASE_ORDER_NUM
,      ORDER_NUMBER
,      SHIP_TO_CONTACT_ID
,      SELLING_PRICE
,      UNIT_OF_MEASURE
,      CURRENCY_CODE
,      QUANTITY_TO_INVOICE
,      SHIPPED_QUANTITY
,      TOTAL_SHIPPED_TODATE
,      TOTAL_ALREADY_SHIPPED
,      ORDERED_QUANTITY
,      SHIPPED_FLAG
,      CHILD_RFR_FLAG
,      REQUIRED_FOR_REVENUE_FLAG
,      CONFIGURATION_ITEM_FLAG
,      INCLUDE_ON_SHIP_DOCS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM OE.WSH_REPORT_TEMP;

Dependencies

[top of page]

OE.WSH_REPORT_TEMP does not reference any database object

OE.WSH_REPORT_TEMP is referenced by following:

APPS: WSH_REPORT_TEMP