Skip to content

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

MATERIALIZED VIEW: APPS.ISC_DR_COSTS_01_MV

Object Details
Object Name: ISC_DR_COSTS_01_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DR_COSTS_01_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

ENI_OLTP_ITEM_STAR
FII_TIME_DAY
ISC_DR_COSTS_F
ISC_DR_REPAIR_ORDERS_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
REPAIR_ORGANIZATION_ID NUMBER (15) Yes Repair Organization Identifier
PRODUCT_CATEGORY_ID NUMBER

Leaf Node Product Category Identifier
ITEM_ORG_ID VARCHAR2 (25)
Item Organization 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
QTR_ID NUMBER

Activity Date Quarter identifier
PERIOD_ID NUMBER

Activity Date Month Identifier
WEEK_ID NUMBER

Activity Date Week identifier
DAY_ID NUMBER

Activity Date Day identifier
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
MV_MATERIAL_COST_G_CNT NUMBER

Count Column
MV_MATERIAL_COST_SG_CNT NUMBER

Count Column
MV_LABOR_COST_G_CNT NUMBER

Count Column
MV_LABOR_COST_SG_CNT NUMBER

Count Column
MV_EXPENSE_COST_G_CNT NUMBER

Count Column
MV_EXPENSE_COST_SG_CNT NUMBER

Count Column
MV_CNT NUMBER

Row Count
Query Text

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


SELECT REPAIR_ORGANIZATION_ID
,      PRODUCT_CATEGORY_ID
,      ITEM_ORG_ID
,      CUSTOMER_ID
,      REPAIR_TYPE_ID
,      GRP_ID
,      AGGREGATION_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      QTR_ID
,      PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      MATERIAL_COST_G
,      MATERIAL_COST_SG
,      LABOR_COST_G
,      LABOR_COST_SG
,      EXPENSE_COST_G
,      EXPENSE_COST_SG
,      MV_MATERIAL_COST_G_CNT
,      MV_MATERIAL_COST_SG_CNT
,      MV_LABOR_COST_G_CNT
,      MV_LABOR_COST_SG_CNT
,      MV_EXPENSE_COST_G_CNT
,      MV_EXPENSE_COST_SG_CNT
,      MV_CNT
FROM APPS.ISC_DR_COSTS_01_MV;

Dependencies

[top of page]

APPS.ISC_DR_COSTS_01_MV references the following:

SchemaAPPS
TableISC_DR_COSTS_01_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY
SchemaISC
TableISC_DR_COSTS_F
TableISC_DR_REPAIR_ORDERS_F
APPS.ISC_DR_COSTS_01_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DR_COSTS_02_MV