VIEW: APPS.GMD_QM_E_STABILITY_STUDIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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