[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ISC_DR_BKLG_02_MV |
|---|---|
| Object Type: | TABLE |
| Owner: | APPS |
| FND Design Data: |  FND.ISC_DR_BKLG_02_MV
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| I_SNAP$_ISC_DR_BKLG_02_MV | FUNCTION-BASED NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 SYS_OP_MAP_NONNULL("TIME_ID")
SYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
SYS_OP_MAP_NONNULL("PRODUCT_CATEGORY_ID")
SYS_OP_MAP_NONNULL("REPAIR_ORGANIZATION_ID")
SYS_OP_MAP_NONNULL("CUSTOMER_ID")
SYS_OP_MAP_NONNULL("REPAIR_TYPE_ID")
SYS_OP_MAP_NONNULL("GRP_ID_MV")
|
| ISC_DR_BKLG_02_MV_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
TIME_ID
AGGREGATION_FLAG
CUSTOMER_ID
REPAIR_ORGANIZATION_ID
REPAIR_TYPE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPAIR_ORGANIZATION_ID | NUMBER | (15) | Repair Organization 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 | ||
| 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. | ||
| 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. | ||
| COUNT_OPEN_MV | NUMBER | Number of orders opened as of the activity date. | ||
| COUNT_CLOSE_MV | NUMBER | Number of orders closed as of the activity date. | ||
| COUNT_PAST_DUE_MV | NUMBER | Number of orders that became past due as of the activity date. | ||
| COUNT_LATE_COMPLETE_MV | NUMBER | Number of orders that we completed late as of the activity date. | ||
| COMPLETE_WITH_PROM_DATE_CNT_MV | NUMBER | Number of orders that we completed on time as of the activity date. | ||
| COUNT_DAYS_LATE_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B1_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B2_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B3_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B4_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B5_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B6_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B7_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B8_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B9_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_DAYS_LATE_AGE_B10_MV | NUMBER | Count column for MV fast refreshability. | ||
| COUNT_MV | NUMBER | Count column for MV fast refreshability. | ||
| GRP_ID_MV | NUMBER | Grouping id column for MV fast refreshability. | ||
| AGGREGATION_FLAG | NUMBER | MV Level aggregation flag |
Cut, paste (and edit) the following text to query this object:
SELECT REPAIR_ORGANIZATION_ID
, PRODUCT_CATEGORY_ID
, REPAIR_TYPE_ID
, CUSTOMER_ID
, TIME_ID
, PERIOD_TYPE_ID
, OPEN_COUNT
, CLOSE_COUNT
, PAST_DUE_OPEN_COUNT
, LATE_COMPLETE_COUNT
, COMPLETE_WITH_PROMISE_DATE_CNT
, DAYS_LATE
, 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
, COUNT_OPEN_MV
, COUNT_CLOSE_MV
, COUNT_PAST_DUE_MV
, COUNT_LATE_COMPLETE_MV
, COMPLETE_WITH_PROM_DATE_CNT_MV
, COUNT_DAYS_LATE_MV
, COUNT_DAYS_LATE_AGE_B1_MV
, COUNT_DAYS_LATE_AGE_B2_MV
, COUNT_DAYS_LATE_AGE_B3_MV
, COUNT_DAYS_LATE_AGE_B4_MV
, COUNT_DAYS_LATE_AGE_B5_MV
, COUNT_DAYS_LATE_AGE_B6_MV
, COUNT_DAYS_LATE_AGE_B7_MV
, COUNT_DAYS_LATE_AGE_B8_MV
, COUNT_DAYS_LATE_AGE_B9_MV
, COUNT_DAYS_LATE_AGE_B10_MV
, COUNT_MV
, GRP_ID_MV
, AGGREGATION_FLAG
FROM APPS.ISC_DR_BKLG_02_MV;
APPS.ISC_DR_BKLG_02_MV does not reference any database object
APPS.ISC_DR_BKLG_02_MV is referenced by following:
APPS
ISC_DR_BKLG_02_MV
|
|
|
|