[Home] [Help] [Dependency Information]
Object Name: | FND_IMP_PISUMMARY |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_IMP_PISUMMARY |
Subobject Name: | |
Status: | VALID |
FND_IMP_PISUMMARY
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_IMP_PISUMMARY_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PATCH_ID |
FND_IMP_PISUMMARY_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SNAPSHOT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUG_NO | NUMBER | BUG_NO | ||
SNAPSHOT_ID | NUMBER | SNAPSHOT_ID | ||
NEW | NUMBER | NEW | ||
UPGRADE | NUMBER | UPGRADE | ||
OVERWRITE | NUMBER | OVERWRITE | ||
NOT_APPLIED | NUMBER | NOT_APPLIED | ||
INSTALL_CNT | NUMBER | INSTALL_CNT | ||
FILES_CNT | NUMBER | FILES_CNT | ||
AFFECTED | NUMBER | AFFECTED | ||
APP_CNT | NUMBER | APP_CNT | ||
RESP_CNT | NUMBER | RESP_CNT | ||
PATH_CNT | NUMBER | PATH_CNT | ||
IS_FLAGGED_FILE | VARCHAR2 | (1) | Indicates if file is flagged | |
PATCH_ID | NUMBER | Generated number to uniquely indentify (bug_no, baseline) combination |
Cut, paste (and edit) the following text to query this object:
SELECT BUG_NO
, SNAPSHOT_ID
, NEW
, UPGRADE
, OVERWRITE
, NOT_APPLIED
, INSTALL_CNT
, FILES_CNT
, AFFECTED
, APP_CNT
, RESP_CNT
, PATH_CNT
, IS_FLAGGED_FILE
, PATCH_ID
FROM APPLSYS.FND_IMP_PISUMMARY;
APPLSYS.FND_IMP_PISUMMARY does not reference any database object
APPLSYS.FND_IMP_PISUMMARY is referenced by following:
|
|
|