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]

TABLE: APPS.ISC_DR_CURR_02_MV

Object Details

Object Name:	ISC_DR_CURR_02_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.ISC_DR_CURR_02_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_DR_CURR_02_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	AGGREGATION_FLAG CUSTOMER_ID PRODUCT_CATEGORY_ID REPAIR_ORGANIZATION_ID REPAIR_TYPE_ID

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.ISC_DR_CURR_02_MV does not reference any database object

APPS.ISC_DR_CURR_02_MV is referenced by following:

APPS: ISC_DR_CURR_02_MV