[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gl_revaluations_s.NEXTVAL
FROM DUAL;
SELECT segment_num
FROM fnd_segment_attribute_values fsav, fnd_id_flex_segments fifs
WHERE fsav.application_id = 101
AND fsav.id_flex_code = 'GL#'
AND fsav.id_flex_num = l_coa_id
AND fsav.segment_attribute_type = l_segment
AND fsav.attribute_value = 'Y'
AND fsav.application_id = fifs.application_id
AND fsav.id_flex_code = fifs.id_flex_code
AND fsav.id_flex_num = fifs.id_flex_num
AND fsav.application_column_name = fifs.application_column_name;
SELECT flex_value_set_id
INTO l_flex_value_set_id
FROM fnd_id_flex_segments
WHERE application_id = 101
AND id_flex_code = 'GL#'
AND id_flex_num = l_coa_id
AND application_column_name = l_segment_name;
SELECT NVL(fvt.application_table_name, 'FND_FLEX_VALUES'),
NVL(fvt.summary_column_name, 'SUMMARY_FLAG')
INTO p_table,
p_col
FROM fnd_flex_validation_tables fvt, fnd_flex_value_sets fvs
WHERE fvs.flex_value_set_id = l_flex_value_set_id
AND fvt.flex_value_set_id(+) = fvs.flex_value_set_id;
SELECT summary_flag
INTO l_summary_flag
FROM fnd_flex_values
WHERE flex_value_set_id = l_flex_value_set_id
AND flex_value = account_num;
stmt := 'SELECT ' || p_col ||
' FROM ' || p_table ||
' WHERE flex_value_set_id = :flex_vs_id ' ||
' AND flex_value = :flex_val';
SELECT 'Overlapping'
FROM DUAL
WHERE EXISTS( SELECT 'X'
FROM gl_reval_account_ranges
WHERE revaluation_id = x_revaluation_id
AND ( x_row_id IS NULL
OR x_row_id <> ROWID)
AND NVL(segment30_low, 'X') <=
NVL(x_segment30_high, 'X')
AND NVL(segment30_high, 'X') >=
NVL(x_segment30_low, 'X')
AND NVL(segment29_low, 'X') <=
NVL(x_segment29_high, 'X')
AND NVL(segment29_high, 'X') >=
NVL(x_segment29_low, 'X')
AND NVL(segment28_low, 'X') <=
NVL(x_segment28_high, 'X')
AND NVL(segment28_high, 'X') >=
NVL(x_segment28_low, 'X')
AND NVL(segment27_low, 'X') <=
NVL(x_segment27_high, 'X')
AND NVL(segment27_high, 'X') >=
NVL(x_segment27_low, 'X')
AND NVL(segment26_low, 'X') <=
NVL(x_segment26_high, 'X')
AND NVL(segment26_high, 'X') >=
NVL(x_segment26_low, 'X')
AND NVL(segment25_low, 'X') <=
NVL(x_segment25_high, 'X')
AND NVL(segment25_high, 'X') >=
NVL(x_segment25_low, 'X')
AND NVL(segment24_low, 'X') <=
NVL(x_segment24_high, 'X')
AND NVL(segment24_high, 'X') >=
NVL(x_segment24_low, 'X')
AND NVL(segment23_low, 'X') <=
NVL(x_segment23_high, 'X')
AND NVL(segment23_high, 'X') >=
NVL(x_segment23_low, 'X')
AND NVL(segment22_low, 'X') <=
NVL(x_segment22_high, 'X')
AND NVL(segment22_high, 'X') >=
NVL(x_segment22_low, 'X')
AND NVL(segment21_low, 'X') <=
NVL(x_segment21_high, 'X')
AND NVL(segment21_high, 'X') >=
NVL(x_segment21_low, 'X')
AND NVL(segment20_low, 'X') <=
NVL(x_segment20_high, 'X')
AND NVL(segment20_high, 'X') >=
NVL(x_segment20_low, 'X')
AND NVL(segment19_low, 'X') <=
NVL(x_segment19_high, 'X')
AND NVL(segment19_high, 'X') >=
NVL(x_segment19_low, 'X')
AND NVL(segment18_low, 'X') <=
NVL(x_segment18_high, 'X')
AND NVL(segment18_high, 'X') >=
NVL(x_segment18_low, 'X')
AND NVL(segment17_low, 'X') <=
NVL(x_segment17_high, 'X')
AND NVL(segment17_high, 'X') >=
NVL(x_segment17_low, 'X')
AND NVL(segment16_low, 'X') <=
NVL(x_segment16_high, 'X')
AND NVL(segment16_high, 'X') >=
NVL(x_segment16_low, 'X')
AND NVL(segment15_low, 'X') <=
NVL(x_segment15_high, 'X')
AND NVL(segment15_high, 'X') >=
NVL(x_segment15_low, 'X')
AND NVL(segment14_low, 'X') <=
NVL(x_segment14_high, 'X')
AND NVL(segment14_high, 'X') >=
NVL(x_segment14_low, 'X')
AND NVL(segment13_low, 'X') <=
NVL(x_segment13_high, 'X')
AND NVL(segment13_high, 'X') >=
NVL(x_segment13_low, 'X')
AND NVL(segment12_low, 'X') <=
NVL(x_segment12_high, 'X')
AND NVL(segment12_high, 'X') >=
NVL(x_segment12_low, 'X')
AND NVL(segment11_low, 'X') <=
NVL(x_segment11_high, 'X')
AND NVL(segment11_high, 'X') >=
NVL(x_segment11_low, 'X')
AND NVL(segment10_low, 'X') <=
NVL(x_segment10_high, 'X')
AND NVL(segment10_high, 'X') >=
NVL(x_segment10_low, 'X')
AND NVL(segment9_low, 'X') <=
NVL(x_segment9_high, 'X')
AND NVL(segment9_high, 'X') >=
NVL(x_segment9_low, 'X')
AND NVL(segment8_low, 'X') <=
NVL(x_segment8_high, 'X')
AND NVL(segment8_high, 'X') >=
NVL(x_segment8_low, 'X')
AND NVL(segment7_low, 'X') <=
NVL(x_segment7_high, 'X')
AND NVL(segment7_high, 'X') >=
NVL(x_segment7_low, 'X')
AND NVL(segment6_low, 'X') <=
NVL(x_segment6_high, 'X')
AND NVL(segment6_high, 'X') >=
NVL(x_segment6_low, 'X')
AND NVL(segment5_low, 'X') <=
NVL(x_segment5_high, 'X')
AND NVL(segment5_high, 'X') >=
NVL(x_segment5_low, 'X')
AND NVL(segment4_low, 'X') <=
NVL(x_segment4_high, 'X')
AND NVL(segment4_high, 'X') >=
NVL(x_segment4_low, 'X')
AND NVL(segment3_low, 'X') <=
NVL(x_segment3_high, 'X')
AND NVL(segment3_high, 'X') >=
NVL(x_segment3_low, 'X')
AND NVL(segment2_low, 'X') <=
NVL(x_segment2_high, 'X')
AND NVL(segment2_high, 'X') >=
NVL(x_segment2_low, 'X')
AND NVL(segment1_low, 'X') <=
NVL(x_segment1_high, 'X')
AND NVL(segment1_high, 'X') >=
NVL(x_segment1_low, 'X'));
SELECT NAME
FROM gl_revaluations
WHERE name = revaluation_name
AND chart_of_accounts_id = c_id
AND revaluation_id <> r_id;
SELECT revaluation_id
FROM gl_reval_account_ranges
WHERE revaluation_id = r_id AND ROWNUM = 1;