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_SERVICE_LEVELS_V

Object Details

Object Name:	ISC_MSC_SERVICE_LEVELS_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 is used by the ISC_MSC_MFG_SERVICE_V view.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TOTAL_DEMAND	NUMBER			Total demand quantity
SATISFIED_DEMAND	NUMBER			Total demand quantity that can be satisfied
PLAN_ID	NUMBER		Yes	Plan identifier
OWNING_ORG_ID	VARCHAR2	(81)		Source instance id for the org\|\|'-'\|\|Organization identifier of the organization owning the plan
ORGANIZATION_ID	VARCHAR2	(81)		Source application instance identifier\|\|'-'\|\|Organization identifier
ITEM_ID	NUMBER		Yes	Using assembly item identifier (item generating the demand for dependent demands)
CATEGORY_SET_ID	VARCHAR2	(40)		Category set identifier
CATEGORY_ID	VARCHAR2	(290)		Category set identifier\|\|Category set name
CUSTOMER_ID	VARCHAR2	(40)		Customer identifier
DEMAND_CLASS_ID	VARCHAR2	(34)		Demand class code
PERIOD_ID	VARCHAR2	(97)		Source application instance identifier\|\|'-'\|\|Organization identifier\|\|'-'\|\|System generated accounting period name
QUARTER_ID	VARCHAR2	(163)		Source application instance identifier\|\|'-'\|\|Organization identifier\|\|'-'\|\|Accounting period year\|\|'-'\|\|Quarter number of accounting period
YEAR_ID	VARCHAR2	(122)		Source application instance identifier\|\|'-'\|\|Organization identifier\|\|'-'\|\|Accounting period year

Query Text

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


SELECT TOTAL_DEMAND
,      SATISFIED_DEMAND
,      PLAN_ID
,      OWNING_ORG_ID
,      ORGANIZATION_ID
,      ITEM_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      CUSTOMER_ID
,      DEMAND_CLASS_ID
,      PERIOD_ID
,      QUARTER_ID
,      YEAR_ID
FROM APPS.ISC_MSC_SERVICE_LEVELS_V;

Dependencies

[top of page]

APPS.ISC_MSC_SERVICE_LEVELS_V references the following:

APPS: ISC_MSC_BIS_PERIODS_V; ISC_MSC_BIS_PLANS_V; ISC_MSC_BIS_QUARTERS_V; ISC_MSC_BIS_YEARS_V; MSC_DEMANDS; MSC_ITEM_CATEGORIES

APPS.ISC_MSC_SERVICE_LEVELS_V is referenced by following:

APPS: ISC_MSC_MFG_SERVICE_V