APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 1833: FROM xla_line_defn_adr_assgns w

1829: , NULL mpa_accounting_line_code
1830: , w.flexfield_segment_code
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

Line 1834: , xla_line_defn_adr_assgns s

1830: , w.flexfield_segment_code
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

Line 2005: FROM xla_line_defn_adr_assgns w

2001: , NULL mpa_accounting_line_code
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

Line 2013: LEFT OUTER JOIN xla_line_defn_adr_assgns s

2009: AND l.event_class_code = w.event_class_code
2010: AND l.event_type_code = w.event_type_code
2011: AND l.line_definition_owner_code = w.line_definition_owner_code
2012: AND l.line_definition_code = w.line_definition_code
2013: LEFT OUTER JOIN xla_line_defn_adr_assgns s
2014: ON s.amb_context_code = g_staging_context_code
2015: AND s.application_id = g_application_id
2016: AND s.event_class_code = w.event_class_code
2017: AND s.event_type_code = w.event_type_code

Line 6296: FROM xla_line_defn_adr_assgns s

6292: , s.segment_rule_code s_segment_rule_code
6293: , w.segment_rule_code w_segment_rule_code
6294: , s.inherit_adr_flag s_inherit_adr_flag
6295: , w.inherit_adr_flag w_inherit_adr_flag
6296: FROM xla_line_defn_adr_assgns s
6297: JOIN xla_line_definitions_b l
6298: ON l.application_id = g_application_id
6299: AND l.amb_context_code = g_amb_context_code
6300: AND l.event_class_code = s.event_class_code

Line 6313: LEFT OUTER JOIN xla_line_defn_adr_assgns w

6309: AND b.line_definition_owner_code = s.line_definition_owner_code
6310: AND b.line_definition_code = s.line_definition_code
6311: AND b.accounting_line_type_code = s.accounting_line_type_code
6312: AND b.accounting_line_code = s.accounting_line_code
6313: LEFT OUTER JOIN xla_line_defn_adr_assgns w
6314: ON w.application_id = g_application_id
6315: AND w.amb_context_code = g_amb_context_code
6316: AND w.event_class_code = s.event_class_code
6317: AND w.event_type_code = s.event_type_code

Line 8862: FROM xla_line_defn_adr_assgns h

8858: AND xal.product_rule_code = grp.product_rule_code
8859: AND grp.group_num = l_curr_group_num)
8860: UNION
8861: SELECT xad.product_rule_type_code, xad.product_rule_code
8862: FROM xla_line_defn_adr_assgns h
8863: ,xla_aad_line_defn_assgns xad
8864: WHERE h.application_id = xad.application_id
8865: AND h.amb_context_code = xad.amb_context_code
8866: AND h.event_class_code = xad.event_class_code

Line 8873: FROM xla_line_defn_adr_assgns xac

8869: AND h.line_definition_code = xad.line_definition_code
8870: AND h.application_id = g_application_id
8871: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8872: AND EXISTS (SELECT 1
8873: FROM xla_line_defn_adr_assgns xac
8874: ,xla_aad_line_defn_assgns xal
8875: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8876: WHERE xac.application_id = g_application_id
8877: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8891: FROM xla_line_defn_adr_assgns adr

8887: AND xal.product_rule_code = grp.product_rule_code
8888: AND grp.group_num = l_curr_group_num)
8889: UNION
8890: SELECT xal.product_rule_type_code, xal.product_rule_code
8891: FROM xla_line_defn_adr_assgns adr
8892: ,xla_aad_line_defn_assgns xal
8893: ,xla_seg_rule_details xsr
8894: WHERE xal.application_id = adr.application_id
8895: AND xal.amb_context_code = adr.amb_context_code

Line 8907: FROM xla_line_defn_adr_assgns adr2

8903: AND adr.segment_rule_code = xsr.segment_rule_code
8904: AND xsr.application_id = g_application_id
8905: AND xsr.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8906: AND EXISTS (SELECT 1
8907: FROM xla_line_defn_adr_assgns adr2
8908: ,xla_aad_line_defn_assgns xal2
8909: ,xla_seg_rule_details xsr2
8910: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8911: WHERE xsr2.value_mapping_set_code = xsr.value_mapping_set_code