[Home] [Help] [Dependency Information]
Object Name: | MSC_PDSONLY_TABLE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Data contained for PDS tables list lookup
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | Lookup type |
LOOKUP_CODE | VARCHAR2 | (30) | Yes | Lookup code |
MEANING | VARCHAR2 | (80) | Yes | TABLE NAME |
DESCRIPTION | VARCHAR2 | (240) | Table Description | |
UNNAMED_COL_5 | VARCHAR2 | (150) | Application ID | |
TABLE_NAME | VARCHAR2 | (150) | PDS TABLE NAME | |
PARTITION_TYPE | VARCHAR2 | (150) | PARTITION TYPE | |
INITIAL_EXTENT | VARCHAR2 | (150) | INITIAL EXTENT | |
NEXT_EXTENT | VARCHAR2 | (150) | NEXT EXTENT | |
PCT_INCREASE | VARCHAR2 | (150) | PCT Increase | |
PCT_FREE | VARCHAR2 | (150) | PCT Free | |
PCT_USED | VARCHAR2 | (150) | PCT Used | |
INSTANCE_ID_FLAG | VARCHAR2 | (150) | INSTANCE ID Flag |
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, UNNAMED_COL_5
, TABLE_NAME
, PARTITION_TYPE
, INITIAL_EXTENT
, NEXT_EXTENT
, PCT_INCREASE
, PCT_FREE
, PCT_USED
, INSTANCE_ID_FLAG
FROM APPS.MSC_PDSONLY_TABLE_V;
APPS.MSC_PDSONLY_TABLE_V is not referenced by any database object
|
|
|