[Home] [Help]
100:
101: /* This cursor Will Pick up all sample details for a Stability Study Sample */
102: Cursor C2 (ss_id_in number) is
103: select a.ss_no, a.description, b.concatenated_segments, b.description, a.revision
104: from gmd_stability_studies a,
105: mtl_system_items_b_kfv b
106: where a.ss_id = ss_id_in
107: and b.inventory_item_id = a.inventory_item_id
108: and b.organization_id = a.organization_id;
110: Cursor C3 is
111: select source , c.ss_id
112: from gmd_sampling_events a,
113: gmd_ss_variants b,
114: gmd_stability_studies_b c,
115: gmd_ss_time_points d
116: where d.sampling_event_id = l_event_key
117: and d.variant_id = b.variant_id
118: and b.ss_id = c.ss_id