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_DR_MRGN_02_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Comments
REPAIR_ORGANIZATION_ID	NUMBER	(15)	Repair Organization Identifier
PRODUCT_CATEGORY_ID	NUMBER		Leaf Node Product Category Identifier
CUSTOMER_ID	NUMBER	(15)	Customer Identifier
REPAIR_TYPE_ID	NUMBER	(15)	Repair Type Identifier
GRP_ID	NUMBER		Grouping ID
AGGREGATION_FLAG	NUMBER		MV Level Aggregation flag
TIME_ID	NUMBER		Activity Date time Identifier
PERIOD_TYPE_ID	NUMBER		Period Type Identifier
MATERIAL_CHARGES_G	NUMBER		Material Charges in Global currency
MATERIAL_CHARGES_SG	NUMBER		Material Charges in Secondary Global currency
LABOR_CHARGES_G	NUMBER		Labor Charges in Global currency
LABOR_CHARGES_SG	NUMBER		Labor Charges in Secondary Global currency
EXPENSE_CHARGES_G	NUMBER		Expense Charges in Global currency
EXPENSE_CHARGES_SG	NUMBER		Expense Charges in Secondary Global currency
MATERIAL_COST_G	NUMBER		Material Cost in Global currency
MATERIAL_COST_SG	NUMBER		Material Cost in Secondary Global currency
LABOR_COST_G	NUMBER		Labor Cost in Global currency
LABOR_COST_SG	NUMBER		Labor Cost in Secondary Global currency
EXPENSE_COST_G	NUMBER		Expense Cost in Global currency
EXPENSE_COST_SG	NUMBER		Expense Cost in Secondary Global currency

Query Text

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


SELECT REPAIR_ORGANIZATION_ID
,      PRODUCT_CATEGORY_ID
,      CUSTOMER_ID
,      REPAIR_TYPE_ID
,      GRP_ID
,      AGGREGATION_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      MATERIAL_CHARGES_G
,      MATERIAL_CHARGES_SG
,      LABOR_CHARGES_G
,      LABOR_CHARGES_SG
,      EXPENSE_CHARGES_G
,      EXPENSE_CHARGES_SG
,      MATERIAL_COST_G
,      MATERIAL_COST_SG
,      LABOR_COST_G
,      LABOR_COST_SG
,      EXPENSE_COST_G
,      EXPENSE_COST_SG
FROM APPS.ISC_DR_MRGN_02_V;

Dependencies

[top of page]

APPS.ISC_DR_MRGN_02_V references the following:

APPS: ISC_DR_CHARGES_02_MV; ISC_DR_COSTS_02_MV

APPS.ISC_DR_MRGN_02_V is not referenced by any database object