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.MSC_COST_BREAKDOWN_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

Cost Break Down View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Plan Identifier
PLAN_NAME	VARCHAR2	(4000)		compile_designator
SR_INSTANCE_ID	NUMBER		Yes	source instance identifier
ORGANIZATION_ID	NUMBER		Yes	organization identifier
ORG_CODE	VARCHAR2	(4000)		organization code
DETAIL_DATE	DATE		Yes	detail date
CATEGORY_SET_ID	NUMBER		Yes	category set identifier
CATEGORY_ID	NUMBER		Yes	category identifier
CATEGORY_NAME	VARCHAR2	(250)	Yes	category name
INVENTORY_ITEM_ID	NUMBER			item identifier
ITEM_NAME	VARCHAR2	(4000)		item name
PLANNED_PRODUCTION_COST	NUMBER			production cost
PLANNED_CARRYING_COST	NUMBER			carrying cost
PLANNED_PURCHASING_COST	NUMBER			purchasing cost
PLANNED_TP_COST	NUMBER			transportation cost
INT_REPAIR_COST	NUMBER			internal repair cost
EXT_REPAIR_COST	NUMBER			external repair cost
PLANNED_TOTAL_COST	NUMBER			total cost sum of production, carrying, purchasing, transportation
DETAIL_LEVEL	NUMBER			period data or week data
PERIOD_TYPE	NUMBER			mfg data or bis data
PERIOD_TYPE_URL	VARCHAR2	(15)		internal use only- for fwk page url
PLANNED_REVENUE	NUMBER			revenue
QUERY_ID	NUMBER		Yes	internal use only - query id from temp table

Query Text

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


SELECT PLAN_ID
,      PLAN_NAME
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      ORG_CODE
,      DETAIL_DATE
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      CATEGORY_NAME
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      PLANNED_PRODUCTION_COST
,      PLANNED_CARRYING_COST
,      PLANNED_PURCHASING_COST
,      PLANNED_TP_COST
,      INT_REPAIR_COST
,      EXT_REPAIR_COST
,      PLANNED_TOTAL_COST
,      DETAIL_LEVEL
,      PERIOD_TYPE
,      PERIOD_TYPE_URL
,      PLANNED_REVENUE
,      QUERY_ID
FROM APPS.MSC_COST_BREAKDOWN_V;

Dependencies

[top of page]

APPS.MSC_COST_BREAKDOWN_V references the following:

APPS: MSC_ANALYSIS_PKG - show dependent code; MSC_BIS_INV_DETAIL; MSC_FORM_QUERY; MSC_GET_NAME - show dependent code; MSC_ITEM_CATEGORIES

APPS.MSC_COST_BREAKDOWN_V is not referenced by any database object