APPS.GMI_GMILTGEN_XMLP_PKG dependencies on GMD_SAMPLES

Line 701: from gmd_results a, gmd_spec_results b, gmd_samples c

697: function M_6FormatTrigger(item_id number, lot_id number) return varchar2 is
698: n number;
699: begin
700: select count(*) into n
701: from gmd_results a, gmd_spec_results b, gmd_samples c
702: where nvl(b.evaluation_ind,'N') in ('0A','1V')
703: and a.result_id = b.result_id
704: and a.sample_id = c.sample_id
705: and a.sample_id not in (select sample_id from gmd_samples where

Line 705: and a.sample_id not in (select sample_id from gmd_samples where

701: from gmd_results a, gmd_spec_results b, gmd_samples c
702: where nvl(b.evaluation_ind,'N') in ('0A','1V')
703: and a.result_id = b.result_id
704: and a.sample_id = c.sample_id
705: and a.sample_id not in (select sample_id from gmd_samples where
706: (supplier_id is not null or cust_id is not null) or
707: (batch_id is not null or formula_id is not null or
708: routing_id is not null or oprn_id is not null))
709: and a.delete_mark = 0