[Home] [Help] [Dependency Information]
Object Name: | ISC_FS_002_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.ISC_FS_002_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_FS_002_MV_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PARENT_PRG_ID
RG_ID |
U2_SNAP$_ISC_FS_002_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("RG_ID")
SYS_OP_MAP_NONNULL("PRG_ID") SYS_OP_MAP_NONNULL("PARENT_PRG_ID") SYS_OP_MAP_NONNULL("IMMEDIATE_PARENT_FLAG") |
ISC_FS_002_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | MV_COUNT |
ISC_FS_002_MV_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
RG_ID
PARENT_PRG_ID |
U1_SNAP$_ISC_FS_002_MV | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SYS_OP_MAP_NONNULL("RG_ID") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_TYPE | VARCHAR2 | (8) | Record type idendifier. GROUP or RESOURCE | |
RG_ID | NUMBER | JTF RESOURCE GROUP Identifier | ||
PRG_ID | NUMBER | Parent JTF RESOURCE GROUP Identifier | ||
PARENT_PRG_ID | NUMBER | Parent of Parent JTF RESOURCE GROUP Identifier | ||
IMMEDIATE_PARENT_FLAG | VARCHAR2 | (1) | Indicates whether the value in PRG_ID is the identifier of immediate parent group | |
MV_COUNT | NUMBER | Row Count |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_TYPE
, RG_ID
, PRG_ID
, PARENT_PRG_ID
, IMMEDIATE_PARENT_FLAG
, MV_COUNT
FROM APPS.ISC_FS_002_MV;
APPS.ISC_FS_002_MV does not reference any database object
APPS.ISC_FS_002_MV is referenced by following:
|
|
|