[Home] [Help]
[Dependency Information]
VIEW: XTR.XTR_ARCHIVE_SETUP#
Object Details
Object Name: | XTR_ARCHIVE_SETUP# |
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ARCHIVE_FREQ_WEEKS |
NUMBER |
(3) |
Yes |
|
LAST_ARCHIVE_DATE |
DATE |
|
|
|
OLDER_THAN_MONTHS |
NUMBER |
(3) |
Yes |
|
TABLE_NAME |
VARCHAR2 |
(30) |
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ARCHIVE_FREQ_WEEKS
, LAST_ARCHIVE_DATE
, OLDER_THAN_MONTHS
, TABLE_NAME
FROM XTR.XTR_ARCHIVE_SETUP#;
Dependencies
[top of page]
XTR.XTR_ARCHIVE_SETUP# references the following:
-
XTR
-
XTR_ARCHIVE_SETUP
XTR.XTR_ARCHIVE_SETUP# is referenced by following:
-
APPS
-
XTR_ARCHIVE_SETUP