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

VIEW: APPS.ISC_MSC_MFG_SERVICE_V

Object Details
Object Name: ISC_MSC_MFG_SERVICE_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 Service Level vs Profit report.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CARRYING_COST NUMBER

Total carrying cost for the plan
PRODUCTION_COST NUMBER

Total production cost of the plan
PURCHASING_COST NUMBER

Total purchasing cost for the plan
REVENUE NUMBER

Total MDS price of the plan
INVENTORY_VALUE NUMBER

Inventory value
TOTAL_DEMAND NUMBER

Total demand quantity
SATISFIED_DEMAND NUMBER

Total demand quantity that can be satisfied
TARGET_SERVICE_LEVEL NUMBER

Service level
PLAN_ID NUMBER
Yes Organization identifier
OWNING_ORG VARCHAR2 (255) Yes Name of the Organization
PLAN_NAME VARCHAR2 (10) Yes Name of the plan
CATEGORY_SET_NAME VARCHAR2 (30) Yes Category set name
Query Text

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


SELECT CARRYING_COST
,      PRODUCTION_COST
,      PURCHASING_COST
,      REVENUE
,      INVENTORY_VALUE
,      TOTAL_DEMAND
,      SATISFIED_DEMAND
,      TARGET_SERVICE_LEVEL
,      PLAN_ID
,      OWNING_ORG
,      PLAN_NAME
,      CATEGORY_SET_NAME
FROM APPS.ISC_MSC_MFG_SERVICE_V;

Dependencies

[top of page]

APPS.ISC_MSC_MFG_SERVICE_V references the following:

SchemaAPPS
ViewISC_MSC_BIS_INV_ORGS_V
ViewISC_MSC_BIS_PLANS_V
ViewISC_MSC_SERVICE_LEVELS_V
SynonymMSC_BIS_INV_DETAIL

APPS.ISC_MSC_MFG_SERVICE_V is not referenced by any database object