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_AAD_LINE_DEFN_ASSGNS

Line 858: FROM xla_aad_line_defn_assgns w

854: IS
855: CURSOR c_assgns IS
856: SELECT w.product_rule_type_code
857: , w.product_rule_code
858: FROM xla_aad_line_defn_assgns w
859: , xla_aad_line_defn_assgns s
860: WHERE s.application_id = g_application_id
861: AND s.amb_context_code = g_staging_context_code
862: AND s.product_rule_type_code = w.product_rule_type_code

Line 859: , xla_aad_line_defn_assgns s

855: CURSOR c_assgns IS
856: SELECT w.product_rule_type_code
857: , w.product_rule_code
858: FROM xla_aad_line_defn_assgns w
859: , xla_aad_line_defn_assgns s
860: WHERE s.application_id = g_application_id
861: AND s.amb_context_code = g_staging_context_code
862: AND s.product_rule_type_code = w.product_rule_type_code
863: AND s.product_rule_code = w.product_rule_code

Line 1303: FROM xla_aad_line_defn_assgns w

1299: IS
1300: CURSOR c_assgns IS
1301: SELECT w.product_rule_type_code
1302: , w.product_rule_code
1303: FROM xla_aad_line_defn_assgns w
1304: LEFT OUTER JOIN xla_aad_line_defn_assgns s
1305: ON s.amb_context_code = g_staging_context_code
1306: AND s.application_id = g_application_id
1307: AND s.product_rule_type_code = w.product_rule_type_code

Line 1304: LEFT OUTER JOIN xla_aad_line_defn_assgns s

1300: CURSOR c_assgns IS
1301: SELECT w.product_rule_type_code
1302: , w.product_rule_code
1303: FROM xla_aad_line_defn_assgns w
1304: LEFT OUTER JOIN xla_aad_line_defn_assgns s
1305: ON s.amb_context_code = g_staging_context_code
1306: AND s.application_id = g_application_id
1307: AND s.product_rule_type_code = w.product_rule_type_code
1308: AND s.product_rule_code = w.product_rule_code

Line 4067: FROM xla_aad_line_defn_assgns w

4063: , w.event_class_code
4064: , w.event_type_code
4065: , w.line_definition_owner_code
4066: , w.line_definition_code
4067: FROM xla_aad_line_defn_assgns w
4068: , xla_prod_acct_headers b
4069: WHERE b.amb_context_code = g_staging_context_code
4070: AND b.application_id = g_application_id
4071: AND b.product_rule_type_code = w.product_rule_type_code

Line 4080: FROM xla_aad_line_defn_assgns s

4076: AND w.application_id = g_application_id
4077: AND w.line_definition_owner_code = C_OWNER_ORACLE
4078: AND NOT EXISTS
4079: (SELECT 1
4080: FROM xla_aad_line_defn_assgns s
4081: WHERE s.amb_context_code = g_staging_context_code
4082: AND s.application_id = g_application_id
4083: AND s.product_rule_type_code = w.product_rule_type_code
4084: AND s.product_rule_code = w.product_rule_code

Line 7883: FROM xla_aad_line_defn_assgns s

7879: , s.event_type_code
7880: , s.line_definition_owner_code
7881: , s.line_definition_code
7882: , C_MERGE_IMPACT_NEW merge_impact
7883: FROM xla_aad_line_defn_assgns s
7884: , xla_prod_acct_headers b
7885: WHERE s.application_id = g_application_id
7886: AND s.amb_context_code = g_staging_context_code
7887: AND b.application_id = g_application_id

Line 7895: FROM xla_aad_line_defn_assgns w

7891: AND b.event_class_code = s.event_class_code
7892: AND b.event_type_code = s.event_type_code
7893: AND NOT EXISTS
7894: (SELECT 1
7895: FROM xla_aad_line_defn_assgns w
7896: WHERE w.application_id = g_application_id
7897: AND w.amb_context_code = g_amb_context_code
7898: AND s.product_rule_type_code = w.product_rule_type_code
7899: AND s.product_rule_code = w.product_rule_code

Line 8701: FROM xla_aad_line_defn_assgns xal

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

Line 8720: ,xla_aad_line_defn_assgns xal

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

Line 8741: FROM xla_aad_line_defn_assgns xal

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

Line 8760: ,xla_aad_line_defn_assgns xal

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

Line 8770: FROM xla_aad_line_defn_assgns xad

8766: AND h.line_definition_code = xal.line_definition_code
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)

Line 8805: ,xla_aad_line_defn_assgns xal

8801: AND grp.group_num = l_curr_group_num
8802: UNION
8803: SELECT 1
8804: FROM xla_line_defn_ac_assgns xac
8805: ,xla_aad_line_defn_assgns xal
8806: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8807: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8808: AND xac.analytical_criterion_code = h.analytical_criterion_code
8809: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8823: ,xla_aad_line_defn_assgns xad

8819: AND grp.group_num = l_curr_group_num)
8820: UNION
8821: SELECT xad.product_rule_type_code, xad.product_rule_code
8822: FROM xla_line_defn_ac_assgns h
8823: ,xla_aad_line_defn_assgns xad
8824: WHERE h.application_id = xad.application_id
8825: AND h.amb_context_code = xad.amb_context_code
8826: AND h.event_class_code = xad.event_class_code
8827: AND h.event_type_code = xad.event_type_code

Line 8845: ,xla_aad_line_defn_assgns xal

8841: AND grp.group_num = l_curr_group_num
8842: UNION
8843: SELECT 1
8844: FROM xla_line_defn_ac_assgns xac
8845: ,xla_aad_line_defn_assgns xal
8846: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8847: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8848: AND xac.analytical_criterion_code = h.analytical_criterion_code
8849: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8863: ,xla_aad_line_defn_assgns xad

8859: AND grp.group_num = l_curr_group_num)
8860: UNION
8861: SELECT xad.product_rule_type_code, xad.product_rule_code
8862: FROM xla_line_defn_adr_assgns h
8863: ,xla_aad_line_defn_assgns xad
8864: WHERE h.application_id = xad.application_id
8865: AND h.amb_context_code = xad.amb_context_code
8866: AND h.event_class_code = xad.event_class_code
8867: AND h.event_type_code = xad.event_type_code

Line 8874: ,xla_aad_line_defn_assgns xal

8870: AND h.application_id = g_application_id
8871: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8872: AND EXISTS (SELECT 1
8873: FROM xla_line_defn_adr_assgns xac
8874: ,xla_aad_line_defn_assgns xal
8875: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8876: WHERE xac.application_id = g_application_id
8877: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8878: AND xac.segment_rule_type_code = h.segment_rule_type_code

Line 8892: ,xla_aad_line_defn_assgns xal

8888: AND grp.group_num = l_curr_group_num)
8889: UNION
8890: SELECT xal.product_rule_type_code, xal.product_rule_code
8891: FROM xla_line_defn_adr_assgns adr
8892: ,xla_aad_line_defn_assgns xal
8893: ,xla_seg_rule_details xsr
8894: WHERE xal.application_id = adr.application_id
8895: AND xal.amb_context_code = adr.amb_context_code
8896: AND xal.event_class_code = adr.event_class_code

Line 8908: ,xla_aad_line_defn_assgns xal2

8904: AND xsr.application_id = g_application_id
8905: AND xsr.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8906: AND EXISTS (SELECT 1
8907: FROM xla_line_defn_adr_assgns adr2
8908: ,xla_aad_line_defn_assgns xal2
8909: ,xla_seg_rule_details xsr2
8910: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8911: WHERE xsr2.value_mapping_set_code = xsr.value_mapping_set_code
8912: AND xsr2.application_id = adr2.application_id