The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
qc.char_id,
qc.name,
qp.prompt,
qc.data_entry_hint,
qc.datatype,
qc.display_length,
nvl(qp.decimal_precision,
nvl(qc.decimal_precision, 12)) decimal_precision,
qp.default_value,
decode(qp.values_exist_flag,
1, 1,
decode(qc.sql_validation_string, null, 2, 1)) lov_flag,
qp.mandatory_flag,
qp.displayed_flag,
qp.read_only_flag,
qa_mqa_plan_elements.get_spec_limit(
qc.char_id,
qc.datatype,
qscqs.char_id,
qc.uom_code,
qp.uom_code,
qscqs.uom_code,
qc.decimal_precision,
qp.decimal_precision,
qc.target_value,
qscqs.target_value) target_value,
qa_mqa_plan_elements.get_spec_limit(
qc.char_id,
qc.datatype,
qscqs.char_id,
qc.uom_code,
qp.uom_code,
qscqs.uom_code,
qc.decimal_precision,
qp.decimal_precision,
qc.upper_spec_limit,
qscqs.upper_spec_limit) upper_spec_limit,
qa_mqa_plan_elements.get_spec_limit(
qc.char_id,
qc.datatype,
qscqs.char_id,
qc.uom_code,
qp.uom_code,
qscqs.uom_code,
qc.decimal_precision,
qp.decimal_precision,
qc.lower_spec_limit,
qscqs.lower_spec_limit) lower_spec_limit,
qa_mqa_plan_elements.get_spec_limit(
qc.char_id,
qc.datatype,
qscqs.char_id,
qc.uom_code,
qp.uom_code,
qscqs.uom_code,
qc.decimal_precision,
qp.decimal_precision,
qc.upper_reasonable_limit,
qscqs.upper_reasonable_limit) upper_reasonable_limit,
qa_mqa_plan_elements.get_spec_limit(
qc.char_id,
qc.datatype,
qscqs.char_id,
qc.uom_code,
qp.uom_code,
qscqs.uom_code,
qc.decimal_precision,
qp.decimal_precision,
qc.lower_reasonable_limit,
qscqs.lower_reasonable_limit) lower_reasonable_limit,
qa_mqa_plan_elements.get_spec_limit(
qc.char_id,
qc.datatype,
qscqs.char_id,
qc.uom_code,
qp.uom_code,
qscqs.uom_code,
qc.decimal_precision,
qp.decimal_precision,
qc.upper_user_defined_limit,
qscqs.upper_user_defined_limit) upper_user_defined_limit,
qa_mqa_plan_elements.get_spec_limit(
qc.char_id,
qc.datatype,
qscqs.char_id,
qc.uom_code,
qp.uom_code,
qscqs.uom_code,
qc.decimal_precision,
qp.decimal_precision,
qc.lower_user_defined_limit,
qscqs.lower_user_defined_limit) lower_user_defined_limit
FROM
qa_chars qc,
qa_plan_chars qp,
(SELECT
qsc.CHAR_ID,
qsc.ENABLED_FLAG,
qsc.TARGET_VALUE,
qsc.UPPER_SPEC_LIMIT,
qsc.LOWER_SPEC_LIMIT,
qsc.UPPER_REASONABLE_LIMIT,
qsc.LOWER_REASONABLE_LIMIT,
qsc.UPPER_USER_DEFINED_LIMIT,
qsc.LOWER_USER_DEFINED_LIMIT,
qsc.UOM_CODE
FROM
qa_spec_chars qsc,
qa_specs qs
WHERE
qsc.spec_id = qs.common_spec_id AND
qs.spec_id = x_spec_id) QscQs
WHERE
qp.plan_id = x_plan_id AND
qp.enabled_flag = 1 AND
qc.char_id = qp.char_id AND
qc.char_id = QscQs.char_id (+)
ORDER BY qp.prompt_sequence;
SELECT plan_char_action_trigger_id
FROM qa_plan_char_action_triggers
WHERE plan_id = x_plan_id AND
char_id = x_char_id;
SELECT
null plan_char_action_trigger_id,
null plan_char_action_id,
null trigger_sequence,
null operator,
null low_value_lookup,
null high_value_lookup,
null low_value_other,
null high_value_other,
null action_id,
null message,
null assigned_char_id,
null assign_type,
null online_flag
FROM dual
WHERE 1 = 2;
SELECT
qpcat.plan_char_action_trigger_id,
qpca.plan_char_action_id,
qpcat.trigger_sequence,
qpcat.operator,
qpcat.low_value_lookup,
qpcat.high_value_lookup,
qpcat.low_value_other,
qpcat.high_value_other,
qpca.action_id,
qpca.message,
qpca.assigned_char_id,
qpca.assign_type,
1 online_flag
FROM
qa_plan_char_action_triggers qpcat,
qa_plan_char_actions qpca,
qa_actions qa
WHERE
qpcat.plan_id = x_plan_id AND
qpcat.char_id = x_char_id AND
qpcat.plan_char_action_trigger_id =
qpca.plan_char_action_trigger_id AND
qpca.action_id = qa.action_id AND
qa.online_flag = 1
UNION ALL
--
-- This select gets all the triggers with either no actions or only
-- deferred actions.
--
SELECT
qpcat.plan_char_action_trigger_id,
-1, -- no action in this part
qpcat.trigger_sequence,
qpcat.operator,
qpcat.low_value_lookup,
qpcat.high_value_lookup,
qpcat.low_value_other,
qpcat.high_value_other,
-1 action_id,
null, -- message, null in this case
-1, -- action details, -1 in this case
null, -- action details, null in this case
1 -- online flag, always 1 in this case
FROM
qa_plan_char_action_triggers qpcat
WHERE
qpcat.plan_id = x_plan_id AND
qpcat.char_id = x_char_id AND
NOT EXISTS
(SELECT
1
FROM
qa_plan_char_actions qpca,
qa_actions qa
WHERE
qpca.plan_char_action_trigger_id =
qpcat.plan_char_action_trigger_id AND
qpca.action_id = qa.action_id AND
qa.online_flag = 1)
ORDER BY 3, 1;
SELECT token_name, char_id
FROM qa_plan_char_action_outputs
WHERE plan_char_action_id = x_plan_char_action_id;
SELECT name INTO x_name
FROM qa_plans
WHERE plan_id = x_plan_id;
SELECT spec_assignment_type INTO x_type
FROM qa_plans
WHERE plan_id = p_plan_id;
SELECT meaning into x_spec_type_name
FROM mfg_lookups
WHERE lookup_type = 'QA_SPEC_TYPE'
AND lookup_code = x_type;