Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMD_QM_E_STABILITY_STUDIES_V |
SELECT A.ORGANIZATION_ID
, A.SS_ID
, A.SS_NO
, B.MEANING
, A.DESCRIPTION
, C.CONCATENATED_SEGMENTS
, C.DESCRIPTION
, A.REVISION
, A.OWNER
, NOTIFICATION_LEAD_TIME
, NOTIFICATION_LEAD_TIME_UNIT
, TESTING_GRACE_PERIOD
, TESTING_GRACE_PERIOD_UNIT
, MATERIAL_SOURCES_CNT
, STORAGE_CONDITIONS_CNT
, PACKAGES_CNT
, A.BASE_SPEC_ID
, D.SPEC_NAME BASE_SPEC_NAME
, D.SPEC_VERS BASE_SPEC_VERS
, A.LAB_ORGANIZATION_ID
, A.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
, A.STATUS
, A.DELETE_MARK
FROM GMD_STABILITY_STUDIES A
, GMD_QC_STATUS B
, MTL_SYSTEM_ITEMS_KFV C
, GMD_SPECIFICATIONS D
WHERE A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
AND B.ENTITY_TYPE = 'STABILITY'
AND B.STATUS_CODE = A.STATUS
AND A.BASE_SPEC_ID = D.SPEC_ID