[Home] [Help] [Dependency Information]
Object Name: | MRPFV_PLAN_ORGANIZATIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRPFV_PLAN_ORGANIZATIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows the organizations that are being planned by a MPS, MRP, or DRP plan.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNING_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
OWNING_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
PLAN_NAME | VARCHAR2 | (10) | Yes | |
PLANNED_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
PLANNED_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
ASSIGNMENT_SET | VARCHAR2 | (30) | ||
ASSIGNMENT_SET_DESCRIPTION | VARCHAR2 | (80) | ||
_LA:OVERWRITE_OPTION | CHAR | (67) | ||
_LA:APPEND_PLANNED_ORDERS | CHAR | (64) | ||
_LA:MATERIAL_SCHED_METHOD | CHAR | (69) | ||
_LA:PLANNED_ITEMS | CHAR | (75) | ||
_LA:PLAN_TIME_FENCE_CNTRL | CHAR | (67) | ||
_LA:DEMAND_TIME_FENCE_CNTRL | CHAR | (65) | ||
_LA:NET_WIP_FLAG | CHAR | (74) | ||
_LA:NET_PURCHASING_FLAG | CHAR | (80) | ||
_LA:NET_RESERVATIONS_FLAG | CHAR | (92) | ||
_LA:PLAN_SAFETY_STOCK_FLAG | CHAR | (89) | ||
_LA:PLAN_CAPACITY_FLAG | CHAR | (61) | ||
BILL_OF_RESOURCES | VARCHAR2 | (10) | ||
SIMULATION_SET | VARCHAR2 | (10) | ||
OWNING_ORGANIZATION_ID | NUMBER | Yes | ||
PLANNED_ORGANIZATION_ID | NUMBER | |||
ASSIGNMENT_SET_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OWNING_ORGANIZATION_CODE
, OWNING_ORGANIZATION_NAME
, PLAN_NAME
, PLANNED_ORGANIZATION_CODE
, PLANNED_ORGANIZATION_NAME
, ASSIGNMENT_SET
, ASSIGNMENT_SET_DESCRIPTION
, _LA:OVERWRITE_OPTION
, _LA:APPEND_PLANNED_ORDERS
, _LA:MATERIAL_SCHED_METHOD
, _LA:PLANNED_ITEMS
, _LA:PLAN_TIME_FENCE_CNTRL
, _LA:DEMAND_TIME_FENCE_CNTRL
, _LA:NET_WIP_FLAG
, _LA:NET_PURCHASING_FLAG
, _LA:NET_RESERVATIONS_FLAG
, _LA:PLAN_SAFETY_STOCK_FLAG
, _LA:PLAN_CAPACITY_FLAG
, BILL_OF_RESOURCES
, SIMULATION_SET
, OWNING_ORGANIZATION_ID
, PLANNED_ORGANIZATION_ID
, ASSIGNMENT_SET_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM APPS.MRPFV_PLAN_ORGANIZATIONS;
APPS.MRPFV_PLAN_ORGANIZATIONS is not referenced by any database object
|
|
|