APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_LINE_DEFINITIONS_B

Line 1835: , xla_line_definitions_b l

1831: , w.side_code
1832: , l.accounting_coa_id
1833: FROM xla_line_defn_adr_assgns w
1834: , xla_line_defn_adr_assgns s
1835: , xla_line_definitions_b l
1836: WHERE s.application_id = g_application_id
1837: AND s.amb_context_code = g_staging_context_code
1838: AND s.event_class_code = w.event_class_code
1839: AND s.event_type_code = w.event_type_code

Line 1872: , xla_line_definitions_b l

1868: , l.accounting_coa_id
1869: FROM xla_mpa_jlt_adr_assgns w
1870: , xla_mpa_jlt_adr_assgns s
1871: , xla_mpa_jlt_assgns j
1872: , xla_line_definitions_b l
1873: WHERE s.application_id = g_application_id
1874: AND s.amb_context_code = g_staging_context_code
1875: AND s.event_class_code = w.event_class_code
1876: AND s.event_type_code = w.event_type_code

Line 2006: JOIN xla_line_definitions_b l

2002: , w.flexfield_segment_code
2003: , w.side_code
2004: , l.accounting_coa_id
2005: FROM xla_line_defn_adr_assgns w
2006: JOIN xla_line_definitions_b l
2007: ON l.amb_context_code = g_amb_context_code
2008: AND l.application_id = g_application_id
2009: AND l.event_class_code = w.event_class_code
2010: AND l.event_type_code = w.event_type_code

Line 2044: JOIN xla_line_definitions_b l

2040: , w.flexfield_segment_code
2041: , NULL
2042: , l.accounting_coa_id
2043: FROM xla_mpa_jlt_adr_assgns w
2044: JOIN xla_line_definitions_b l
2045: ON l.amb_context_code = g_amb_context_code
2046: AND l.application_id = g_application_id
2047: AND l.event_class_code = w.event_class_code
2048: AND l.event_type_code = w.event_type_code

Line 4046: FROM xla_line_definitions_b w

4042: SELECT w.event_class_code
4043: , w.event_type_code
4044: , w.line_definition_owner_code
4045: , w.line_definition_code
4046: FROM xla_line_definitions_b w
4047: WHERE w.application_id = g_application_id
4048: AND w.amb_context_code = g_amb_context_code
4049: AND w.line_definition_owner_code = C_OWNER_ORACLE
4050: AND NOT EXISTS (

Line 4052: FROM xla_line_definitions_b s

4048: AND w.amb_context_code = g_amb_context_code
4049: AND w.line_definition_owner_code = C_OWNER_ORACLE
4050: AND NOT EXISTS (
4051: SELECT 1
4052: FROM xla_line_definitions_b s
4053: WHERE s.application_id = g_application_id
4054: AND s.amb_context_code = g_staging_context_code
4055: AND s.event_class_code = w.event_class_code
4056: AND s.event_type_code = w.event_type_code

Line 6305: JOIN xla_line_definitions_b l

6301: , w.segment_rule_code w_segment_rule_code
6302: , s.inherit_adr_flag s_inherit_adr_flag
6303: , w.inherit_adr_flag w_inherit_adr_flag
6304: FROM xla_line_defn_adr_assgns s
6305: JOIN xla_line_definitions_b l
6306: ON l.application_id = g_application_id
6307: AND l.amb_context_code = g_amb_context_code
6308: AND l.event_class_code = s.event_class_code
6309: AND l.event_type_code = s.event_type_code

Line 6965: JOIN xla_line_definitions_b l

6961: , w.segment_rule_code w_segment_rule_code
6962: , s.inherit_adr_flag s_inherit_adr_flag
6963: , w.inherit_adr_flag w_inherit_adr_flag
6964: FROM xla_mpa_jlt_adr_assgns s
6965: JOIN xla_line_definitions_b l
6966: ON l.application_id = g_application_id
6967: AND l.amb_context_code = g_amb_context_code
6968: AND l.event_class_code = s.event_class_code
6969: AND l.event_type_code = s.event_type_code

Line 7548: JOIN xla_line_definitions_b b

7544: , w.description_code w_description_code
7545: , s.inherit_desc_flag s_inherit_desc_flag
7546: , w.inherit_desc_flag w_inherit_desc_flag
7547: FROM xla_line_defn_jlt_assgns s
7548: JOIN xla_line_definitions_b b
7549: ON b.application_id = g_application_id
7550: AND b.amb_context_code = g_amb_context_code
7551: AND b.event_class_code = s.event_class_code
7552: AND b.event_type_code = s.event_type_code

Line 7726: FROM xla_line_definitions_b bs

7722: ,bs.transaction_coa_id s_trx_coa_id
7723: ,bw.transaction_coa_id w_trx_coa_id
7724: ,bs.budgetary_control_flag s_budgetary_control_flag
7725: ,bw.budgetary_control_flag w_budgetary_control_flag
7726: FROM xla_line_definitions_b bs
7727: JOIN xla_line_definitions_tl ts
7728: ON ts.application_id = bs.application_id
7729: AND ts.amb_context_code = bs.amb_context_code
7730: AND ts.event_class_code = bs.event_class_code

Line 7735: JOIN xla_line_definitions_b bw

7731: AND ts.event_type_code = bs.event_type_code
7732: AND ts.line_definition_owner_code = bs.line_definition_owner_code
7733: AND ts.line_definition_code = bs.line_definition_code
7734: AND ts.language = USERENV('LANG')
7735: JOIN xla_line_definitions_b bw
7736: ON bw.application_id = bs.application_id
7737: AND bw.amb_context_code = g_amb_context_code
7738: AND bw.event_class_code = bs.event_class_code
7739: AND bw.event_type_code = bs.event_type_code