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_FS_007_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_ISC_FS_007_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("REPORT_DATE") SYS_OP_MAP_NONNULL("PARENT_DISTRICT_ID") SYS_OP_MAP_NONNULL("RECORD_TYPE") SYS_OP_MAP_NONNULL("DISTRICT_ID") SYS_OP_MAP_NONNULL("DISTRICT_ID_C") SYS_OP_MAP_NONNULL("TASK_TYPE_ID") SYS_OP_MAP_NONNULL("VBH_CATEGORY_ID") SYS_OP_MAP_NONNULL("PRODUCT_ID") SYS_OP_MAP_NONNULL("CUSTOMER_ID") SYS_OP_MAP_NONNULL("GRP_ID") SYS_OP_MAP_NONNULL("MV_GRP_ID")
ISC_FS_007_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	MV_COUNT
ISC_FS_007_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	REPORT_DATE GRP_ID PARENT_DISTRICT_ID DISTRICT_ID_C

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_DATE	DATE		Yes	Backlog Aging report date
GRP_ID	NUMBER			Rollup group identifier. Used to identify the rollup group attributed to the row
PARENT_DISTRICT_ID	NUMBER			Parent District identifier
RECORD_TYPE	VARCHAR2	(8)		Indicates if DISTRICT_ID contains RESOURCE_ID, GROUP_ID or TEAM_ID
DISTRICT_ID	NUMBER			District identifier, may be for RESOURCE, GROUP or TEAM
DISTRICT_ID_C	VARCHAR2	(81)		Concatenated District identifier, DISTRICT_ID.PARENT_DISTRICT_ID
TASK_TYPE_ID	NUMBER			Task Type identifier
CUSTOMER_ID	NUMBER			Customer identifier
PRODUCT_ID	VARCHAR2	(25)		Product identifier
VBH_CATEGORY_ID	NUMBER			Product Category identifier
BACKLOG_COUNT	NUMBER			Count of Tasks in backlog
TOTAL_BACKLOG_AGE	NUMBER			Total Age in Days for Tasks in backlog
BACKLOG_AGE_B1	NUMBER			Count of Tasks in backlog in aging bucket range 1
BACKLOG_AGE_B2	NUMBER			Count of Tasks in backlog in aging bucket range 2
BACKLOG_AGE_B3	NUMBER			Count of Tasks in backlog in aging bucket range 3
BACKLOG_AGE_B4	NUMBER			Count of Tasks in backlog in aging bucket range 4
BACKLOG_AGE_B5	NUMBER			Count of Tasks in backlog in aging bucket range 5
BACKLOG_AGE_B6	NUMBER			Count of Tasks in backlog in aging bucket range 6
BACKLOG_AGE_B7	NUMBER			Count of Tasks in backlog in aging bucket range 7
BACKLOG_AGE_B8	NUMBER			Count of Tasks in backlog in aging bucket range 8
BACKLOG_AGE_B9	NUMBER			Count of Tasks in backlog in aging bucket range 9
BACKLOG_AGE_B10	NUMBER			Count of Tasks in backlog in aging bucket range 10
MV_GRP_ID	NUMBER			Grouping ID Column
MV_COUNT	NUMBER			Row Count
MV_TOTAL_BACKLOG_AGE	NUMBER			Count Column
MV_BACKLOG_AGE_B1	NUMBER			Count Column
MV_BACKLOG_AGE_B2	NUMBER			Count Column
MV_BACKLOG_AGE_B3	NUMBER			Count Column
MV_BACKLOG_AGE_B4	NUMBER			Count Column
MV_BACKLOG_AGE_B5	NUMBER			Count Column
MV_BACKLOG_AGE_B6	NUMBER			Count Column
MV_BACKLOG_AGE_B7	NUMBER			Count Column
MV_BACKLOG_AGE_B8	NUMBER			Count Column
MV_BACKLOG_AGE_B9	NUMBER			Count Column
MV_BACKLOG_AGE_B10	NUMBER			Count Column

Query Text

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


SELECT REPORT_DATE
,      GRP_ID
,      PARENT_DISTRICT_ID
,      RECORD_TYPE
,      DISTRICT_ID
,      DISTRICT_ID_C
,      TASK_TYPE_ID
,      CUSTOMER_ID
,      PRODUCT_ID
,      VBH_CATEGORY_ID
,      BACKLOG_COUNT
,      TOTAL_BACKLOG_AGE
,      BACKLOG_AGE_B1
,      BACKLOG_AGE_B2
,      BACKLOG_AGE_B3
,      BACKLOG_AGE_B4
,      BACKLOG_AGE_B5
,      BACKLOG_AGE_B6
,      BACKLOG_AGE_B7
,      BACKLOG_AGE_B8
,      BACKLOG_AGE_B9
,      BACKLOG_AGE_B10
,      MV_GRP_ID
,      MV_COUNT
,      MV_TOTAL_BACKLOG_AGE
,      MV_BACKLOG_AGE_B1
,      MV_BACKLOG_AGE_B2
,      MV_BACKLOG_AGE_B3
,      MV_BACKLOG_AGE_B4
,      MV_BACKLOG_AGE_B5
,      MV_BACKLOG_AGE_B6
,      MV_BACKLOG_AGE_B7
,      MV_BACKLOG_AGE_B8
,      MV_BACKLOG_AGE_B9
,      MV_BACKLOG_AGE_B10
FROM APPS.ISC_FS_007_MV;

Dependencies

[top of page]

APPS.ISC_FS_007_MV does not reference any database object

APPS.ISC_FS_007_MV is referenced by following:

APPS: ISC_FS_007_MV; ISC_FS_008_MV