[Home] [Help] [Dependency Information]
Object Name: | MSC_STAGING_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 Staging tables list lookup
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | Lookup Type |
LOOKUP_CODE | VARCHAR2 | (30) | Yes | Lookup Code |
TABLE_NAME | VARCHAR2 | (80) | Yes | Table Name |
DESCRIPTION | VARCHAR2 | (240) | Description | |
APPLICATION_ID | VARCHAR2 | (150) | Application ID | |
LOGGING_CLAUSE | VARCHAR2 | (150) | Logging Clause | |
DEG_OF_PARALL | VARCHAR2 | (150) | Degree of Parallelization | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, TABLE_NAME
, DESCRIPTION
, APPLICATION_ID
, LOGGING_CLAUSE
, DEG_OF_PARALL
, PARTITION_TYPE
, INITIAL_EXTENT
, NEXT_EXTENT
, PCT_INCREASE
, PCT_FREE
, PCT_USED
FROM APPS.MSC_STAGING_TABLE_V;
|
|
|