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: ViewINV.MTL_MWB_GTMP_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
ORG_ID NUMBER

Organization Identifier
ITEM VARCHAR2 (255)
Item Name
ITEM_DESCRIPTION VARCHAR2 (255)
Item Description
ITEM_ID NUMBER

Item Identifier
REVISION VARCHAR2 (3)
Revision
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure Code
ONHAND NUMBER

Onhand Quantity
RECEIVING NUMBER

Receiving Quantity
INBOUND NUMBER

Inbound Quantity
UNPACKED NUMBER

Unpacked Quantity
PACKED NUMBER

Packed Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
SECONDARY_ONHAND NUMBER

Secondary Onhand Quantity
SECONDARY_RECEIVING NUMBER

Secondary Receiving Quantity
SECONDARY_INBOUND NUMBER

Secondary Inbound Quantity
SECONDARY_UNPACKED NUMBER

Secondary Unpacked Quantity
SECONDARY_PACKED NUMBER

Secondary Packed Quantity
SUBINVENTORY_CODE VARCHAR2 (50)
Subinventory Code
LOCATOR VARCHAR2 (255)
Locator
LOCATOR_ID NUMBER

Locator Identifier
LPN VARCHAR2 (50)
License Plate Number
LPN_ID NUMBER

LPN Identifier
LPN_CONTEXT_ID NUMBER

LPN Context Identifier
LPN_CONTEXT VARCHAR2 (30)
LPN Context
COST_GROUP VARCHAR2 (30)
Cost Group
CG_ID NUMBER

Cost Group Id
LOADED NUMBER

Loaded
PLANNING_PARTY VARCHAR2 (300)
Planning Party
PLANNING_PARTY_ID NUMBER

Planning Party Identifier
OWNING_PARTY VARCHAR2 (300)
Owning Party
OWNING_PARTY_ID NUMBER

Owning Party Identifier
LOT VARCHAR2 (80)
Lot Number
SUPPLIER_LOT VARCHAR2 (80)
Supplier Lot Number
PARENT_LOT VARCHAR2 (80)
Parent Lot Number
SERIAL VARCHAR2 (30)
Serial Number
GRADE_CODE VARCHAR2 (150)
Grade Code
UNIT_NUMBER VARCHAR2 (30)
Unit Number
LOT_EXPIRY_DATE DATE

Lot Expiration Date
ORIGINATION_TYPE VARCHAR2 (30)
Originitation Type
ORIGINATION_DATE DATE

Lot Creation Date(as in the BRD) - Used by WMS only
ACTION_CODE VARCHAR2 (32)
Expiration Action Code
ACTION_DATE DATE

Expiration Action Date
RETEST_DATE DATE

Retest Date- Used by WMS only
MATURITY_DATE DATE

The Date on which the Item matures(Used by WMS only)
HOLD_DATE DATE

Hold Date
DOCUMENT_TYPE VARCHAR2 (50)
Document type
DOCUMENT_TYPE_ID NUMBER

Document type identifier
DOCUMENT_NUMBER VARCHAR2 (240)
Document number
DOCUMENT_LINE_NUMBER VARCHAR2 (240)
Document line number
RELEASE_NUMBER NUMBER

Release number
PO_RELEASE_ID NUMBER

Purchase order release identifier
RELEASE_LINE_NUMBER NUMBER

Release line number
SHIPMENT_NUMBER VARCHAR2 (50)
Shipment number
SHIPMENT_HEADER_ID_INTERORG NUMBER

Shipment header identifier for interorg
ASN VARCHAR2 (50)
Advance shipment notice
SHIPMENT_HEADER_ID_ASN NUMBER

Shipment header identifier for advance shipment notice
TRADING_PARTNER VARCHAR2 (360)
Trading Partner
VENDOR_ID NUMBER

Vendor identifier
TRADING_PARTNER_SITE VARCHAR2 (300)
Trading Partner site
VENDOR_SITE_ID NUMBER

Vendor site identifier
FROM_ORG VARCHAR2 (30)
From organization
FROM_ORG_ID NUMBER

From organization identifier
TO_ORG VARCHAR2 (30)
To organization
TO_ORG_ID NUMBER

To organization identifier
EXPECTED_RECEIPT_DATE DATE

Expected receipt date
SHIPPED_DATE DATE

Shipping date
OWNING_ORG VARCHAR2 (30)
Owning organization
OWNING_ORG_ID NUMBER

Owning organization identifier
REQ_HEADER_ID NUMBER

Request header identifier
OE_HEADER_ID NUMBER

Order entry header identifier
PO_HEADER_ID NUMBER

Purchase order header identifier
PROJECT_ID NUMBER

Project idenifier
PROJECT_NUMBER VARCHAR2 (25)
Project number
PROJECT_NAME VARCHAR2 (30)
Project name
TASK_ID NUMBER

Task idenifier
TASK_NUMBER VARCHAR2 (25)
Task number
TASK_NAME VARCHAR2 (30)
Task name
LINE_TYPE VARCHAR2 (30)
Line type
OWNING_TP_TYPE NUMBER

Owning trading partner type
PLANNING_TP_TYPE NUMBER

Planning trading partner type
OWNING_ORGANIZATION_ID NUMBER

Owning Organization Identifier
PLANNING_ORGANIZATION_ID NUMBER

Planning Organization Identifier
IS_PJM_ENABLED NUMBER

PJM enabled Flag check
ORDERED_QUANTITY NUMBER

Ordered Quantity
STATUS VARCHAR2 (300)
Status information
STATUS_ID NUMBER

Status Identifier
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
,      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
,      LOADED_QUANTITY
FROM APPS.MTL_MWB_GTMP_V;

Dependencies

[top of page]

APPS.MTL_MWB_GTMP_V references the following:

SchemaAPPS
SynonymMTL_MWB_GTMP

APPS.MTL_MWB_GTMP_V is not referenced by any database object