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: APPLSYS.AD_PREPMODE_CHECK_FILES

Object Details

Object Name:	AD_PREPMODE_CHECK_FILES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.AD_PREPMODE_CHECK_FILES
Subobject Name:
Status:	VALID

A "check-file" repository used in clone schema approach

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_PREPMODE_CHECK_FILES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APP_SHORT_NAME SUBDIR FILENAME DISTINGUISHER

Columns

Name	Datatype	Length	Mandatory	Comments
APP_SHORT_NAME	VARCHAR2	(50)	Yes	Short name of the product to which the file belongs to.
SUBDIR	VARCHAR2	(256)	Yes	Subdirectory in the product where the file exists.
FILENAME	VARCHAR2	(128)	Yes	Name of the file.
DISTINGUISHER	VARCHAR2	(80)	Yes	"Distinguisher" information as stated in the patch driver
VERSION	VARCHAR2	(150)		Version of the file
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
TRANSLATION_LEVEL	NUMBER			Translation level of the file.
VERSION_SEGMENT1	NUMBER			Version Segment 1 (eg. will hold 115 if the version is 115.10.2.4)
VERSION_SEGMENT2	NUMBER			Version Segment 2 (eg. will hold 10 if the version is 115.10.2.4)
VERSION_SEGMENT3	NUMBER			Version Segment3
VERSION_SEGMENT4	NUMBER			Version Segment4
VERSION_SEGMENT5	NUMBER			Version Segment5
VERSION_SEGMENT6	NUMBER			Version Segment6
VERSION_SEGMENT7	NUMBER			Version Segment7
VERSION_SEGMENT8	NUMBER			Version Segment8
VERSION_SEGMENT9	NUMBER			Version Segment9
VERSION_SEGMENT10	NUMBER			Version Segment10

Query Text

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


SELECT APP_SHORT_NAME
,      SUBDIR
,      FILENAME
,      DISTINGUISHER
,      VERSION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANSLATION_LEVEL
,      VERSION_SEGMENT1
,      VERSION_SEGMENT2
,      VERSION_SEGMENT3
,      VERSION_SEGMENT4
,      VERSION_SEGMENT5
,      VERSION_SEGMENT6
,      VERSION_SEGMENT7
,      VERSION_SEGMENT8
,      VERSION_SEGMENT9
,      VERSION_SEGMENT10
FROM APPLSYS.AD_PREPMODE_CHECK_FILES;

Dependencies

[top of page]

APPLSYS.AD_PREPMODE_CHECK_FILES does not reference any database object

APPLSYS.AD_PREPMODE_CHECK_FILES is referenced by following:

APPLSYS: AD_PREPMODE_CHECK_FILES#