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: INV.MTL_MWB_GTMP

Object Details

Object Name:	MTL_MWB_GTMP
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_MWB_GTMP
Subobject Name:
Status:	VALID

Temporary Table Details

INV.MTL_MWB_GTMP 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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
ORGANIZATION_CODE	VARCHAR2	(3)
ORG_ID	NUMBER
ITEM	VARCHAR2	(255)
ITEM_DESCRIPTION	VARCHAR2	(255)
ITEM_ID	NUMBER
REVISION	VARCHAR2	(3)
PRIMARY_UOM_CODE	VARCHAR2	(3)
ONHAND	NUMBER
RECEIVING	NUMBER
INBOUND	NUMBER
UNPACKED	NUMBER
PACKED	NUMBER
ORDERED_QUANTITY	NUMBER
SECONDARY_UOM_CODE	VARCHAR2	(3)
SECONDARY_ONHAND	NUMBER
SECONDARY_RECEIVING	NUMBER
SECONDARY_INBOUND	NUMBER
SECONDARY_UNPACKED	NUMBER
SECONDARY_PACKED	NUMBER
SUBINVENTORY_CODE	VARCHAR2	(50)
LOCATOR	VARCHAR2	(255)
LOCATOR_ID	NUMBER
LPN	VARCHAR2	(50)
LPN_ID	NUMBER
LPN_CONTEXT_ID	NUMBER
LPN_CONTEXT	VARCHAR2	(30)
COST_GROUP	VARCHAR2	(30)
CG_ID	NUMBER
LOADED	NUMBER
PLANNING_PARTY	VARCHAR2	(300)
PLANNING_PARTY_ID	NUMBER
OWNING_PARTY	VARCHAR2	(300)
OWNING_PARTY_ID	NUMBER
LOT	VARCHAR2	(80)
SUPPLIER_LOT	VARCHAR2	(80)
PARENT_LOT	VARCHAR2	(80)
SERIAL	VARCHAR2	(30)
GRADE_CODE	VARCHAR2	(150)
UNIT_NUMBER	VARCHAR2	(30)
LOT_EXPIRY_DATE	DATE
ORIGINATION_TYPE	VARCHAR2	(30)
ORIGINATION_DATE	DATE
ACTION_CODE	VARCHAR2	(32)
ACTION_DATE	DATE
RETEST_DATE	DATE
MATURITY_DATE	DATE
HOLD_DATE	DATE
DOCUMENT_TYPE	VARCHAR2	(50)
DOCUMENT_TYPE_ID	NUMBER
DOCUMENT_NUMBER	VARCHAR2	(240)
DOCUMENT_LINE_NUMBER	VARCHAR2	(240)
RELEASE_NUMBER	NUMBER
PO_RELEASE_ID	NUMBER
RELEASE_LINE_NUMBER	NUMBER
SHIPMENT_NUMBER	VARCHAR2	(50)
SHIPMENT_HEADER_ID_INTERORG	NUMBER
ASN	VARCHAR2	(50)
SHIPMENT_HEADER_ID_ASN	NUMBER
TRADING_PARTNER	VARCHAR2	(360)
VENDOR_ID	NUMBER
TRADING_PARTNER_SITE	VARCHAR2	(300)
VENDOR_SITE_ID	NUMBER
FROM_ORG	VARCHAR2	(30)
FROM_ORG_ID	NUMBER
TO_ORG	VARCHAR2	(30)
TO_ORG_ID	NUMBER
EXPECTED_RECEIPT_DATE	DATE
SHIPPED_DATE	DATE
OWNING_ORG	VARCHAR2	(30)
OWNING_ORG_ID	NUMBER
REQ_HEADER_ID	NUMBER
OE_HEADER_ID	NUMBER
PO_HEADER_ID	NUMBER
PROJECT_ID	NUMBER
PROJECT_NAME	VARCHAR2	(30)
PROJECT_NUMBER	VARCHAR2	(25)
TASK_ID	NUMBER
TASK_NAME	VARCHAR2	(30)
TASK_NUMBER	VARCHAR2	(25)
LINE_TYPE	VARCHAR2	(30)
OWNING_TP_TYPE	NUMBER
PLANNING_TP_TYPE	NUMBER
IS_PJM_ENABLED	NUMBER
OWNING_ORGANIZATION_ID	NUMBER
PLANNING_ORGANIZATION_ID	NUMBER
STATUS_ID	NUMBER
STATUS	VARCHAR2	(300)
LOADED_QUANTITY	NUMBER

Query Text

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


SELECT ORGANIZATION_CODE
,      ORG_ID
,      ITEM
,      ITEM_DESCRIPTION
,      ITEM_ID
,      REVISION
,      PRIMARY_UOM_CODE
,      ONHAND
,      RECEIVING
,      INBOUND
,      UNPACKED
,      PACKED
,      ORDERED_QUANTITY
,      SECONDARY_UOM_CODE
,      SECONDARY_ONHAND
,      SECONDARY_RECEIVING
,      SECONDARY_INBOUND
,      SECONDARY_UNPACKED
,      SECONDARY_PACKED
,      SUBINVENTORY_CODE
,      LOCATOR
,      LOCATOR_ID
,      LPN
,      LPN_ID
,      LPN_CONTEXT_ID
,      LPN_CONTEXT
,      COST_GROUP
,      CG_ID
,      LOADED
,      PLANNING_PARTY
,      PLANNING_PARTY_ID
,      OWNING_PARTY
,      OWNING_PARTY_ID
,      LOT
,      SUPPLIER_LOT
,      PARENT_LOT
,      SERIAL
,      GRADE_CODE
,      UNIT_NUMBER
,      LOT_EXPIRY_DATE
,      ORIGINATION_TYPE
,      ORIGINATION_DATE
,      ACTION_CODE
,      ACTION_DATE
,      RETEST_DATE
,      MATURITY_DATE
,      HOLD_DATE
,      DOCUMENT_TYPE
,      DOCUMENT_TYPE_ID
,      DOCUMENT_NUMBER
,      DOCUMENT_LINE_NUMBER
,      RELEASE_NUMBER
,      PO_RELEASE_ID
,      RELEASE_LINE_NUMBER
,      SHIPMENT_NUMBER
,      SHIPMENT_HEADER_ID_INTERORG
,      ASN
,      SHIPMENT_HEADER_ID_ASN
,      TRADING_PARTNER
,      VENDOR_ID
,      TRADING_PARTNER_SITE
,      VENDOR_SITE_ID
,      FROM_ORG
,      FROM_ORG_ID
,      TO_ORG
,      TO_ORG_ID
,      EXPECTED_RECEIPT_DATE
,      SHIPPED_DATE
,      OWNING_ORG
,      OWNING_ORG_ID
,      REQ_HEADER_ID
,      OE_HEADER_ID
,      PO_HEADER_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NAME
,      TASK_NUMBER
,      LINE_TYPE
,      OWNING_TP_TYPE
,      PLANNING_TP_TYPE
,      IS_PJM_ENABLED
,      OWNING_ORGANIZATION_ID
,      PLANNING_ORGANIZATION_ID
,      STATUS_ID
,      STATUS
,      LOADED_QUANTITY
FROM INV.MTL_MWB_GTMP;

Dependencies

[top of page]

INV.MTL_MWB_GTMP does not reference any database object

INV.MTL_MWB_GTMP is referenced by following:

APPS: MTL_MWB_GTMP