[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ISC_DR_BKLG_01_MV |
|---|---|
| Object Type: | MATERIALIZED VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Container: | ISC_DR_BKLG_01_MV |
|---|---|
| Updatable: | N |
| Rewrite Enabled: | N |
| Rewrite Capability: | GENERAL |
| Refresh Mode: | DEMAND |
| Refresh Method: | FAST |
| Build Mode: | DEFERRED |
| Fast Refreshable: | DIRLOAD_DML |
BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
ISC_DR_REPAIR_ORDERS_F
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPAIR_ORGANIZATION_ID | NUMBER | (15) | Yes | Repair Organization Identifier |
| ITEM_ORG_ID | VARCHAR2 | (25) | Inventory Item identifier | |
| PRODUCT_CATEGORY_ID | NUMBER | Product Category Identifier | ||
| REPAIR_TYPE_ID | NUMBER | (15) | Repair type Identifier | |
| CUSTOMER_ID | NUMBER | (15) | Customer Identifier | |
| TIME_ID | NUMBER | Activity date time identifier | ||
| PERIOD_TYPE_ID | NUMBER | Activity date period type identifier | ||
| YEAR_ID | NUMBER | Activity date year identifier | ||
| QTR_ID | NUMBER | Activity date quarter identifier | ||
| MONTH_ID | NUMBER | Activity date month identifier | ||
| WEEK_ID | NUMBER | Activity date week identifier | ||
| DAY_ID | NUMBER | Activity date day identifier | ||
| OPEN_COUNT | NUMBER | Number of orders opened as of the activity date. | ||
| CLOSE_COUNT | NUMBER | Number of orders closed as of the activity date. | ||
| PAST_DUE_OPEN_COUNT | NUMBER | Number of orders that became past due as of the activity date. | ||
| LATE_COMPLETE_COUNT | NUMBER | Number of orders that we completed late as of the activity date. | ||
| COMPLETE_WITH_PROMISE_DATE_CNT | NUMBER | Number of orders that we completed on time as of the activity date. | ||
| DAYS_LATE | NUMBER | Total days late for all the repair orders that are Late closed as of the activity date. | ||
| COUNT_DAYS_LATE_MV | NUMBER | Count column for MV fast refreshability. | ||
| DAYS_LATE_AGE_B1 | NUMBER | Number of Repair Orders which fall in first bucket for late complete. | ||
| DAYS_LATE_AGE_B2 | NUMBER | Number of Repair Orders which fall in second bucket for late complete. | ||
| DAYS_LATE_AGE_B3 | NUMBER | Number of Repair Orders which fall in third bucket for late complete. | ||
| DAYS_LATE_AGE_B4 | NUMBER | Number of Repair Orders which fall in fourth bucket for late complete. | ||
| DAYS_LATE_AGE_B5 | NUMBER | Number of Repair Orders which fall in fifth bucket for late complete. | ||
| DAYS_LATE_AGE_B6 | NUMBER | Number of Repair Orders which fall in sixth bucket for late complete. | ||
| DAYS_LATE_AGE_B7 | NUMBER | Number of Repair Orders which fall in seventh bucket for late complete. | ||
| DAYS_LATE_AGE_B8 | NUMBER | Number of Repair Orders which fall in eigth bucket for late complete. | ||
| DAYS_LATE_AGE_B9 | NUMBER | Number of Repair Orders which fall in ninth bucket for late complete. | ||
| DAYS_LATE_AGE_B10 | NUMBER | Number of Repair Orders which fall in tenth bucket for late complete. | ||
| AGGREGATION_FLAG | NUMBER | MV Level aggregation flag | ||
| GRP_ID_MV | NUMBER | Grouping id column for MV fast refreshability. | ||
| COUNT_MV | NUMBER | Count column for MV fast refreshability. |
Cut, paste (and edit) the following text to query this object:
SELECT REPAIR_ORGANIZATION_ID
, ITEM_ORG_ID
, PRODUCT_CATEGORY_ID
, REPAIR_TYPE_ID
, CUSTOMER_ID
, TIME_ID
, PERIOD_TYPE_ID
, YEAR_ID
, QTR_ID
, MONTH_ID
, WEEK_ID
, DAY_ID
, OPEN_COUNT
, CLOSE_COUNT
, PAST_DUE_OPEN_COUNT
, LATE_COMPLETE_COUNT
, COMPLETE_WITH_PROMISE_DATE_CNT
, DAYS_LATE
, COUNT_DAYS_LATE_MV
, DAYS_LATE_AGE_B1
, DAYS_LATE_AGE_B2
, DAYS_LATE_AGE_B3
, DAYS_LATE_AGE_B4
, DAYS_LATE_AGE_B5
, DAYS_LATE_AGE_B6
, DAYS_LATE_AGE_B7
, DAYS_LATE_AGE_B8
, DAYS_LATE_AGE_B9
, DAYS_LATE_AGE_B10
, AGGREGATION_FLAG
, GRP_ID_MV
, COUNT_MV
FROM APPS.ISC_DR_BKLG_01_MV;
APPS
ISC_DR_BKLG_01_MV
BIS
BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
ENI
ENI_OLTP_ITEM_STAR
FII
FII_TIME_DAY
ISC
ISC_DR_REPAIR_ORDERS_F
APPS
ISC_DR_BKLG_02_MV
|
|
|
|