[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_PDR_PLAN_DETAILS_V1

Object Details

Object Name:	MSC_PDR_PLAN_DETAILS_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_PDR_PLAN_DETAILS_V1
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

Query Text

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

SELECT OWNING_ORGANIZATION
,      OTHER_PLAN_ORGANIZATIONS
,      PLANNED_RESOURCES
,      PLANNED_ITEMS
,      ASSIGNMENT_SET
,      DEMAND_PRIORITY_RULE
,      MATERIAL_SCHEDULING_METHOD
,      APPEND_PLANNED_ORDERS
,      PEGGING
,      DEMAND_TIME_FENCE_CONTROL
,      PLANNING_TIME_FENCE_CONTROL
,      LOT_FOR_LOT
,      PLAN_NAME
,      PLAN_COMPLETION_DATE
,      OPTIMIZED
,      ENFORCE_CAPACITY_CONSTRAINTS
,      ENFORCE_DEMAND_DUE_DATES
,      MAXIMIZE_INVENTORY_TURNS
,      MAXIMIZE_PLAN_PROFITS
,      MAXIMIZE_ONTIME_DELIVERY
,      EXCEEDING_MATERIAL_CAPACITY
,      EXCEEDING_RESOURCE_CAPACITY
,      EXCEEDING_TRANS_CAPACITY
,      DEMAND_LATENESS
,      DAILY_BUCKET_SIZE
,      DAILY_ITEMS
,      DAILY_RESOURCES
,      DAILY_ROUTINGS
,      DAILY_PLAN_RES_CONSTRAINTS
,      DAILY_PLAN_MAT_CONSTRAINTS
,      WEEKLY_BUCKET_SIZE
,      WEEKLY_ITEMS
,      WEEKLY_RESOURCES
,      WEEKLY_ROUTINGS
,      WEEKLY_PLAN_RES_CONSTRAINTS
,      WEEKLY_PLAN_MAT_CONSTRAINTS
,      PERIOD_BUCKET_SIZE
,      PERIOD_ITEMS
,      PERIOD_RESOURCES
,      PERIOD_ROUTINGS
,      PERIOD_PLAN_RES_CONSTRAINTS
,      PERIOD_PLAN_MAT_CONSTRAINTS
,      PLANNING_METHOD
,      PLAN
,      REPORT_CREATION_DATE
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      CATEGORY_SET_ID
,      PRODUCT_CATEGORY_ID
,      ABC_CLASS_ID
,      INVENTORY_ITEM_ID
,      PLANNER_CODE_ID
,      BUYER_NAME_ID
,      SUPPLIER_ID
,      PLANNING_GROUP_ID
,      PROJECT_ID
,      RESOURCE_GROUP_ID
,      DEPT_LINE_ID
,      RESOURCE_ID
,      RECORD_DATE
,      CURR_START_DATE
,      USE_END_ITEM_SUBSTITUTIONS
,      USE_ALTERNATE_RESOURCES
,      USE_ALTERNATE_BOM_ROUTING
,      USE_SUBSTITUTE_COMPONENTS
,      USE_ALTERNATE_SOURCES
,      SUBSTITUTION_DESIGNATOR
,      CURR_PLAN_TYPE
,      CURR_HARD_PEGGING_LEVEL
,      CURR_RESERVATION_LEVEL
,      CURR_ENABLE_CLOSEST_QTY_PEG
,      CURR_ENABLE_PRIORITY_PEG
FROM APPS.MSC_PDR_PLAN_DETAILS_V1;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

MSC_GET_NAME - show dependent code

MSC_PDR_PARAMETERS_NEW

MSC_PLANS

MSC_PLAN_PARAMETERS_V

APPS

MSC_PDR_PLAN_DETAILS_V