[Home] [Help] [Dependency Information]
Object Name: | FND_IMP_PSMASTER2 |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_IMP_PSMASTER2 |
Subobject Name: | |
Status: | VALID |
FND_IMP_PSMASTER2
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_IMP_PSMASTER2_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SNAPSHOT_ID
PATCH_ID APP_SHORT_NAME FILENAME DIRECTORY FILE_TYPE TYPEID |
FND_IMP_PSMASTER2_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TYPEID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUG_NO | NUMBER | BUG_NO | ||
SNAPSHOT_ID | NUMBER | SNAPSHOT_ID | ||
APP_SHORT_NAME | VARCHAR2 | (50) | APP_SHORT_NAME | |
DIRECTORY | VARCHAR2 | (160) | DIRECTORY | |
FILENAME | VARCHAR2 | (90) | FILENAME | |
TYPEID | VARCHAR2 | (11) | TYPEID | |
NEW_VERSION | VARCHAR2 | (30) | NEW_VERSION | |
OLD_VERSION | VARCHAR2 | (150) | OLD_VERSION | |
FILES_AFFECTED | NUMBER | FILES_AFFECTED | ||
TYPE_AFFECTED | VARCHAR2 | (4) | TYPE_AFFECTED | |
FILE_TYPE | VARCHAR2 | (90) | FILE_TYPE | |
TRANS_NAME | VARCHAR2 | (313) | TRANS_NAME | |
IS_FLAGGED_FILE | VARCHAR2 | (1) | Indicates if file is flagged | |
BRANCH_TYPE | NUMBER | BRANCH_TYPE | ||
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
, APP_SHORT_NAME
, DIRECTORY
, FILENAME
, TYPEID
, NEW_VERSION
, OLD_VERSION
, FILES_AFFECTED
, TYPE_AFFECTED
, FILE_TYPE
, TRANS_NAME
, IS_FLAGGED_FILE
, BRANCH_TYPE
, PATCH_ID
FROM APPLSYS.FND_IMP_PSMASTER2;
APPLSYS.FND_IMP_PSMASTER2 does not reference any database object
APPLSYS.FND_IMP_PSMASTER2 is referenced by following:
|
|
|