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.

APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 1395: FROM xla_line_defn_jlt_assgns w

1391: , w.accounting_line_type_code
1392: , w.accounting_line_code
1393: , NULL mpa_accounting_line_type_code
1394: , NULL mpa_accounting_line_code
1395: FROM xla_line_defn_jlt_assgns w
1396: , xla_line_defn_jlt_assgns s
1397: WHERE s.application_id = g_application_id
1398: AND s.amb_context_code = g_staging_context_code
1399: AND s.event_class_code = w.event_class_code

Line 1396: , xla_line_defn_jlt_assgns s

1392: , w.accounting_line_code
1393: , NULL mpa_accounting_line_type_code
1394: , NULL mpa_accounting_line_code
1395: FROM xla_line_defn_jlt_assgns w
1396: , xla_line_defn_jlt_assgns s
1397: WHERE s.application_id = g_application_id
1398: AND s.amb_context_code = g_staging_context_code
1399: AND s.event_class_code = w.event_class_code
1400: AND s.event_type_code = w.event_type_code

Line 1590: FROM xla_line_defn_jlt_assgns w

1586: , w.accounting_line_type_code
1587: , w.accounting_line_code
1588: , NULL mpa_accounting_line_type_code
1589: , NULL mpa_accounting_line_code
1590: FROM xla_line_defn_jlt_assgns w
1591: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
1592: ON s.amb_context_code = g_staging_context_code
1593: AND s.application_id = g_application_id
1594: AND s.event_class_code = w.event_class_code

Line 1591: LEFT OUTER JOIN xla_line_defn_jlt_assgns s

1587: , w.accounting_line_code
1588: , NULL mpa_accounting_line_type_code
1589: , NULL mpa_accounting_line_code
1590: FROM xla_line_defn_jlt_assgns w
1591: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
1592: ON s.amb_context_code = g_staging_context_code
1593: AND s.application_id = g_application_id
1594: AND s.event_class_code = w.event_class_code
1595: AND s.event_type_code = w.event_type_code

Line 2484: FROM xla_line_defn_jlt_assgns w

2480: , w.accounting_line_type_code
2481: , w.accounting_line_code
2482: , NULL
2483: , NULL
2484: FROM xla_line_defn_jlt_assgns w
2485: , xla_line_defn_jlt_assgns s
2486: WHERE s.application_id = g_application_id
2487: AND s.amb_context_code = g_staging_context_code
2488: AND s.event_class_code = w.event_class_code

Line 2485: , xla_line_defn_jlt_assgns s

2481: , w.accounting_line_code
2482: , NULL
2483: , NULL
2484: FROM xla_line_defn_jlt_assgns w
2485: , xla_line_defn_jlt_assgns s
2486: WHERE s.application_id = g_application_id
2487: AND s.amb_context_code = g_staging_context_code
2488: AND s.event_class_code = w.event_class_code
2489: AND s.event_type_code = w.event_type_code

Line 2512: FROM xla_line_defn_jlt_assgns w

2508: , w.accounting_line_type_code
2509: , w.accounting_line_code
2510: , NULL
2511: , NULL
2512: FROM xla_line_defn_jlt_assgns w
2513: , xla_line_defn_jlt_assgns s
2514: WHERE s.application_id = g_application_id
2515: AND s.amb_context_code = g_staging_context_code
2516: AND s.event_class_code = w.event_class_code

Line 2513: , xla_line_defn_jlt_assgns s

2509: , w.accounting_line_code
2510: , NULL
2511: , NULL
2512: FROM xla_line_defn_jlt_assgns w
2513: , xla_line_defn_jlt_assgns s
2514: WHERE s.application_id = g_application_id
2515: AND s.amb_context_code = g_staging_context_code
2516: AND s.event_class_code = w.event_class_code
2517: AND s.event_type_code = w.event_type_code

Line 2669: FROM xla_line_defn_jlt_assgns w

2665: , w.accounting_line_type_code
2666: , w.accounting_line_code
2667: , NULL
2668: , NULL
2669: FROM xla_line_defn_jlt_assgns w
2670: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
2671: ON s.amb_context_code = g_staging_context_code
2672: AND s.application_id = g_application_id
2673: AND s.event_class_code = w.event_class_code

Line 2670: LEFT OUTER JOIN xla_line_defn_jlt_assgns s

2666: , w.accounting_line_code
2667: , NULL
2668: , NULL
2669: FROM xla_line_defn_jlt_assgns w
2670: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
2671: ON s.amb_context_code = g_staging_context_code
2672: AND s.application_id = g_application_id
2673: AND s.event_class_code = w.event_class_code
2674: AND s.event_type_code = w.event_type_code

Line 2697: FROM xla_line_defn_jlt_assgns w

2693: , w.accounting_line_type_code
2694: , w.accounting_line_code
2695: , NULL
2696: , NULL
2697: FROM xla_line_defn_jlt_assgns w
2698: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
2699: ON s.amb_context_code = g_staging_context_code
2700: AND s.application_id = g_application_id
2701: AND s.event_class_code = w.event_class_code

Line 2698: LEFT OUTER JOIN xla_line_defn_jlt_assgns s

2694: , w.accounting_line_code
2695: , NULL
2696: , NULL
2697: FROM xla_line_defn_jlt_assgns w
2698: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
2699: ON s.amb_context_code = g_staging_context_code
2700: AND s.application_id = g_application_id
2701: AND s.event_class_code = w.event_class_code
2702: AND s.event_type_code = w.event_type_code

Line 2923: , xla_line_defn_jlt_assgns b

2919: , w.accounting_line_code
2920: , NULL
2921: , NULL
2922: FROM xla_line_defn_ac_assgns w
2923: , xla_line_defn_jlt_assgns b
2924: WHERE b.amb_context_code = g_staging_context_code
2925: AND b.application_id = g_application_id
2926: AND b.event_class_code = w.event_class_code
2927: AND b.event_type_code = w.event_type_code

Line 2948: , xla_line_defn_jlt_assgns b

2944: , w.accounting_line_code
2945: , NULL
2946: , NULL
2947: FROM xla_mpa_header_ac_assgns w
2948: , xla_line_defn_jlt_assgns b
2949: WHERE b.amb_context_code = g_staging_context_code
2950: AND b.application_id = g_application_id
2951: AND b.event_class_code = w.event_class_code
2952: AND b.event_type_code = w.event_type_code

Line 3107: LEFT OUTER JOIN xla_line_defn_jlt_assgns s

3103: , w.accounting_line_code
3104: , NULL
3105: , NULL
3106: FROM xla_line_defn_ac_assgns w
3107: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
3108: ON s.amb_context_code = g_staging_context_code
3109: AND s.event_class_code = w.event_class_code
3110: AND s.event_type_code = w.event_type_code
3111: AND s.line_definition_owner_code = w.line_definition_owner_code

Line 3133: LEFT OUTER JOIN xla_line_defn_jlt_assgns s

3129: , w.accounting_line_code
3130: , NULL
3131: , NULL
3132: FROM xla_mpa_header_ac_assgns w
3133: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
3134: ON s.amb_context_code = g_staging_context_code
3135: AND s.event_class_code = w.event_class_code
3136: AND s.event_type_code = w.event_type_code
3137: AND s.line_definition_owner_code = w.line_definition_owner_code

Line 6312: JOIN xla_line_defn_jlt_assgns b

6308: AND l.event_class_code = s.event_class_code
6309: AND l.event_type_code = s.event_type_code
6310: AND l.line_definition_owner_code = s.line_definition_owner_code
6311: AND l.line_definition_code = s.line_definition_code
6312: JOIN xla_line_defn_jlt_assgns b
6313: ON b.application_id = g_application_id
6314: AND b.amb_context_code = g_amb_context_code
6315: AND b.event_class_code = s.event_class_code
6316: AND b.event_type_code = s.event_type_code

Line 6492: , xla_line_defn_jlt_assgns b

6488: , s.analytical_criterion_type_code
6489: , s.analytical_criterion_code
6490: , C_MERGE_IMPACT_NEW merge_impact
6491: FROM xla_line_defn_ac_assgns s
6492: , xla_line_defn_jlt_assgns b
6493: WHERE s.application_id = g_application_id
6494: AND s.amb_context_code = g_staging_context_code
6495: AND b.application_id = g_application_id
6496: AND b.amb_context_code = g_amb_context_code

Line 6621: , xla_line_defn_jlt_assgns b

6617: , s.analytical_criterion_type_code
6618: , s.analytical_criterion_code
6619: , C_MERGE_IMPACT_NEW merge_impact
6620: FROM xla_mpa_header_ac_assgns s
6621: , xla_line_defn_jlt_assgns b
6622: WHERE s.application_id = g_application_id
6623: AND s.amb_context_code = g_staging_context_code
6624: AND b.application_id = g_application_id
6625: AND b.amb_context_code = g_amb_context_code

Line 6762: FROM xla_line_defn_jlt_assgns s

6758: , s.mpa_gl_dates_code s_mpa_gl_dates_code
6759: , w.mpa_gl_dates_code w_mpa_gl_dates_code
6760: , s.mpa_proration_code s_mpa_proration_code
6761: , w.mpa_proration_code w_mpa_proration_code
6762: FROM xla_line_defn_jlt_assgns s
6763: JOIN xla_line_defn_jlt_assgns w
6764: ON w.application_id = g_application_id
6765: AND w.amb_context_code = g_amb_context_code
6766: AND w.event_class_code = s.event_class_code

Line 6763: JOIN xla_line_defn_jlt_assgns w

6759: , w.mpa_gl_dates_code w_mpa_gl_dates_code
6760: , s.mpa_proration_code s_mpa_proration_code
6761: , w.mpa_proration_code w_mpa_proration_code
6762: FROM xla_line_defn_jlt_assgns s
6763: JOIN xla_line_defn_jlt_assgns w
6764: ON w.application_id = g_application_id
6765: AND w.amb_context_code = g_amb_context_code
6766: AND w.event_class_code = s.event_class_code
6767: AND w.event_type_code = s.event_type_code

Line 7309: JOIN xla_line_defn_jlt_assgns bw

7305: , w.description_type_code w_description_type_code
7306: , s.description_code s_description_code
7307: , w.description_code w_description_code
7308: FROM xla_mpa_jlt_assgns s
7309: JOIN xla_line_defn_jlt_assgns bw
7310: ON bw.application_id = g_application_id
7311: AND bw.amb_context_code = g_amb_context_code
7312: AND bw.event_class_code = s.event_class_code
7313: AND bw.event_type_code = s.event_type_code

Line 7346: JOIN xla_line_defn_jlt_assgns bs

7342: , w.mpa_accounting_line_code
7343: , C_MERGE_IMPACT_DELETED
7344: , NULL, NULL, NULL, NULL
7345: FROM xla_mpa_jlt_assgns w
7346: JOIN xla_line_defn_jlt_assgns bs
7347: ON bs.application_id = g_application_id
7348: AND bs.amb_context_code = g_staging_context_code
7349: AND bs.event_class_code = w.event_class_code
7350: AND bs.event_type_code = w.event_type_code

Line 7547: FROM xla_line_defn_jlt_assgns s

7543: , s.description_code s_description_code
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

Line 7555: LEFT OUTER JOIN xla_line_defn_jlt_assgns w

7551: AND b.event_class_code = s.event_class_code
7552: AND b.event_type_code = s.event_type_code
7553: AND b.line_definition_owner_code = s.line_definition_owner_code
7554: AND b.line_definition_code = s.line_definition_code
7555: LEFT OUTER JOIN xla_line_defn_jlt_assgns w
7556: ON w.application_id = g_application_id
7557: AND w.amb_context_code = g_amb_context_code
7558: AND w.event_class_code = s.event_class_code
7559: AND w.event_type_code = s.event_type_code

Line 8712: ,xla_line_defn_jlt_assgns xjl

8708: AND grp.group_num = l_curr_group_num
8709: UNION
8710: SELECT 1
8711: FROM xla_aad_line_defn_assgns xal
8712: ,xla_line_defn_jlt_assgns xjl
8713: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8714: WHERE xjl.application_id = g_application_id
8715: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8716: AND xjl.description_type_code = h.description_type_code

Line 8729: FROM xla_line_defn_jlt_assgns h

8725: AND xal.line_definition_code = xjl.line_definition_code
8726: AND grp.group_num = l_curr_group_num)
8727: UNION
8728: SELECT xal.product_rule_type_code, xal.product_rule_code
8729: FROM xla_line_defn_jlt_assgns h
8730: ,xla_aad_line_defn_assgns xal
8731: WHERE h.application_id = xal.application_id
8732: AND h.amb_context_code = xal.amb_context_code
8733: AND h.event_class_code = xal.event_class_code

Line 8752: ,xla_line_defn_jlt_assgns xjl

8748: AND grp.group_num = l_curr_group_num
8749: UNION
8750: SELECT 1
8751: FROM xla_aad_line_defn_assgns xal
8752: ,xla_line_defn_jlt_assgns xjl
8753: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8754: WHERE xjl.application_id = g_application_id
8755: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8756: AND xjl.description_type_code = h.description_type_code

Line 8769: FROM xla_line_defn_jlt_assgns h

8765: AND xal.line_definition_code = xjl.line_definition_code
8766: AND grp.group_num = l_curr_group_num)
8767: UNION
8768: SELECT xal.product_rule_type_code, xal.product_rule_code
8769: FROM xla_line_defn_jlt_assgns h
8770: ,xla_aad_line_defn_assgns xal
8771: WHERE h.application_id = xal.application_id
8772: AND h.amb_context_code = xal.amb_context_code
8773: AND h.event_class_code = xal.event_class_code

Line 8781: ,xla_line_defn_jlt_assgns xjl

8777: AND h.application_id = g_application_id
8778: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8779: AND EXISTS (SELECT 1
8780: FROM xla_aad_line_defn_assgns xad
8781: ,xla_line_defn_jlt_assgns xjl
8782: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8783: WHERE xjl.application_id = g_application_id
8784: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8785: AND xjl.event_class_code = h.event_class_code