[Home] [Help] [Dependency Information]
Object Name: | MRP_BOM_PLAN_NAME_LOV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_BOM_PLAN_NAME_LOV_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_NAME | VARCHAR2 | (10) | Yes | MRP or MPS plan identifier |
DESCRIPTION | VARCHAR2 | (50) | Plan description | |
COMPLETION_DATE | DATE | Planner completion date and time | ||
ITEM | VARCHAR2 | (40) | Inventory item | |
USE_UP_DATE | DATE | The date that inventory will be exhausted based upon projected gross requirements | ||
ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_NAME
, DESCRIPTION
, COMPLETION_DATE
, ITEM
, USE_UP_DATE
, ITEM_ID
, ORGANIZATION_ID
FROM APPS.MRP_BOM_PLAN_NAME_LOV_V;
|
|
|