[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

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

APPS.MTL_MWB_GTMP_V is not referenced by any database object