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_EXPORT_PVT dependencies on XLA_MPA_JLT_ASSGNS

Line 901: ,xla_mpa_jlt_assgns xjl

897: AND grp.group_num = l_curr_group_num
898: UNION
899: SELECT 1
900: FROM xla_aad_line_defn_assgns xal
901: ,xla_mpa_jlt_assgns xjl
902: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
903: WHERE xjl.application_id = p_application_id
904: AND xjl.amb_context_code = p_amb_context_code
905: AND xjl.description_type_code = h.description_type_code

Line 978: ,xla_mpa_jlt_assgns xjl

974: AND grp.group_num = l_curr_group_num
975: UNION
976: SELECT 1
977: FROM xla_aad_line_defn_assgns xal
978: ,xla_mpa_jlt_assgns xjl
979: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
980: WHERE xjl.application_id = p_application_id
981: AND xjl.amb_context_code = p_amb_context_code
982: AND xjl.description_type_code = h.description_type_code

Line 1055: ,xla_mpa_jlt_assgns xjl

1051: AND grp.group_num = l_curr_group_num
1052: UNION
1053: SELECT 1
1054: FROM xla_aad_line_defn_assgns xal
1055: ,xla_mpa_jlt_assgns xjl
1056: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1057: WHERE xjl.application_id = p_application_id
1058: AND xjl.amb_context_code = p_amb_context_code
1059: AND xjl.description_type_code = h.mpa_header_desc_type_code

Line 1072: FROM xla_mpa_jlt_assgns h -- MPA line description

1068: AND xal.line_definition_code = xjl.line_definition_code
1069: AND grp.group_num = l_curr_group_num)
1070: UNION
1071: SELECT xal.product_rule_code
1072: FROM xla_mpa_jlt_assgns h -- MPA line description
1073: ,xla_aad_line_defn_assgns xal
1074: WHERE h.application_id = xal.application_id
1075: AND h.amb_context_code = xal.amb_context_code
1076: AND h.event_class_code = xal.event_class_code

Line 1132: ,xla_mpa_jlt_assgns xjl

1128: AND grp.group_num = l_curr_group_num
1129: UNION
1130: SELECT 1
1131: FROM xla_aad_line_defn_assgns xal
1132: ,xla_mpa_jlt_assgns xjl
1133: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1134: WHERE xjl.application_id = p_application_id
1135: AND xjl.amb_context_code = p_amb_context_code
1136: AND xjl.description_type_code = h.description_type_code

Line 1181: ,xla_mpa_jlt_assgns xjl

1177: AND grp.group_num = l_curr_group_num
1178: UNION
1179: SELECT 1
1180: FROM xla_aad_line_defn_assgns xad
1181: ,xla_mpa_jlt_assgns xjl
1182: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1183: WHERE xjl.application_id = p_application_id
1184: AND xjl.amb_context_code = p_amb_context_code
1185: AND xjl.event_class_code = h.event_class_code

Line 1199: FROM xla_mpa_jlt_assgns h -- MPA JLT

1195: AND xad.product_rule_code = grp.product_rule_code
1196: AND grp.group_num = l_curr_group_num)
1197: UNION
1198: SELECT xal.product_rule_code
1199: FROM xla_mpa_jlt_assgns h -- MPA JLT
1200: ,xla_aad_line_defn_assgns xal
1201: WHERE h.application_id = xal.application_id
1202: AND h.amb_context_code = xal.amb_context_code
1203: AND h.event_class_code = xal.event_class_code

Line 1231: ,xla_mpa_jlt_assgns xjl

1227: AND grp.group_num = l_curr_group_num
1228: UNION
1229: SELECT 1
1230: FROM xla_aad_line_defn_assgns xad
1231: ,xla_mpa_jlt_assgns xjl
1232: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1233: WHERE xjl.application_id = p_application_id
1234: AND xjl.amb_context_code = p_amb_context_code
1235: AND xjl.event_class_code = h.event_class_code