[Home] [Help] [Dependency Information]
Object Name: | MRP_PLAN_ORGANIZATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_PLAN_ORGANIZATIONS_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 |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
PLANNED_ORGANIZATION | NUMBER | Planned organization code | ||
OPERATION_SCHEDULE_TYPE | NUMBER | Yes | Lead time offset type | |
PLAN_TYPE | NUMBER | Yes | MPS/MRP plan type | |
OVERWRITE_OPTION | NUMBER | Yes | Whether to overwrite existing data | |
APPEND_PLANNED_ORDERS | NUMBER | Yes | Whether or not to append planned orders | |
CUTOFF_DATE | DATE | Yes | Cut off date | |
PART_INCLUDE_TYPE | NUMBER | Yes | Type of parts to include | |
PLANNING_TIME_FENCE_FLAG | NUMBER | Yes | Consider planning time fences | |
DEMAND_TIME_FENCE_FLAG | NUMBER | Yes | Consider demand ime fences | |
NET_RESERVATIONS | NUMBER | Not currently used | ||
PLAN_SAFETY_STOCK | NUMBER | Plan safety stock flag | ||
NET_WIP | NUMBER | Net WIP flag in the plan options | ||
NET_PURCHASING | NUMBER | Net purchasing flag in the plan options | ||
ASSIGNMENT_SET_ID | NUMBER | Not currently used | ||
ORGANIZATION_SELECTION | NUMBER | Selected organization code | ||
PLAN_COMPLETION_DATE | DATE | Planner completion date and time | ||
PLAN_START_DATE | DATE | Planner start date and time | ||
CURR_SCHEDULE_TYPE | NUMBER | Current schedule type | ||
USE_NEW_PLANNER | NUMBER | Whether plan uses memory based planner flag | ||
PLAN_CAPACITY_FLAG | NUMBER | Flag to indicate whether to plan capacity or not | ||
SIMULATION_SET | VARCHAR2 | (10) | Simulation set | |
BILL_OF_RESOURCE | VARCHAR2 | (10) | Bills of resource | |
RESERVATION_LEVEL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, COMPILE_DESIGNATOR
, PLANNED_ORGANIZATION
, OPERATION_SCHEDULE_TYPE
, PLAN_TYPE
, OVERWRITE_OPTION
, APPEND_PLANNED_ORDERS
, CUTOFF_DATE
, PART_INCLUDE_TYPE
, PLANNING_TIME_FENCE_FLAG
, DEMAND_TIME_FENCE_FLAG
, NET_RESERVATIONS
, PLAN_SAFETY_STOCK
, NET_WIP
, NET_PURCHASING
, ASSIGNMENT_SET_ID
, ORGANIZATION_SELECTION
, PLAN_COMPLETION_DATE
, PLAN_START_DATE
, CURR_SCHEDULE_TYPE
, USE_NEW_PLANNER
, PLAN_CAPACITY_FLAG
, SIMULATION_SET
, BILL_OF_RESOURCE
, RESERVATION_LEVEL
FROM APPS.MRP_PLAN_ORGANIZATIONS_V;
|
|
|