APPS.GMD_QMREJ dependencies on GMD_SAMPLING_EVENTS

Line 66: from gmd_sampling_events gse, mtl_parameters mp, gem_lookups glk

62:
63: /*Cursor to get the common fields in the workflow notification*/
64: CURSOR common_fields IS
65: select mp.organization_code, gse.sample_type, glk.meaning
66: from gmd_sampling_events gse, mtl_parameters mp, gem_lookups glk
67: where gse.sampling_event_id = l_event_key
68: and gse.organization_id = mp.organization_id
69: and glk.lookup_type = 'GMD_QC_SPEC_TYPE'
70: and gse.sample_type = glk.lookup_code;

Line 74: from gmd_sampling_events gse, gem_lookups glk

70: and gse.sample_type = glk.lookup_code;
71:
72: CURSOR common_fields1 IS
73: select glk.meaning
74: from gmd_sampling_events gse, gem_lookups glk
75: where gse.sampling_event_id = l_event_key
76: and glk.lookup_type = 'GMD_QC_SOURCE'
77: and gse.source = glk.lookup_code;
78:

Line 81: from gmd_sampling_events gse, gem_lookups glk

77: and gse.source = glk.lookup_code;
78:
79: CURSOR common_fields2 IS
80: select glk.meaning
81: from gmd_sampling_events gse, gem_lookups glk
82: where gse.sampling_event_id = l_event_key
83: and glk.lookup_type = 'GMD_QC_MONITOR_RULE_TYPE'
84: and gse.source = glk.lookup_code;
85:

Line 93: gmd_sampling_events gse

89: SELECT gse.resources, cr.resource_desc, ri.instance_number
90: from cr_rsrc_mst cr,
91: gmp_resource_instances ri,
92: cr_rsrc_dtl cd,
93: gmd_sampling_events gse
94: WHERE gse.sampling_event_id = l_event_key
95: and cr.resources = gse.resources
96: and cd.resources = cr.resources
97: and cd.organization_id = gse.organization_id

Line 112: from gmd_sampling_events a,

108: and b.organization_id = a.organization_id;
109:
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

Line 124: from gmd_sampling_events gse, mtl_item_locations_kfv mil

120:
121: /* This cursor Will Pick up all details for a Physical Location Sample */
122: cursor C4 is
123: select gse.subinventory, mil.concatenated_segments
124: from gmd_sampling_events gse, mtl_item_locations_kfv mil
125: WHERE sampling_event_id = l_event_key
126: and mil.inventory_location_id = gse.locator_id
127: and mil.organization_id = gse.organization_id;
128:

Line 131: from gmd_Sampling_Events

127: and mil.organization_id = gse.organization_id;
128:
129: Cursor C5 is
130: select source
131: from gmd_Sampling_Events
132: where sampling_event_id = l_event_key ;
133:
134: cursor get_from_role is
135: select nvl( text, '')