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: BOM.CST_EAM_DIRECT_ITEMS_TEMP

Object Details

Object Name:	CST_EAM_DIRECT_ITEMS_TEMP
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_EAM_DIRECT_ITEMS_TEMP
Subobject Name:
Status:	VALID

Temporary Table Details

BOM.CST_EAM_DIRECT_ITEMS_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
WORK_ORDER_NUMBER	NUMBER
TASK_NUMBER	NUMBER
ORGANIZATION_ID	NUMBER
DEPARTMENT_ID	NUMBER
REQUISITION_NUMBER	VARCHAR2	(10)
PO_NUMBER	VARCHAR2	(10)
ITEM_DESCRIPTION	VARCHAR2	(200)
UOM_CODE	VARCHAR2	(10)
UNIT_PRICE	NUMBER
RQL_ORDERED	NUMBER
QUANTITY_ORDERED	NUMBER
QUANTITY_RECEIVED	NUMBER
LATEST_DELIVERY_DATE	DATE
PO_QUANTITY_ORDERED	NUMBER
PO_QUANTITY_CANCELLED	NUMBER
SUPPLIER_NAME	VARCHAR2	(200)
SUPPLIER_NUMBER	NUMBER
LINE_LOCATION_ID	NUMBER
PO_LINE_CANCEL_FLAG	VARCHAR2	(10)
ITEM_ID	NUMBER
CLOSED_CODE	VARCHAR2	(10)
PO_CLOSED_CODE	VARCHAR2	(10)
REQ_AUTHORIZATION_STATUS	VARCHAR2	(20)
PO_AUTHORIZATION_STATUS	VARCHAR2	(20)
PO_LINE_ID	NUMBER
PO_HEADER_ID	NUMBER
REQUISITION_HEADER_ID	NUMBER
DIRECT_ITEM_SEQUENCE_ID	NUMBER
CATEGORY_ID	NUMBER
PO_RELEASE_ID	NUMBER
REQUISITION_LINE_ID	NUMBER
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(30)
AMOUNT	NUMBER
AMOUNT_DELIVERED	NUMBER
REQ_DISTRIBUTION_ID	NUMBER
CATEGORY_DATE	DATE
PROJECT_ID	NUMBER
PURCHASING_OU_ID	NUMBER
SET_OF_BOOKS_ID	NUMBER
TXN_FLOW_HEADER_ID	NUMBER
RECEIVING_OU_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(20)
CURRENCY_DATE	DATE
CURRENCY_TYPE	VARCHAR2	(20)
CURRENCY_RATE	NUMBER
DOCUMENT_TYPE	VARCHAR2	(30)
IS_SHARED_PROC	VARCHAR2	(1)

Query Text

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


SELECT WORK_ORDER_NUMBER
,      TASK_NUMBER
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      REQUISITION_NUMBER
,      PO_NUMBER
,      ITEM_DESCRIPTION
,      UOM_CODE
,      UNIT_PRICE
,      RQL_ORDERED
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      LATEST_DELIVERY_DATE
,      PO_QUANTITY_ORDERED
,      PO_QUANTITY_CANCELLED
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      LINE_LOCATION_ID
,      PO_LINE_CANCEL_FLAG
,      ITEM_ID
,      CLOSED_CODE
,      PO_CLOSED_CODE
,      REQ_AUTHORIZATION_STATUS
,      PO_AUTHORIZATION_STATUS
,      PO_LINE_ID
,      PO_HEADER_ID
,      REQUISITION_HEADER_ID
,      DIRECT_ITEM_SEQUENCE_ID
,      CATEGORY_ID
,      PO_RELEASE_ID
,      REQUISITION_LINE_ID
,      ORDER_TYPE_LOOKUP_CODE
,      AMOUNT
,      AMOUNT_DELIVERED
,      REQ_DISTRIBUTION_ID
,      CATEGORY_DATE
,      PROJECT_ID
,      PURCHASING_OU_ID
,      SET_OF_BOOKS_ID
,      TXN_FLOW_HEADER_ID
,      RECEIVING_OU_ID
,      CURRENCY_CODE
,      CURRENCY_DATE
,      CURRENCY_TYPE
,      CURRENCY_RATE
,      DOCUMENT_TYPE
,      IS_SHARED_PROC
FROM BOM.CST_EAM_DIRECT_ITEMS_TEMP;

Dependencies

[top of page]

BOM.CST_EAM_DIRECT_ITEMS_TEMP does not reference any database object

BOM.CST_EAM_DIRECT_ITEMS_TEMP is referenced by following:

APPS: CST_EAM_DIRECT_ITEMS_TEMP