[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.GMD_QM_E_STABILITY_STUDIES_V is not referenced by any database object
|
|
|