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

VIEW: APPS.MRP_TEMP_QUANTITY_V

Object Details
Object Name: MRP_TEMP_QUANTITY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_TEMP_QUANTITY_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
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ORGANIZATION_ID NUMBER

Organization identifier
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
SUB_INVENTORY_CODE VARCHAR2 (10)
Subinventory code
COMPILE_DESIGNATOR VARCHAR2 (10)
MPS, MRP or DRP plan identifier
OWNING_ORG_ID NUMBER

Owning organization identifier
NETTING_TYPE NUMBER

Subinventory netting code
NETTABLE_QUANTITY NUMBER

Nettable quantity
NONNETTABLE_QUANTITY NUMBER

Non nettable quantity
END_ITEM_UNIT_NUMBER VARCHAR2 (4000)
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      SUB_INVENTORY_CODE
,      COMPILE_DESIGNATOR
,      OWNING_ORG_ID
,      NETTING_TYPE
,      NETTABLE_QUANTITY
,      NONNETTABLE_QUANTITY
,      END_ITEM_UNIT_NUMBER
FROM APPS.MRP_TEMP_QUANTITY_V;

Dependencies

[top of page]

APPS.MRP_TEMP_QUANTITY_V references the following:

SchemaAPPS
PL/SQL PackageINV_MATERIAL_STATUS_GRP - show dependent code
ViewMRP_PLAN_ORGANIZATIONS_V
SynonymMRP_SUB_INVENTORIES
SynonymMRP_SYSTEM_ITEMS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_MATERIAL_STATUSES
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_SERIAL_NUMBERS
SynonymMTL_SERIAL_NUMBERS_TEMP
SynonymMTL_TRANSACTION_TYPES
SynonymMTL_TXN_REQUEST_HEADERS
SynonymMTL_TXN_REQUEST_LINES
PL/SQL PackagePJM_UNIT_EFF - show dependent code

APPS.MRP_TEMP_QUANTITY_V is not referenced by any database object