DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GMP_NETTABLE_ONHANDS_V

Object Details
Object Name: GMP_NETTABLE_ONHANDS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.GMP_NETTABLE_ONHANDS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Onhand quantities that are nettable


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization ID
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
SUBINVENTORY_CODE VARCHAR2 (10)
SubInventory Code
LOT_NUMBER VARCHAR2 (80)
Lot Number
QUANTITY NUMBER

Quantity
PLANNING_ORGANIZATION_ID NUMBER

Planning Organization ID
PLANNING_TP_TYPE NUMBER

Planning Trading Partner Type
OWNING_ORGANIZATION_ID NUMBER

Owner Organization ID
OWNING_TP_TYPE NUMBER

Owning Trading Partner Type
EXPIRATION_DATE DATE

Expiration Date
PROJECT_ID NUMBER (15)
Project ID
TASK_ID NUMBER (15)
Task ID
PLANNING_GROUP VARCHAR2 (30)
Planning group
END_ITEM_UNIT_NUMBER VARCHAR2 (4000)
End Unit
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_CODE
,      LOT_NUMBER
,      QUANTITY
,      PLANNING_ORGANIZATION_ID
,      PLANNING_TP_TYPE
,      OWNING_ORGANIZATION_ID
,      OWNING_TP_TYPE
,      EXPIRATION_DATE
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      END_ITEM_UNIT_NUMBER
FROM APPS.GMP_NETTABLE_ONHANDS_V;

Dependencies

[top of page]

APPS.GMP_NETTABLE_ONHANDS_V references the following:

SchemaAPPS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_LOT_NUMBERS
SynonymMTL_MATERIAL_STATUSES
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_ONHAND_QUANTITIES_DETAIL
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_SERIAL_NUMBERS
SynonymMTL_SERIAL_NUMBERS_TEMP
SynonymMTL_SYSTEM_ITEMS_B
SynonymPJM_PROJECT_PARAMETERS
PL/SQL PackagePJM_UNIT_EFF - show dependent code
APPS.GMP_NETTABLE_ONHANDS_V is referenced by following:

SchemaAPPS
Package BodyGMP_WPS_WRITER - show dependent code