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 6304: JOIN xla_line_defn_jlt_assgns b

6300: AND l.event_class_code = s.event_class_code
6301: AND l.event_type_code = s.event_type_code
6302: AND l.line_definition_owner_code = s.line_definition_owner_code
6303: AND l.line_definition_code = s.line_definition_code
6304: JOIN xla_line_defn_jlt_assgns b
6305: ON b.application_id = g_application_id
6306: AND b.amb_context_code = g_amb_context_code
6307: AND b.event_class_code = s.event_class_code
6308: AND b.event_type_code = s.event_type_code

Line 6482: , xla_line_defn_jlt_assgns b

6478: , s.analytical_criterion_type_code
6479: , s.analytical_criterion_code
6480: , C_MERGE_IMPACT_NEW merge_impact
6481: FROM xla_line_defn_ac_assgns s
6482: , xla_line_defn_jlt_assgns b
6483: WHERE s.application_id = g_application_id
6484: AND s.amb_context_code = g_staging_context_code
6485: AND b.application_id = g_application_id
6486: AND b.amb_context_code = g_amb_context_code

Line 6611: , xla_line_defn_jlt_assgns b

6607: , s.analytical_criterion_type_code
6608: , s.analytical_criterion_code
6609: , C_MERGE_IMPACT_NEW merge_impact
6610: FROM xla_mpa_header_ac_assgns s
6611: , xla_line_defn_jlt_assgns b
6612: WHERE s.application_id = g_application_id
6613: AND s.amb_context_code = g_staging_context_code
6614: AND b.application_id = g_application_id
6615: AND b.amb_context_code = g_amb_context_code

Line 6752: FROM xla_line_defn_jlt_assgns s

6748: , s.mpa_gl_dates_code s_mpa_gl_dates_code
6749: , w.mpa_gl_dates_code w_mpa_gl_dates_code
6750: , s.mpa_proration_code s_mpa_proration_code
6751: , w.mpa_proration_code w_mpa_proration_code
6752: FROM xla_line_defn_jlt_assgns s
6753: JOIN xla_line_defn_jlt_assgns w
6754: ON w.application_id = g_application_id
6755: AND w.amb_context_code = g_amb_context_code
6756: AND w.event_class_code = s.event_class_code

Line 6753: JOIN xla_line_defn_jlt_assgns w

6749: , w.mpa_gl_dates_code w_mpa_gl_dates_code
6750: , s.mpa_proration_code s_mpa_proration_code
6751: , w.mpa_proration_code w_mpa_proration_code
6752: FROM xla_line_defn_jlt_assgns s
6753: JOIN xla_line_defn_jlt_assgns w
6754: ON w.application_id = g_application_id
6755: AND w.amb_context_code = g_amb_context_code
6756: AND w.event_class_code = s.event_class_code
6757: AND w.event_type_code = s.event_type_code

Line 7299: JOIN xla_line_defn_jlt_assgns bw

7295: , w.description_type_code w_description_type_code
7296: , s.description_code s_description_code
7297: , w.description_code w_description_code
7298: FROM xla_mpa_jlt_assgns s
7299: JOIN xla_line_defn_jlt_assgns bw
7300: ON bw.application_id = g_application_id
7301: AND bw.amb_context_code = g_amb_context_code
7302: AND bw.event_class_code = s.event_class_code
7303: AND bw.event_type_code = s.event_type_code

Line 7336: JOIN xla_line_defn_jlt_assgns bs

7332: , w.mpa_accounting_line_code
7333: , C_MERGE_IMPACT_DELETED
7334: , NULL, NULL, NULL, NULL
7335: FROM xla_mpa_jlt_assgns w
7336: JOIN xla_line_defn_jlt_assgns bs
7337: ON bs.application_id = g_application_id
7338: AND bs.amb_context_code = g_staging_context_code
7339: AND bs.event_class_code = w.event_class_code
7340: AND bs.event_type_code = w.event_type_code

Line 7537: FROM xla_line_defn_jlt_assgns s

7533: , s.description_code s_description_code
7534: , w.description_code w_description_code
7535: , s.inherit_desc_flag s_inherit_desc_flag
7536: , w.inherit_desc_flag w_inherit_desc_flag
7537: FROM xla_line_defn_jlt_assgns s
7538: JOIN xla_line_definitions_b b
7539: ON b.application_id = g_application_id
7540: AND b.amb_context_code = g_amb_context_code
7541: AND b.event_class_code = s.event_class_code

Line 7545: LEFT OUTER JOIN xla_line_defn_jlt_assgns w

7541: AND b.event_class_code = s.event_class_code
7542: AND b.event_type_code = s.event_type_code
7543: AND b.line_definition_owner_code = s.line_definition_owner_code
7544: AND b.line_definition_code = s.line_definition_code
7545: LEFT OUTER JOIN xla_line_defn_jlt_assgns w
7546: ON w.application_id = g_application_id
7547: AND w.amb_context_code = g_amb_context_code
7548: AND w.event_class_code = s.event_class_code
7549: AND w.event_type_code = s.event_type_code

Line 8702: ,xla_line_defn_jlt_assgns xjl

8698: AND grp.group_num = l_curr_group_num
8699: UNION
8700: SELECT 1
8701: FROM xla_aad_line_defn_assgns xal
8702: ,xla_line_defn_jlt_assgns xjl
8703: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8704: WHERE xjl.application_id = g_application_id
8705: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8706: AND xjl.description_type_code = h.description_type_code

Line 8719: FROM xla_line_defn_jlt_assgns h

8715: AND xal.line_definition_code = xjl.line_definition_code
8716: AND grp.group_num = l_curr_group_num)
8717: UNION
8718: SELECT xal.product_rule_type_code, xal.product_rule_code
8719: FROM xla_line_defn_jlt_assgns h
8720: ,xla_aad_line_defn_assgns xal
8721: WHERE h.application_id = xal.application_id
8722: AND h.amb_context_code = xal.amb_context_code
8723: AND h.event_class_code = xal.event_class_code

Line 8742: ,xla_line_defn_jlt_assgns xjl

8738: AND grp.group_num = l_curr_group_num
8739: UNION
8740: SELECT 1
8741: FROM xla_aad_line_defn_assgns xal
8742: ,xla_line_defn_jlt_assgns xjl
8743: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8744: WHERE xjl.application_id = g_application_id
8745: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8746: AND xjl.description_type_code = h.description_type_code

Line 8759: FROM xla_line_defn_jlt_assgns h

8755: AND xal.line_definition_code = xjl.line_definition_code
8756: AND grp.group_num = l_curr_group_num)
8757: UNION
8758: SELECT xal.product_rule_type_code, xal.product_rule_code
8759: FROM xla_line_defn_jlt_assgns h
8760: ,xla_aad_line_defn_assgns xal
8761: WHERE h.application_id = xal.application_id
8762: AND h.amb_context_code = xal.amb_context_code
8763: AND h.event_class_code = xal.event_class_code

Line 8771: ,xla_line_defn_jlt_assgns xjl

8767: AND h.application_id = g_application_id
8768: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8769: AND EXISTS (SELECT 1
8770: FROM xla_aad_line_defn_assgns xad
8771: ,xla_line_defn_jlt_assgns xjl
8772: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8773: WHERE xjl.application_id = g_application_id
8774: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8775: AND xjl.event_class_code = h.event_class_code