APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_LOOKUPS

Line 4295: LEFT OUTER JOIN xla_lookups lk

4291: ,t.displayed_line_number
4292: ,t.entity_id
4293: ,t.accounting_class_code
4294: FROM xla_validation_lines_gt t
4295: LEFT OUTER JOIN xla_lookups lk
4296: ON lk.lookup_type = 'XLA_ACCOUNTING_CLASS'
4297: AND lk.lookup_code = t.accounting_class_code
4298: WHERE lk.lookup_code IS NULL
4299: AND t.accounting_class_code IS NOT NULL;

Line 5873: ,xla_lookups lk

5869: SELECT pr.name, lk.meaning, ec.name, et.name
5870: FROM xla_product_rules_tl pr
5871: ,xla_event_classes_tl ec
5872: ,xla_event_types_tl et
5873: ,xla_lookups lk
5874: ,xla_ae_headers h
5875: WHERE lk.lookup_code = h.product_rule_type_code
5876: AND lk.lookup_type = 'XLA_OWNER_TYPE'
5877: AND pr.amb_context_code = g_amb_context_code

Line 8934: ,xla_lookups xl -- added line for bug 6902085

8930: ,l.party_site_id
8931: ,'N' -- 4262811
8932: FROM xla_validation_lines_gt l
8933: ,gl_code_combinations ccid
8934: ,xla_lookups xl -- added line for bug 6902085
8935: WHERE l.balancing_line_type NOT IN (C_LINE_TYPE_PROCESS, C_LINE_TYPE_COMPLETE)
8936: AND ccid.code_combination_id(+) = l.code_combination_id
8937: AND xl.lookup_type = 'XLA_JE_VALD_LINE_DESC' -- added filter for bug 6902085
8938: AND xl.lookup_code = decode(l.balancing_line_type -- added filter for bug 6902085