[Home] [Help] [Dependency Information]
Object Name: | AD_PATCH_HIST_SNAPS_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PATCH_RUN_ID | NUMBER | |||
BUG_ID | NUMBER | |||
ACTION_CODE | NUMBER | |||
FILE_ID | NUMBER | |||
APP_SHORT_NAME | VARCHAR2 | (50) | ||
FILENAME | VARCHAR2 | (250) | ||
FILE_VERSION_ID | NUMBER | |||
VERSION_SEGMENT1 | NUMBER | |||
VERSION_SEGMENT2 | NUMBER | |||
VERSION_SEGMENT3 | NUMBER | |||
VERSION_SEGMENT4 | NUMBER | |||
VERSION_SEGMENT5 | NUMBER | |||
VERSION_SEGMENT6 | NUMBER | |||
VERSION_SEGMENT7 | NUMBER | |||
VERSION_SEGMENT8 | NUMBER | |||
VERSION_SEGMENT9 | NUMBER | |||
VERSION_SEGMENT10 | NUMBER | |||
TRANSLATION_LEVEL | NUMBER | |||
CLIB_ARCH_FILE_ID | NUMBER | |||
DEST_FILE_ID | NUMBER | |||
FILE_TYPE_FLAG | VARCHAR2 | (1) | ||
IREP_GATHERED_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PATCH_RUN_ID
, BUG_ID
, ACTION_CODE
, FILE_ID
, APP_SHORT_NAME
, FILENAME
, FILE_VERSION_ID
, VERSION_SEGMENT1
, VERSION_SEGMENT2
, VERSION_SEGMENT3
, VERSION_SEGMENT4
, VERSION_SEGMENT5
, VERSION_SEGMENT6
, VERSION_SEGMENT7
, VERSION_SEGMENT8
, VERSION_SEGMENT9
, VERSION_SEGMENT10
, TRANSLATION_LEVEL
, CLIB_ARCH_FILE_ID
, DEST_FILE_ID
, FILE_TYPE_FLAG
, IREP_GATHERED_FLAG
FROM APPLSYS.AD_PATCH_HIST_SNAPS_TEMP#;
|
|
|