DBA Data[Home] [Help]

APPS.GMD_QUALITY_PARAMETERS_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

SELECT * FROM GMD_QUALITY_CONFIG
WHERE organization_id = p_orgn_id;
Line: 110

SELECT
  sample_last_assigned
FROM
  gmd_quality_config
WHERE
  organization_id = p_organization_id;
Line: 120

  UPDATE gmd_quality_config
  SET
    sample_last_assigned = sample_last_assigned + 1
  WHERE
    organization_id = p_organization_id;
Line: 168

SELECT
  ss_last_assigned
FROM
  gmd_quality_config
WHERE
  organization_id = p_organization_id;
Line: 178

  UPDATE gmd_quality_config
  SET
    ss_last_assigned = ss_last_assigned + 1
  WHERE
    organization_id = p_organization_id;
Line: 219

select organization_code
from mtl_parameters
where organization_id = p_organization_id;