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_AAD_LINE_DEFN_ASSGNS

Line 261: , xla_aad_line_defn_assgns xal

257: AND ac.amb_context_code = p_amb_context_code
258: AND ac.application_id = p_application_id) OR
259: EXISTS (SELECT 1
260: FROM xla_line_defn_ac_assgns ac
261: , xla_aad_line_defn_assgns xal
262: WHERE b.amb_context_code = ac.amb_context_code
263: AND b.analytical_criterion_type_code = ac.analytical_criterion_type_code
264: AND b.analytical_criterion_code = ac.analytical_criterion_code
265: AND ac.application_id = xal.application_id

Line 298: , xla_aad_line_defn_assgns xal

294: AND b.amb_context_code = p_amb_context_code
295: AND EXISTS (SELECT 1
296: FROM xla_seg_rule_details dtl
297: , xla_line_defn_adr_assgns adr
298: , xla_aad_line_defn_assgns xal
299: WHERE b.mapping_set_code = dtl.value_mapping_set_code
300: AND dtl.amb_context_code = adr.amb_context_code
301: AND dtl.application_id = adr.segment_rule_appl_id
302: AND dtl.segment_rule_type_code = adr.segment_rule_type_code

Line 526: , xla_aad_line_defn_assgns xal

522: AND b.amb_context_code = p_amb_context_code
523: AND EXISTS (SELECT 1
524: FROM xla_seg_rule_details dtl
525: , xla_line_defn_adr_assgns adr
526: , xla_aad_line_defn_assgns xal
527: WHERE b.mapping_set_code = dtl.value_mapping_set_code
528: AND dtl.amb_context_code = adr.amb_context_code
529: AND dtl.application_id = adr.segment_rule_appl_id
530: AND dtl.segment_rule_type_code = adr.segment_rule_type_code

Line 830: FROM xla_aad_line_defn_assgns xal

826: -- Cursor to return AADs that shares any common component with the AADs that
827: -- was assigned with the group l_curr_group_num
828: CURSOR c_aad_group IS
829: SELECT xal.product_rule_code
830: FROM xla_aad_line_defn_assgns xal
831: WHERE xal.application_id = p_application_id
832: AND xal.amb_context_code = p_amb_context_code
833: AND xal.product_rule_type_code = p_owner_type
834: AND EXISTS (SELECT 1

Line 835: FROM xla_aad_line_defn_assgns xal2

831: WHERE xal.application_id = p_application_id
832: AND xal.amb_context_code = p_amb_context_code
833: AND xal.product_rule_type_code = p_owner_type
834: AND EXISTS (SELECT 1
835: FROM xla_aad_line_defn_assgns xal2
836: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
837: WHERE xal2.application_id = xal.application_id
838: AND xal2.amb_context_code = xal.amb_context_code
839: AND xal2.event_class_code = xal.event_class_code

Line 864: FROM xla_aad_line_defn_assgns xal

860: AND pah.product_rule_code = grp.product_rule_code
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

Line 882: FROM xla_aad_line_defn_assgns xal

878: AND xal.line_definition_code = xjl.line_definition_code
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

Line 900: FROM xla_aad_line_defn_assgns xal

896: AND xal.line_definition_code = xjl.line_definition_code
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

Line 919: ,xla_aad_line_defn_assgns xal

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
923: AND h.event_type_code = xal.event_type_code

Line 941: FROM xla_aad_line_defn_assgns xad

937: AND pah.product_rule_code = grp.product_rule_code
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

Line 959: FROM xla_aad_line_defn_assgns xal

955: AND xad.line_definition_code = xjl.line_definition_code
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

Line 977: FROM xla_aad_line_defn_assgns xal

973: AND xal.line_definition_code = xjl.line_definition_code
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

Line 996: ,xla_aad_line_defn_assgns xal

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
1000: AND h.event_type_code = xal.event_type_code

Line 1018: FROM xla_aad_line_defn_assgns xad

1014: AND pah.product_rule_code = grp.product_rule_code
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

Line 1036: FROM xla_aad_line_defn_assgns xal

1032: AND xad.line_definition_code = xjl.line_definition_code
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

Line 1054: FROM xla_aad_line_defn_assgns xal

1050: AND xal.line_definition_code = xjl.line_definition_code
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

Line 1073: ,xla_aad_line_defn_assgns xal

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
1077: AND h.event_type_code = xal.event_type_code

Line 1095: FROM xla_aad_line_defn_assgns xad

1091: AND pah.product_rule_code = grp.product_rule_code
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

Line 1113: FROM xla_aad_line_defn_assgns xal

1109: AND xad.line_definition_code = xjl.line_definition_code
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

Line 1131: FROM xla_aad_line_defn_assgns xal

1127: AND xal.line_definition_code = xjl.line_definition_code
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

Line 1150: ,xla_aad_line_defn_assgns xal

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
1154: AND h.event_type_code = xal.event_type_code

Line 1161: FROM xla_aad_line_defn_assgns xad

1157: AND xal.application_id = p_application_id
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

Line 1180: FROM xla_aad_line_defn_assgns xad

1176: AND xad.product_rule_code = grp.product_rule_code
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

Line 1200: ,xla_aad_line_defn_assgns xal

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
1204: AND h.event_type_code = xal.event_type_code

Line 1211: FROM xla_aad_line_defn_assgns xad

1207: AND xal.application_id = p_application_id
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

Line 1230: FROM xla_aad_line_defn_assgns xad

1226: AND xad.product_rule_code = grp.product_rule_code
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

Line 1683: FROM xla_aad_line_defn_assgns l

1679: AND b.analytical_criterion_type_code = a.analytical_criterion_type_code
1680: AND b.analytical_criterion_code = a.analytical_criterion_code
1681: UNION
1682: SELECT 1
1683: FROM xla_aad_line_defn_assgns l
1684: , xla_line_defn_ac_assgns a
1685: WHERE l.application_id = p_application_id
1686: AND l.amb_context_code = p_amb_context_code
1687: AND a.application_id = l.application_id