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

VIEW: APPS.ISC_MSC_MFG_MEASURES_V

Object Details
Object Name: ISC_MSC_MFG_MEASURES_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 Gross Profit and Cost Breakdown Summary reports.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CARRYING_COST NUMBER

Total carrying cost for the plan
PENALTY_COST NUMBER

Penalty cost for the plan demand
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
COST NUMBER

Tota MDS cost of the plan
INVENTORY_VALUE NUMBER

Inventory value
INVENTORY_VALUE_NO_POST NUMBER

Inventory Value No Post
PLAN_ID NUMBER
Yes Organization 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
CATEGORY_SET_ID VARCHAR2 (40)
Category set identifier
CATEGORY_ID VARCHAR2 (290)
Category set identifier||Category set name
ITEM_ID NUMBER

Inventory item identifier
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 CARRYING_COST
,      PENALTY_COST
,      PRODUCTION_COST
,      PURCHASING_COST
,      REVENUE
,      COST
,      INVENTORY_VALUE
,      INVENTORY_VALUE_NO_POST
,      PLAN_ID
,      OWNING_ORG_ID
,      ORGANIZATION_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      ITEM_ID
,      PERIOD_ID
,      QUARTER_ID
,      YEAR_ID
FROM APPS.ISC_MSC_MFG_MEASURES_V;

Dependencies

[top of page]

APPS.ISC_MSC_MFG_MEASURES_V references the following:

SchemaAPPS
ViewISC_MSC_BIS_PERIODS_V
ViewISC_MSC_BIS_PLANS_V
ViewISC_MSC_BIS_QUARTERS_V
ViewISC_MSC_BIS_YEARS_V
SynonymMSC_BIS_INV_DETAIL
SynonymMSC_ITEM_CATEGORIES

APPS.ISC_MSC_MFG_MEASURES_V is not referenced by any database object