DBA Data[Home] [Help]

APPS.GMO_VALIDATE_BATCH_GRP dependencies on QA_RESULTS_V

Line 273: from qa_results_v

269: close c_get_materials;
270:
271: -- Chenck for NCM
272: select count(*) into l_ncm_count
273: from qa_results_v
274: where PROCESS_BATCH_ID = p_entity_key
275: and NONCONFORMANCE_STATUS <> 'CLOSED';
276: IF l_ncm_count > 0 THEN
277: raise NCM_NOT_CLOSED;

Line 337: from qa_results_v

333: close c_get_step_materials;
334:
335: -- Chenck for NCM
336: select count(*) into l_ncm_count
337: from qa_results_v
338: where PROCESS_BATCHSTEP_ID = p_entity_key
339: and NONCONFORMANCE_STATUS <> 'CLOSED';
340: IF l_ncm_count > 0 THEN
341: raise NCM_NOT_CLOSED;