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_LINE_DEFN_JLT_ASSGNS

Line 865: ,xla_line_defn_jlt_assgns xjl

861: AND grp.group_num = l_curr_group_num
862: UNION
863: SELECT 1
864: FROM xla_aad_line_defn_assgns xal
865: ,xla_line_defn_jlt_assgns xjl
866: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
867: WHERE xjl.application_id = p_application_id
868: AND xjl.amb_context_code = p_amb_context_code
869: AND xjl.description_type_code = h.description_type_code

Line 883: ,xla_line_defn_jlt_assgns xjl

879: AND grp.group_num = l_curr_group_num
880: UNION
881: SELECT 1
882: FROM xla_aad_line_defn_assgns xal
883: ,xla_line_defn_jlt_assgns xjl
884: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
885: WHERE xjl.application_id = p_application_id
886: AND xjl.amb_context_code = p_amb_context_code
887: AND xjl.mpa_header_desc_type_code = h.description_type_code

Line 918: FROM xla_line_defn_jlt_assgns h -- line description

914: AND xal.line_definition_code = xjl.line_definition_code
915: AND grp.group_num = l_curr_group_num)
916: UNION
917: SELECT xal.product_rule_code
918: FROM xla_line_defn_jlt_assgns h -- line description
919: ,xla_aad_line_defn_assgns xal
920: WHERE h.application_id = xal.application_id
921: AND h.amb_context_code = xal.amb_context_code
922: AND h.event_class_code = xal.event_class_code

Line 942: ,xla_line_defn_jlt_assgns xjl

938: AND grp.group_num = l_curr_group_num
939: UNION
940: SELECT 1
941: FROM xla_aad_line_defn_assgns xad
942: ,xla_line_defn_jlt_assgns xjl
943: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
944: WHERE xjl.application_id = p_application_id
945: AND xjl.amb_context_code = p_amb_context_code
946: AND xjl.description_type_code = h.description_type_code

Line 960: ,xla_line_defn_jlt_assgns xjl

956: AND grp.group_num = l_curr_group_num
957: UNION
958: SELECT 1
959: FROM xla_aad_line_defn_assgns xal
960: ,xla_line_defn_jlt_assgns xjl
961: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
962: WHERE xjl.application_id = p_application_id
963: AND xjl.amb_context_code = p_amb_context_code
964: AND xjl.mpa_header_desc_type_code = h.description_type_code

Line 995: FROM xla_line_defn_jlt_assgns h -- MPA header description

991: AND xal.line_definition_code = xjl.line_definition_code
992: AND grp.group_num = l_curr_group_num)
993: UNION
994: SELECT xal.product_rule_code
995: FROM xla_line_defn_jlt_assgns h -- MPA header description
996: ,xla_aad_line_defn_assgns xal
997: WHERE h.application_id = xal.application_id
998: AND h.amb_context_code = xal.amb_context_code
999: AND h.event_class_code = xal.event_class_code

Line 1019: ,xla_line_defn_jlt_assgns xjl

1015: AND grp.group_num = l_curr_group_num
1016: UNION
1017: SELECT 1
1018: FROM xla_aad_line_defn_assgns xad
1019: ,xla_line_defn_jlt_assgns xjl
1020: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1021: WHERE xjl.application_id = p_application_id
1022: AND xjl.amb_context_code = p_amb_context_code
1023: AND xjl.description_type_code = h.mpa_header_desc_type_code

Line 1037: ,xla_line_defn_jlt_assgns xjl

1033: AND grp.group_num = l_curr_group_num
1034: UNION
1035: SELECT 1
1036: FROM xla_aad_line_defn_assgns xal
1037: ,xla_line_defn_jlt_assgns xjl
1038: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1039: WHERE xjl.application_id = p_application_id
1040: AND xjl.amb_context_code = p_amb_context_code
1041: AND xjl.mpa_header_desc_type_code = h.mpa_header_desc_type_code

Line 1096: ,xla_line_defn_jlt_assgns xjl

1092: AND grp.group_num = l_curr_group_num
1093: UNION
1094: SELECT 1
1095: FROM xla_aad_line_defn_assgns xad
1096: ,xla_line_defn_jlt_assgns xjl
1097: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1098: WHERE xjl.application_id = p_application_id
1099: AND xjl.amb_context_code = p_amb_context_code
1100: AND xjl.description_type_code = h.description_type_code

Line 1114: ,xla_line_defn_jlt_assgns xjl

1110: AND grp.group_num = l_curr_group_num
1111: UNION
1112: SELECT 1
1113: FROM xla_aad_line_defn_assgns xal
1114: ,xla_line_defn_jlt_assgns xjl
1115: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1116: WHERE xjl.application_id = p_application_id
1117: AND xjl.amb_context_code = p_amb_context_code
1118: AND xjl.mpa_header_desc_type_code = h.description_type_code

Line 1149: FROM xla_line_defn_jlt_assgns h -- JLT

1145: AND xal.line_definition_code = xjl.line_definition_code
1146: AND grp.group_num = l_curr_group_num)
1147: UNION
1148: SELECT xal.product_rule_code
1149: FROM xla_line_defn_jlt_assgns h -- JLT
1150: ,xla_aad_line_defn_assgns xal
1151: WHERE h.application_id = xal.application_id
1152: AND h.amb_context_code = xal.amb_context_code
1153: AND h.event_class_code = xal.event_class_code

Line 1162: ,xla_line_defn_jlt_assgns xjl

1158: AND xal.amb_context_code = p_amb_context_code
1159: AND xal.product_rule_type_code = p_owner_type
1160: AND EXISTS (SELECT 1
1161: FROM xla_aad_line_defn_assgns xad
1162: ,xla_line_defn_jlt_assgns xjl
1163: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1164: WHERE xjl.application_id = p_application_id
1165: AND xjl.amb_context_code = p_amb_context_code
1166: AND xjl.event_class_code = h.event_class_code

Line 1212: ,xla_line_defn_jlt_assgns xjl

1208: AND xal.amb_context_code = p_amb_context_code
1209: AND xal.product_rule_type_code = p_owner_type
1210: AND EXISTS (SELECT 1
1211: FROM xla_aad_line_defn_assgns xad
1212: ,xla_line_defn_jlt_assgns xjl
1213: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1214: WHERE xjl.application_id = p_application_id
1215: AND xjl.amb_context_code = p_amb_context_code
1216: AND xjl.event_class_code = h.event_class_code