APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_LOOKUPS

Line 4582: LEFT OUTER JOIN xla_lookups lk

4578: ,t.displayed_line_number
4579: ,t.entity_id
4580: ,t.accounting_class_code
4581: FROM xla_validation_lines_gt t
4582: LEFT OUTER JOIN xla_lookups lk
4583: ON lk.lookup_type = 'XLA_ACCOUNTING_CLASS'
4584: AND lk.lookup_code = t.accounting_class_code
4585: WHERE lk.lookup_code IS NULL
4586: AND t.accounting_class_code IS NOT NULL;

Line 6185: ,xla_lookups lk

6181: SELECT pr.name, lk.meaning, ec.name, et.name
6182: FROM xla_product_rules_tl pr
6183: ,xla_event_classes_tl ec
6184: ,xla_event_types_tl et
6185: ,xla_lookups lk
6186: ,xla_ae_headers h
6187: WHERE lk.lookup_code = h.product_rule_type_code
6188: AND lk.lookup_type = 'XLA_OWNER_TYPE'
6189: AND pr.amb_context_code = g_amb_context_code

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

9611: ,l.party_site_id
9612: ,'N' -- 4262811
9613: FROM xla_validation_lines_gt l
9614: ,gl_code_combinations ccid
9615: ,xla_lookups xl -- added line for bug 6902085
9616: WHERE l.balancing_line_type NOT IN (C_LINE_TYPE_PROCESS, C_LINE_TYPE_COMPLETE)
9617: AND ccid.code_combination_id(+) = l.code_combination_id
9618: AND xl.lookup_type = 'XLA_JE_VALD_LINE_DESC' -- added filter for bug 6902085
9619: AND xl.lookup_code = decode(l.balancing_line_type -- added filter for bug 6902085