eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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 6304: FROM xla_line_defn_adr_assgns s

6300: , s.segment_rule_code s_segment_rule_code
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

Line 6321: LEFT OUTER JOIN xla_line_defn_adr_assgns w

6317: AND b.line_definition_owner_code = s.line_definition_owner_code
6318: AND b.line_definition_code = s.line_definition_code
6319: AND b.accounting_line_type_code = s.accounting_line_type_code
6320: AND b.accounting_line_code = s.accounting_line_code
6321: LEFT OUTER JOIN xla_line_defn_adr_assgns w
6322: ON w.application_id = g_application_id
6323: AND w.amb_context_code = g_amb_context_code
6324: AND w.event_class_code = s.event_class_code
6325: AND w.event_type_code = s.event_type_code

Line 8872: FROM xla_line_defn_adr_assgns h

8868: AND xal.product_rule_code = grp.product_rule_code
8869: AND grp.group_num = l_curr_group_num)
8870: UNION
8871: SELECT xad.product_rule_type_code, xad.product_rule_code
8872: FROM xla_line_defn_adr_assgns h
8873: ,xla_aad_line_defn_assgns xad
8874: WHERE h.application_id = xad.application_id
8875: AND h.amb_context_code = xad.amb_context_code
8876: AND h.event_class_code = xad.event_class_code

Line 8883: FROM xla_line_defn_adr_assgns xac

8879: AND h.line_definition_code = xad.line_definition_code
8880: AND h.application_id = g_application_id
8881: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8882: AND EXISTS (SELECT 1
8883: FROM xla_line_defn_adr_assgns xac
8884: ,xla_aad_line_defn_assgns xal
8885: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8886: WHERE xac.application_id = g_application_id
8887: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8901: FROM xla_line_defn_adr_assgns adr

8897: AND xal.product_rule_code = grp.product_rule_code
8898: AND grp.group_num = l_curr_group_num)
8899: UNION
8900: SELECT xal.product_rule_type_code, xal.product_rule_code
8901: FROM xla_line_defn_adr_assgns adr
8902: ,xla_aad_line_defn_assgns xal
8903: ,xla_seg_rule_details xsr
8904: WHERE xal.application_id = adr.application_id
8905: AND xal.amb_context_code = adr.amb_context_code

Line 8917: FROM xla_line_defn_adr_assgns adr2

8913: AND adr.segment_rule_code = xsr.segment_rule_code
8914: AND xsr.application_id = g_application_id
8915: AND xsr.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8916: AND EXISTS (SELECT 1
8917: FROM xla_line_defn_adr_assgns adr2
8918: ,xla_aad_line_defn_assgns xal2
8919: ,xla_seg_rule_details xsr2
8920: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8921: WHERE xsr2.value_mapping_set_code = xsr.value_mapping_set_code