View: MTL_MWB_GTMP_V

Product:	INV - Inventory
Description:	Material Workbench Global Temporary Table View
Implementation/DBA Data:	APPS.MTL_MWB_GTMP_V

View Text

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 MTL_MWB_GTMP

Columns