[Home] [Help]
[Dependency Information]
VIEW: APPS.MTL_ONHAND_QUANTITIES
Object Details
Object Name: | MTL_ONHAND_QUANTITIES |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.MTL_ONHAND_QUANTITIES
|
---|
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 |
INVENTORY_ITEM_ID |
NUMBER |
|
Yes |
Inventory item identifier |
ORGANIZATION_ID |
NUMBER |
|
Yes |
Organization identifier |
DATE_RECEIVED |
DATE |
|
|
Date received |
LAST_UPDATE_DATE |
DATE |
|
Yes |
Standard Who column |
LAST_UPDATED_BY |
NUMBER |
|
Yes |
Standard Who column |
CREATION_DATE |
DATE |
|
Yes |
Standard Who column |
CREATED_BY |
NUMBER |
|
Yes |
Standard Who column |
LAST_UPDATE_LOGIN |
NUMBER |
|
|
Standard Who column |
TRANSACTION_QUANTITY |
NUMBER |
|
Yes |
Transaction quantity in the primary unit of measure of the item |
SUBINVENTORY_CODE |
VARCHAR2 |
(10) |
Yes |
Subinventory code |
REVISION |
VARCHAR2 |
(3) |
|
Item revision code |
LOCATOR_ID |
NUMBER |
|
|
Locator identifier |
CREATE_TRANSACTION_ID |
NUMBER |
|
|
Transaction identifier of the transaction that created this row |
UPDATE_TRANSACTION_ID |
NUMBER |
|
|
Transaction identifier of the transaction that last updated this row |
LOT_NUMBER |
VARCHAR2 |
(80) |
|
Lot number |
ORIG_DATE_RECEIVED |
DATE |
|
|
|
COST_GROUP_ID |
NUMBER |
|
|
Cost Group ID - Used by WMS only |
CONTAINERIZED_FLAG |
NUMBER |
|
|
Containerized Flag |
PROJECT_ID |
NUMBER |
|
|
Project Id (For future use) |
TASK_ID |
NUMBER |
|
|
Task Id (For future use) |
SECONDARY_UOM_CODE |
VARCHAR2 |
(3) |
|
|
SECONDARY_TRANSACTION_QUANTITY |
NUMBER |
|
|
|
STATUS_ID |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DATE_RECEIVED
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TRANSACTION_QUANTITY
, SUBINVENTORY_CODE
, REVISION
, LOCATOR_ID
, CREATE_TRANSACTION_ID
, UPDATE_TRANSACTION_ID
, LOT_NUMBER
, ORIG_DATE_RECEIVED
, COST_GROUP_ID
, CONTAINERIZED_FLAG
, PROJECT_ID
, TASK_ID
, SECONDARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY
, STATUS_ID
FROM APPS.MTL_ONHAND_QUANTITIES;
Dependencies
[top of page]
APPS.MTL_ONHAND_QUANTITIES references the following:
-
APPS
-
MTL_ONHAND_QUANTITIES_DETAIL
APPS.MTL_ONHAND_QUANTITIES is referenced by following:
-
APPS
-
AHL_OSP_INV_ITEMS_V
-
AHL_OSP_QUERIES_PVT
- show dependent code
-
AHL_PRD_MRSHL_PVT
- show dependent code
-
AHL_PRD_MTLTXN_PVT
- show dependent code
-
AHL_RA_ANALYSER_PVT
- show dependent code
-
AHL_UC_INSTANCE_PVT
- show dependent code
-
AST_COLL_REVIEW_KITS_V
-
CONVERT_TEST
- show dependent code
-
CSI_DIAGNOSTICS_PKG
- show dependent code
-
CSI_INV_DISCREPANCY_PKG
- show dependent code
-
CSL_MTL_ONHAND_QTY_ACC_PKG
- show dependent code
-
CSP_EXCESS_PARTS_PVT
- show dependent code
-
CSP_GET_LOT_NUMBERS_V
-
CSP_PART_SEARCH_PVT
- show dependent code
-
CSP_SUPPLY_DEMAND_PVT
- show dependent code
-
CSP_VALIDATE_PUB
- show dependent code
-
CSTPCGUT
- show dependent code
-
CSTPMECS
- show dependent code
-
CSTPPCAT
- show dependent code
-
CST_INVENTORY_PVT
- show dependent code
-
CST_MGD_MSTR_BOOK_RPT
- show dependent code
-
CTO_DEACTIVATE_CONFIG_PK
- show dependent code
-
EAM_OPERATIONS_JSP
- show dependent code
-
ENGPKIMP
- show dependent code
-
ENG_ENGRCNSR_XMLP_PKG
- show dependent code
-
FLM_KANBAN_TRANSFER
- show dependent code
-
FLM_SUPPLY_DEMAND
- show dependent code
-
GMD_STABILITY_STUDIES_GRP
- show dependent code
-
GMO_SWORKBENCH_PVT
- show dependent code
-
ICX_COST_GRP_INV_VALUE_V
-
ICX_EDM_COST_GROUP_INV_V
-
ICX_EDM_INV_ONHAND_BAL_V
-
ICX_MTL_ONHAND_ITEMS_KFV
-
ICX_MTL_ONHAND_LOCATOR_KFV
-
ICX_MTL_ONHAND_LOT_KFV
-
ICX_MTL_ONHAND_REV_KFV
-
ICX_MTL_ONHAND_SUB_KFV
-
ICX_MTL_ONHAND_SUB_V
-
INVBV_ONHAND_BALANCES
-
INVFV_ONHAND_BALANCES
-
INV_CG_UPGRADE
- show dependent code
-
INV_MWB_TREE
- show dependent code
-
INV_MWB_TREE1
- show dependent code
-
JMF_SHIKYU_RPT_CFR_PVT
- show dependent code
-
MRP_ATP_COLLECTION
- show dependent code
-
MRP_ITEM_LOT_QUANTITIES_V
-
MRP_ORG_QUANTITY_V
-
MTL_ATT_QTY_V
-
MTL_CCEOI_VAR_PVT
- show dependent code
-
PJM_PROJECT_ONHAND_VALUE_V
-
POS_MTL_ONHAND_ITEMS_KFV
-
POS_MTL_ONHAND_LOCATOR_KFV
-
POS_MTL_ONHAND_LOT_KFV
-
POS_MTL_ONHAND_REV_KFV
-
POS_MTL_ONHAND_SUB_KFV
-
WPS_SUPPLY_DEMAND
- show dependent code
-
WSH_DEL_OI_CORE
- show dependent code