DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_UMS_BUGFIXES

Object Details
Object Name: FND_UMS_BUGFIXES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_UMS_BUGFIXES
Subobject Name:
Status: VALID


This table stores information about bugfix definitions.
It is populated from ARU database.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_UMS_BUGFIXES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUGFIX_GUID
FND_UMS_BUGFIXES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUG_NUMBER
ColumnRELEASE_NAME
ColumnBASELINE
Columns
Name Datatype Length Mandatory Comments
BUGFIX_GUID RAW (16) Yes Bugfix GUID.
RELEASE_NAME VARCHAR2 (30) Yes Name of the release. (e.g., 11i)
BUG_NUMBER NUMBER
Yes Bug number.
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Application short name.
RELEASE_STATUS VARCHAR2 (30) Yes ARU release status.
TYPE VARCHAR2 (30) Yes Bugfix type (e.g., 'BUGFIX', 'PATCHSET')
ABSTRACT VARCHAR2 (240) Yes Description of the bugfix.
LAST_UPDATE_DATE DATE
Yes who column
DOWNLOAD_MODE VARCHAR2 (30) Yes Download mode
LAST_DEFINITION_DATE DATE
Yes LAST_DEFINITION_DATE
BASELINE VARCHAR2 (30)
Base line of the Bug Number
Query Text

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


SELECT BUGFIX_GUID
,      RELEASE_NAME
,      BUG_NUMBER
,      APPLICATION_SHORT_NAME
,      RELEASE_STATUS
,      TYPE
,      ABSTRACT
,      LAST_UPDATE_DATE
,      DOWNLOAD_MODE
,      LAST_DEFINITION_DATE
,      BASELINE
FROM APPLSYS.FND_UMS_BUGFIXES;

Dependencies

[top of page]

APPLSYS.FND_UMS_BUGFIXES does not reference any database object

APPLSYS.FND_UMS_BUGFIXES is referenced by following:

SchemaAPPS
SynonymFND_UMS_BUGFIXES