78: from gmd_stability_studies a,
79: gmd_Qc_status b,
80: mtl_system_items_kfv c,
81: gmd_specifications d,
82: mtl_parameters e,
83: mtl_parameters f
84: where a.inventory_item_id = c.inventory_item_id
85: and a.organization_id = c.organization_id
86: and b.entity_type = 'STABILITY'
79: gmd_Qc_status b,
80: mtl_system_items_kfv c,
81: gmd_specifications d,
82: mtl_parameters e,
83: mtl_parameters f
84: where a.inventory_item_id = c.inventory_item_id
85: and a.organization_id = c.organization_id
86: and b.entity_type = 'STABILITY'
87: and b.status_code = a.status