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

VIEW: APPS.MSC_SRVLVL_PROFIT_V

Object Details
Object Name: MSC_SRVLVL_PROFIT_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.


service level profit view


[View Source]

Columns
Name Datatype Length Mandatory Comments
PLANNED_PRODUCTION_COST NUMBER

production cost
PLANNED_CARRYING_COST NUMBER

carrying cost
PLANNED_PURCHASING_COST NUMBER

purchasing 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
PLANNED_REVENUE NUMBER

revenue
PLANNED_GROSS_PROFIT NUMBER

Gross Profit
PLANNED_GROSS_PROFIT_PCT NUMBER

Gross profit %
INVENTORY_VALUE NUMBER

inventory value
PLAN_ID NUMBER
Yes plan identifier
Query Text

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


SELECT PLANNED_PRODUCTION_COST
,      PLANNED_CARRYING_COST
,      PLANNED_PURCHASING_COST
,      INT_REPAIR_COST
,      EXT_REPAIR_COST
,      PLANNED_TOTAL_COST
,      PLANNED_REVENUE
,      PLANNED_GROSS_PROFIT
,      PLANNED_GROSS_PROFIT_PCT
,      INVENTORY_VALUE
,      PLAN_ID
FROM APPS.MSC_SRVLVL_PROFIT_V;

Dependencies

[top of page]

APPS.MSC_SRVLVL_PROFIT_V references the following:

SchemaAPPS
SynonymMSC_BIS_INV_DETAIL

APPS.MSC_SRVLVL_PROFIT_V is not referenced by any database object