DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GMD_STORAGE_PLANS_VL

Object Details
Object Name: GMD_STORAGE_PLANS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMD.GMD_STORAGE_PLANS_VL
Subobject Name:
Status: VALID

View Type

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


Multi-Lingual View for GMD_STORAGE_PLANS


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database Row identifier
STORAGE_PLAN_ID NUMBER
Yes Unique plan identifier
STORAGE_PLAN_NAME VARCHAR2 (80) Yes Name of the plan
BASE_TEST_INTERVAL_PLAN_ID NUMBER
Yes Base plan id
TEXT_CODE NUMBER (10)
Text code for edit text
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Column for standard Flex Field
ATTRIBUTE1 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE2 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE3 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE4 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE5 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE6 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE7 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE8 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE9 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE10 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE11 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE12 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE13 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE14 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE15 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE16 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE17 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE18 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE19 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE20 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE21 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE22 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE23 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE24 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE25 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE26 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE27 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE28 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE29 VARCHAR2 (240)
Column for standard Flex Field
ATTRIBUTE30 VARCHAR2 (240)
Column for standard Flex Field
DELETE_MARK NUMBER (5) Yes Marked for deletion
CREATION_DATE DATE
Yes Standard Row Who column
CREATED_BY NUMBER (15) Yes Standard Row Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Row Who column
LAST_UPDATE_DATE DATE
Yes Standard Row Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Row Who column
DESCRIPTION VARCHAR2 (240) Yes Description of the plan
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      STORAGE_PLAN_ID
,      STORAGE_PLAN_NAME
,      BASE_TEST_INTERVAL_PLAN_ID
,      TEXT_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
FROM APPS.GMD_STORAGE_PLANS_VL;

Dependencies

[top of page]

APPS.GMD_STORAGE_PLANS_VL references the following:

SchemaAPPS
SynonymGMD_STORAGE_PLANS_B
SynonymGMD_STORAGE_PLANS_TL
APPS.GMD_STORAGE_PLANS_VL is referenced by following:

SchemaAPPS
SynonymGMD_STORAGE_PLANS