[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
-- fvq.id_flex_application_id,
-- fvq.id_flex_code,
-- fvq.segment_attribute_type,
-- fvq.value_attribute_type,
-- fvq.assignment_date,
vat.lookup_type,
vat.default_value
FROM fnd_flex_validation_qualifiers fvq,
fnd_value_attribute_types vat
WHERE fvq.flex_value_set_id = p_flex_value_set_id
AND fvq.id_flex_application_id = vat.application_id(+)
AND fvq.id_flex_code = vat.id_flex_code(+)
AND fvq.segment_attribute_type = vat.segment_attribute_type(+)
AND fvq.value_attribute_type = vat.value_attribute_type(+)
ORDER BY fvq.flex_value_set_id, fvq.assignment_date,
fvq.value_attribute_type;
SELECT Decode(Upper(p_mask_name),
'CANONICAL_DATE', m_canonical_date,
'CANONICAL_DATETIME', m_canonical_datetime,
'CANONICAL_TIME', m_canonical_time,
'CANONICAL_NUMERIC_CHARS', m_canonical_numeric_chars,
'DB_NUMERIC_CHARS', m_db_numeric_chars,
'NLS_DATE_IN', m_nls_date_in,
'NLS_DATE_OUT', m_nls_date_out,
'NLS_DATETIME_IN', m_nls_datetime_in,
'NLS_DATETIME_OUT', m_nls_datetime_out,
'NLS_TIME_IN', m_nls_time_in,
'NLS_TIME_OUT', m_nls_time_out,
'NLS_NUMERIC_CHARS_IN', m_nls_numeric_chars_in,
'NLS_NUMERIC_CHARS_OUT', m_nls_numeric_chars_out,
'FLEX_UNKNOWN_MASK')
INTO l_mask_value
FROM dual;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = p_lookup_type
AND lookup_code = p_lookup_code
AND ROWNUM = 1;