eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ISC_MSC_BIS_PLANS_V

Object Details

Object Name:	ISC_MSC_BIS_PLANS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Plan identifier
VALUE	VARCHAR2	(10)	Yes	Name of the plan
OWNING_ORG_ID	VARCHAR2	(81)		Source instance id for the org\|\|'-'\|\|Organization
SERVICE_LEVEL	NUMBER			Service level
CATEGORY_SET_ID	NUMBER		Yes	Category set identifier
CATEGORY_SET_NAME	VARCHAR2	(30)	Yes	Category set name
PLAN_TYPE	NUMBER		Yes	Specify whether the plan is MRP, DRP or MPS plan
PERIOD_COUNT	NUMBER			Number of periods in the plan

Query Text

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


SELECT ID
,      VALUE
,      OWNING_ORG_ID
,      SERVICE_LEVEL
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      PLAN_TYPE
,      PERIOD_COUNT
FROM APPS.ISC_MSC_BIS_PLANS_V;

Dependencies

[top of page]

APPS.ISC_MSC_BIS_PLANS_V references the following:

APPS: MSC_BIS_PERIODS; MSC_CATEGORY_SETS; MSC_PLANS

APPS.ISC_MSC_BIS_PLANS_V is referenced by following:

APPS: ISC_MSC_COST_BREAKDOWN_V; ISC_MSC_MFG_MEASURES_V; ISC_MSC_MFG_SERVICE_V; ISC_MSC_POST_COST_TREND_V; ISC_MSC_POST_COST_V; ISC_MSC_PURCHASING_V; ISC_MSC_SERVICE_LEVELS_V