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

VIEW: APPS.MRP_ONHAND_QUANTITIES_SC_V

Object Details
Object Name: MRP_ONHAND_QUANTITIES_SC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_ONHAND_QUANTITIES_SC_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
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Query identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ITEM_NUMBER VARCHAR2 (40)
Item number
ORGANIZATION_ID NUMBER
Yes Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
SUB_INVENTORY_CODE VARCHAR2 (10) Yes Subinventory code
NETTABLE_QUANTITY NUMBER

Nettable on hand quantity
NONNETTABLE_QUANTITY NUMBER

Non nettable on hand quantity
PROJECT_ID NUMBER

Project identifier
PROJECT_NUMBER VARCHAR2 (4000)
Project number
TASK_ID NUMBER

Task identifier
TASK_NUMBER VARCHAR2 (4000)
Task number
UNIT_NUMBER VARCHAR2 (30)
unit number
Query Text

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


SELECT QUERY_ID
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      COMPILE_DESIGNATOR
,      SUB_INVENTORY_CODE
,      NETTABLE_QUANTITY
,      NONNETTABLE_QUANTITY
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      UNIT_NUMBER
FROM APPS.MRP_ONHAND_QUANTITIES_SC_V;

Dependencies

[top of page]

APPS.MRP_ONHAND_QUANTITIES_SC_V references the following:

SchemaAPPS
SynonymMRP_FORM_QUERY
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymMRP_ONHAND_QUANTITIES
ViewMRP_PLAN_ORGANIZATIONS_V
SynonymMRP_SYSTEM_ITEMS
ViewMTL_ITEM_FLEXFIELDS

APPS.MRP_ONHAND_QUANTITIES_SC_V is not referenced by any database object