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]

VIEW: APPS.MSC_PDSONLY_TABLE_V

Object Details

Object Name:	MSC_PDSONLY_TABLE_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Data contained for PDS tables list lookup

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.MSC_PDSONLY_TABLE_V references the following:

APPS: FND_LOOKUP_VALUES

APPS.MSC_PDSONLY_TABLE_V is not referenced by any database object