DBA Data[Home] [Help]

APPS.XLA_VALIDATIONS_PKG dependencies on XLA_LOOKUPS

Line 105: , xla_lookups xlk

101: IS
102: SELECT fat.application_name, xpr.name, xlk.meaning product_rule_type_dsp
103: FROM xla_product_rules_tl xpr
104: , fnd_application_tl fat
105: , xla_lookups xlk
106: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
107: AND xlk.lookup_code = xpr.product_rule_type_code
108: AND fat.application_id = xpr.application_id
109: AND fat.language = USERENV('LANG')

Line 167: , xla_lookups xlk

163: IS
164: SELECT fat.application_name, xdt.name, xlk.meaning description_type_code_dsp
165: FROM xla_descriptions_tl xdt
166: , fnd_application_tl fat
167: , xla_lookups xlk
168: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
169: AND xlk.lookup_code = xdt.description_type_code
170: AND fat.application_id = xdt.application_id
171: AND fat.language = USERENV('LANG')

Line 229: , xla_lookups xlk

225: IS
226: SELECT fat.application_name, xsr.name, xlk.meaning segment_rule_type_dsp
227: FROM xla_seg_rules_tl xsr
228: , fnd_application_tl fat
229: , xla_lookups xlk
230: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
231: AND xlk.lookup_code = xsr.segment_rule_type_code
232: AND fat.application_id = xsr.application_id
233: AND fat.language = USERENV('LANG')

Line 294: , xla_lookups xlk

290: IS
291: SELECT fat.application_name, xal.name, xlk.meaning accounting_line_type_dsp
292: FROM xla_acct_line_types_tl xal
293: , fnd_application_tl fat
294: , xla_lookups xlk
295: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
296: AND xlk.lookup_code = xal.accounting_line_type_code
297: AND fat.application_id = xal.application_id
298: AND fat.language = USERENV('LANG')

Line 464: FROM xla_sources_tl s, xla_lookups l

460: --
461: CURSOR c_source
462: IS
463: SELECT s.name, l.meaning source_type
464: FROM xla_sources_tl s, xla_lookups l
465: WHERE s.application_id = p_application_id
466: AND s.source_type_code = p_source_type_code
467: AND s.source_code = p_source_code
468: AND s.language = USERENV('LANG')

Line 519: FROM xla_analytical_hdrs_vl s, xla_lookups l

515: --
516: CURSOR c_anc
517: IS
518: SELECT s.name, l.meaning analytical_criteria_type
519: FROM xla_analytical_hdrs_vl s, xla_lookups l
520: WHERE s.amb_context_code = p_amb_context_code
521: AND s.analytical_criterion_type_code = p_anal_criterion_type_code
522: AND s.analytical_criterion_code = p_analytical_criterion_code
523: AND s.analytical_criterion_type_code = l.lookup_code

Line 572: , xla_lookups xlk

568: CURSOR c_anc
569: IS
570: SELECT xam.name, xlk.meaning accounting_method_type
571: FROM xla_acctg_methods_tl xam
572: , xla_lookups xlk
573: WHERE xlk.lookup_type = 'XLA_OWNER_TYPE'
574: AND xlk.lookup_code = xam.accounting_method_type_code
575: AND xam.accounting_method_type_code = p_accounting_method_type_code
576: AND xam.accounting_method_code = p_accounting_method_code

Line 718: FROM xla_tab_acct_defs_vl p, fnd_application_vl a, xla_lookups l

714: --
715: CURSOR c_prod_rule
716: IS
717: SELECT a.application_name, p.name, l.meaning trx_acct_def_type
718: FROM xla_tab_acct_defs_vl p, fnd_application_vl a, xla_lookups l
719: WHERE p.application_id = p_application_id
720: AND p.amb_context_code = p_amb_context_code
721: AND p.account_definition_type_code = p_account_definition_type_code
722: AND p.account_definition_code = p_account_definition_code