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]

VIEW: APPS.MTL_MWB_GTMP_V

Object Details

Object Name:	MTL_MWB_GTMP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_MWB_GTMP_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
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
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	(50)
DOCUMENT_LINE_NUMBER	NUMBER
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_NUMBER	VARCHAR2	(25)
PROJECT_NAME	VARCHAR2	(30)
TASK_ID	NUMBER
TASK_NUMBER	VARCHAR2	(25)
TASK_NAME	VARCHAR2	(30)
LINE_TYPE	VARCHAR2	(30)
OWNING_TP_TYPE	NUMBER
PLANNING_TP_TYPE	NUMBER
OWNING_ORGANIZATION_ID	NUMBER
PLANNING_ORGANIZATION_ID	NUMBER
IS_PJM_ENABLED	NUMBER
ORDERED_QUANTITY	NUMBER		Ordered Quantity
STATUS	VARCHAR2	(300)
STATUS_ID	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
,      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_NUMBER
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      LINE_TYPE
,      OWNING_TP_TYPE
,      PLANNING_TP_TYPE
,      OWNING_ORGANIZATION_ID
,      PLANNING_ORGANIZATION_ID
,      IS_PJM_ENABLED
,      ORDERED_QUANTITY
,      STATUS
,      STATUS_ID
FROM APPS.MTL_MWB_GTMP_V;

Dependencies

[top of page]

APPS.MTL_MWB_GTMP_V references the following:

APPS: MTL_MWB_GTMP

APPS.MTL_MWB_GTMP_V is not referenced by any database object