[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ISC_DR_CURR_02_MV |
|---|---|
| Object Type: | MATERIALIZED VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Container: | ISC_DR_CURR_02_MV |
|---|---|
| Updatable: | N |
| Rewrite Enabled: | N |
| Rewrite Capability: | GENERAL |
| Refresh Mode: | DEMAND |
| Refresh Method: | COMPLETE |
| Build Mode: | DEFERRED |
| Fast Refreshable: | NO |
BIS_BUCKET_CUSTOMIZATIONS
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ITEM_ORG_ID | VARCHAR2 | (25) | Item Org Identifier | |
| PRODUCT_CATEGORY_ID | NUMBER | Product Category Identifier | ||
| REPAIR_ORGANIZATION_ID | NUMBER | (15) | Yes | Repair Organization Identifier |
| REPAIR_TYPE_ID | NUMBER | (15) | Repair Type Identifier | |
| CUSTOMER_ID | NUMBER | (15) | Customer Identifier | |
| BACKLOG_COUNT | NUMBER | Number of repair order in backlog | ||
| PAST_DUE_COUNT | NUMBER | Number of repair orders past due | ||
| NOT_PROMISED_COUNT | NUMBER | Number of orders not promised | ||
| DAYS_UNTIL_PROMISED_B1 | NUMBER | Number of orders for which Promised_date - Collection Date is between range1_low and range1_high | ||
| DAYS_UNTIL_PROMISED_B2 | NUMBER | Number of orders for which Promised_date - Collection Date is between range2_low and range2_high | ||
| DAYS_UNTIL_PROMISED_B3 | NUMBER | Number of orders for which Promised_date - Collection Date is between range3_low and range3_high | ||
| DAYS_UNTIL_PROMISED_B4 | NUMBER | Number of orders for which Promised_date - Collection Date is between range4_low and range4_high | ||
| DAYS_UNTIL_PROMISED_B5 | NUMBER | Number of orders for which Promised_date - Collection Date is between range5_low and range5_high | ||
| DAYS_UNTIL_PROMISED_B6 | NUMBER | Number of orders for which Promised_date - Collection Date is between range6_low and range6_high | ||
| DAYS_UNTIL_PROMISED_B7 | NUMBER | Number of orders for which Promised_date - Collection Date is between range7_low and range7_high | ||
| DAYS_UNTIL_PROMISED_B8 | NUMBER | Number of orders for which Promised_date - Collection Date is between range8_low and range8_high | ||
| DAYS_UNTIL_PROMISED_B9 | NUMBER | Number of orders for which Promised_date - Collection Date is between range9_low and range9_high | ||
| DAYS_UNTIL_PROMISED_B10 | NUMBER | Number of orders for which Promised_date - Collection Date is between range10_low and range10_high | ||
| PAST_DUE_AGE_B1 | NUMBER | Number of Orders for which past due days falls in first past due aging bucket. | ||
| PAST_DUE_AGE_B2 | NUMBER | Number of Orders for which past due days falls in second past due aging bucket. | ||
| PAST_DUE_AGE_B3 | NUMBER | Number of Orders for which past due days falls in third past due aging bucket. | ||
| PAST_DUE_AGE_B4 | NUMBER | Number of Orders for which past due days falls in fourth past due aging bucket. | ||
| PAST_DUE_AGE_B5 | NUMBER | Number of Orders for which past due days falls in fifth past due aging bucket. | ||
| PAST_DUE_AGE_B6 | NUMBER | Number of Orders for which past due days falls in sixth past due aging bucket. | ||
| PAST_DUE_AGE_B7 | NUMBER | Number of Orders for which past due days falls in seventh past due aging bucket. | ||
| PAST_DUE_AGE_B8 | NUMBER | Number of Orders for which past due days falls in eigth past due aging bucket. | ||
| PAST_DUE_AGE_B9 | NUMBER | Number of Orders for which past due days falls in ninth past due aging bucket. | ||
| PAST_DUE_AGE_B10 | NUMBER | Number of Orders for which past due days falls in tenth past due aging bucket. | ||
| AGGREGATION_FLAG | NUMBER | MV Level aggregation flag |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ORG_ID
, PRODUCT_CATEGORY_ID
, REPAIR_ORGANIZATION_ID
, REPAIR_TYPE_ID
, CUSTOMER_ID
, BACKLOG_COUNT
, PAST_DUE_COUNT
, NOT_PROMISED_COUNT
, DAYS_UNTIL_PROMISED_B1
, DAYS_UNTIL_PROMISED_B2
, DAYS_UNTIL_PROMISED_B3
, DAYS_UNTIL_PROMISED_B4
, DAYS_UNTIL_PROMISED_B5
, DAYS_UNTIL_PROMISED_B6
, DAYS_UNTIL_PROMISED_B7
, DAYS_UNTIL_PROMISED_B8
, DAYS_UNTIL_PROMISED_B9
, DAYS_UNTIL_PROMISED_B10
, PAST_DUE_AGE_B1
, PAST_DUE_AGE_B2
, PAST_DUE_AGE_B3
, PAST_DUE_AGE_B4
, PAST_DUE_AGE_B5
, PAST_DUE_AGE_B6
, PAST_DUE_AGE_B7
, PAST_DUE_AGE_B8
, PAST_DUE_AGE_B9
, PAST_DUE_AGE_B10
, AGGREGATION_FLAG
FROM APPS.ISC_DR_CURR_02_MV;
APPS
ISC_DR_CURR_01_MV
ISC_DR_CURR_01_MV
ISC_DR_CURR_02_MV
BIS
BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
APPS.ISC_DR_CURR_02_MV is not referenced by any database object
|
|
|
|