[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT length(p_object_name)
INTO l_length
FROM dual;
SELECT substr(p_object_name,i,1)
INTO l_char
FROM dual;
SELECT fat.application_name, xpr.name, xlk.meaning product_rule_type_dsp
FROM xla_product_rules_tl xpr
, fnd_application_tl fat
, xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
AND xlk.lookup_code = xpr.product_rule_type_code
AND fat.application_id = xpr.application_id
AND fat.language = USERENV('LANG')
AND xpr.application_id = p_application_id
AND xpr.amb_context_code = p_amb_context_code
AND xpr.product_rule_type_code = p_product_rule_type_code
AND xpr.product_rule_code = p_product_rule_code
AND xpr.language = USERENV('LANG');
SELECT fat.application_name, xdt.name, xlk.meaning description_type_code_dsp
FROM xla_descriptions_tl xdt
, fnd_application_tl fat
, xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
AND xlk.lookup_code = xdt.description_type_code
AND fat.application_id = xdt.application_id
AND fat.language = USERENV('LANG')
AND xdt.application_id = p_application_id
AND xdt.amb_context_code = p_amb_context_code
AND xdt.description_type_code = p_description_type_code
AND xdt.description_code = p_description_code
AND xdt.language = USERENV('LANG');
SELECT fat.application_name, xsr.name, xlk.meaning segment_rule_type_dsp
FROM xla_seg_rules_tl xsr
, fnd_application_tl fat
, xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
AND xlk.lookup_code = xsr.segment_rule_type_code
AND fat.application_id = xsr.application_id
AND fat.language = USERENV('LANG')
AND xsr.application_id = p_application_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = p_segment_rule_type_code
AND xsr.segment_rule_code = p_segment_rule_code
AND xsr.language = USERENV('LANG');
SELECT fat.application_name, xal.name, xlk.meaning accounting_line_type_dsp
FROM xla_acct_line_types_tl xal
, fnd_application_tl fat
, xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
AND xlk.lookup_code = xal.accounting_line_type_code
AND fat.application_id = xal.application_id
AND fat.language = USERENV('LANG')
AND xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.entity_code = p_entity_code
AND xal.event_class_code = p_event_class_code
AND xal.accounting_line_type_code = p_accounting_line_type_code
AND xal.accounting_line_code = p_accounting_line_code
AND xal.language = USERENV('LANG');
SELECT name
FROM xla_event_classes_tl
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND language = USERENV('LANG');
SELECT name
FROM xla_event_types_tl
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND language = USERENV('LANG');
SELECT s.name, l.meaning source_type
FROM xla_sources_tl s, xla_lookups l
WHERE s.application_id = p_application_id
AND s.source_type_code = p_source_type_code
AND s.source_code = p_source_code
AND s.language = USERENV('LANG')
AND s.source_type_code = l.lookup_code
AND l.lookup_type = 'XLA_SOURCE_TYPE';
SELECT s.name, l.meaning analytical_criteria_type
FROM xla_analytical_hdrs_vl s, xla_lookups l
WHERE s.amb_context_code = p_amb_context_code
AND s.analytical_criterion_type_code = p_anal_criterion_type_code
AND s.analytical_criterion_code = p_analytical_criterion_code
AND s.analytical_criterion_type_code = l.lookup_code
AND l.lookup_type = 'XLA_OWNER_TYPE';
SELECT xam.name, xlk.meaning accounting_method_type
FROM xla_acctg_methods_tl xam
, xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
AND xlk.lookup_code = xam.accounting_method_type_code
AND xam.accounting_method_type_code = p_accounting_method_type_code
AND xam.accounting_method_code = p_accounting_method_code
AND xam.language = USERENV('LANG');
SELECT application_name
FROM fnd_application_tl
WHERE application_id = p_application_id
AND language = USERENV('LANG');
SELECT name
FROM gl_ledgers
WHERE ledger_id = p_ledger_id;
SELECT a.application_name, p.name, l.meaning trx_acct_def_type
FROM xla_tab_acct_defs_vl p, fnd_application_vl a, xla_lookups l
WHERE p.application_id = p_application_id
AND p.amb_context_code = p_amb_context_code
AND p.account_definition_type_code = p_account_definition_type_code
AND p.account_definition_code = p_account_definition_code
AND a.application_id = p_application_id
AND l.lookup_code = p_account_definition_type_code
AND l.lookup_type = 'XLA_OWNER_TYPE';
SELECT name
FROM xla_tab_acct_types_vl
WHERE application_id = p_application_id
AND account_type_code = p_account_type_code;
SELECT 'x'
FROM user_objects o
WHERE o.object_name = p_table_name;
SELECT 'x'
FROM xla_reference_objects_f_v
WHERE event_class_code = p_event_class_code
AND reference_object_name = p_table_name;
l_sql := 'SELECT 1 FROM '
|| p_trx_object_name
|| ','
|| p_ref_object_name
|| ' WHERE '
|| p_join_condition
|| ' AND 1 = 2';