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.GMD_QM_E_STABILITY_STUDIES_V

Object Details

Object Name:	GMD_QM_E_STABILITY_STUDIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_QM_E_STABILITY_STUDIES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORGANIZATION_ID	NUMBER
SS_ID	NUMBER		Yes
SS_NO	VARCHAR2	(30)	Yes
MEANING	VARCHAR2	(80)	Yes
DESCRIPTION	VARCHAR2	(240)	Yes
ITEM_NO	VARCHAR2	(40)
ITEM_DESC1	VARCHAR2	(240)
ITEM_REVISION	VARCHAR2	(3)
OWNER	NUMBER		Yes
NOTIFICATION_LEAD_TIME	NUMBER	(5)
NOTIFICATION_LEAD_TIME_UNIT	VARCHAR2	(2)
TESTING_GRACE_PERIOD	NUMBER	(5)
TESTING_GRACE_PERIOD_UNIT	VARCHAR2	(2)
MATERIAL_SOURCES_CNT	NUMBER	(5)	Yes
STORAGE_CONDITIONS_CNT	NUMBER	(5)	Yes
PACKAGES_CNT	NUMBER	(5)	Yes
BASE_SPEC_ID	NUMBER		Yes
BASE_SPEC_NAME	VARCHAR2	(80)	Yes
BASE_SPEC_VERS	NUMBER	(10)	Yes
LAB_ORGANIZATION_ID	NUMBER
STORAGE_PLAN_ID	NUMBER		Yes
SCHEDULED_START_DATE	DATE
SCHEDULED_END_DATE	DATE
REVISED_START_DATE	DATE
REVISED_END_DATE	DATE
ACTUAL_START_DATE	DATE
ACTUAL_END_DATE	DATE
RECOMMENDED_SHELF_LIFE	NUMBER	(5)
RECOMMENDED_SHELF_LIFE_UNIT	VARCHAR2	(2)
STATUS	NUMBER	(5)	Yes
DELETE_MARK	NUMBER	(5)	Yes

Query Text

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


SELECT ORGANIZATION_ID
,      SS_ID
,      SS_NO
,      MEANING
,      DESCRIPTION
,      ITEM_NO
,      ITEM_DESC1
,      ITEM_REVISION
,      OWNER
,      NOTIFICATION_LEAD_TIME
,      NOTIFICATION_LEAD_TIME_UNIT
,      TESTING_GRACE_PERIOD
,      TESTING_GRACE_PERIOD_UNIT
,      MATERIAL_SOURCES_CNT
,      STORAGE_CONDITIONS_CNT
,      PACKAGES_CNT
,      BASE_SPEC_ID
,      BASE_SPEC_NAME
,      BASE_SPEC_VERS
,      LAB_ORGANIZATION_ID
,      STORAGE_PLAN_ID
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      REVISED_START_DATE
,      REVISED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      RECOMMENDED_SHELF_LIFE
,      RECOMMENDED_SHELF_LIFE_UNIT
,      STATUS
,      DELETE_MARK
FROM APPS.GMD_QM_E_STABILITY_STUDIES_V;

Dependencies

[top of page]

APPS.GMD_QM_E_STABILITY_STUDIES_V references the following:

APPS: GMD_QC_STATUS; GMD_SPECIFICATIONS; GMD_STABILITY_STUDIES; MTL_SYSTEM_ITEMS_KFV

APPS.GMD_QM_E_STABILITY_STUDIES_V is not referenced by any database object