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 7893: FROM xla_aad_line_defn_assgns s

7889: , s.event_type_code
7890: , s.line_definition_owner_code
7891: , s.line_definition_code
7892: , C_MERGE_IMPACT_NEW merge_impact
7893: FROM xla_aad_line_defn_assgns s
7894: , xla_prod_acct_headers b
7895: WHERE s.application_id = g_application_id
7896: AND s.amb_context_code = g_staging_context_code
7897: AND b.application_id = g_application_id

Line 7905: FROM xla_aad_line_defn_assgns w

7901: AND b.event_class_code = s.event_class_code
7902: AND b.event_type_code = s.event_type_code
7903: AND NOT EXISTS
7904: (SELECT 1
7905: FROM xla_aad_line_defn_assgns w
7906: WHERE w.application_id = g_application_id
7907: AND w.amb_context_code = g_amb_context_code
7908: AND s.product_rule_type_code = w.product_rule_type_code
7909: AND s.product_rule_code = w.product_rule_code

Line 8711: FROM xla_aad_line_defn_assgns xal

8707: AND pah.product_rule_code = grp.product_rule_code
8708: AND grp.group_num = l_curr_group_num
8709: UNION
8710: SELECT 1
8711: FROM xla_aad_line_defn_assgns xal
8712: ,xla_line_defn_jlt_assgns xjl
8713: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8714: WHERE xjl.application_id = g_application_id
8715: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8730: ,xla_aad_line_defn_assgns xal

8726: AND grp.group_num = l_curr_group_num)
8727: UNION
8728: SELECT xal.product_rule_type_code, xal.product_rule_code
8729: FROM xla_line_defn_jlt_assgns h
8730: ,xla_aad_line_defn_assgns xal
8731: WHERE h.application_id = xal.application_id
8732: AND h.amb_context_code = xal.amb_context_code
8733: AND h.event_class_code = xal.event_class_code
8734: AND h.event_type_code = xal.event_type_code

Line 8751: FROM xla_aad_line_defn_assgns xal

8747: AND pah.product_rule_code = grp.product_rule_code
8748: AND grp.group_num = l_curr_group_num
8749: UNION
8750: SELECT 1
8751: FROM xla_aad_line_defn_assgns xal
8752: ,xla_line_defn_jlt_assgns xjl
8753: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8754: WHERE xjl.application_id = g_application_id
8755: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8770: ,xla_aad_line_defn_assgns xal

8766: AND grp.group_num = l_curr_group_num)
8767: UNION
8768: SELECT xal.product_rule_type_code, xal.product_rule_code
8769: FROM xla_line_defn_jlt_assgns h
8770: ,xla_aad_line_defn_assgns xal
8771: WHERE h.application_id = xal.application_id
8772: AND h.amb_context_code = xal.amb_context_code
8773: AND h.event_class_code = xal.event_class_code
8774: AND h.event_type_code = xal.event_type_code

Line 8780: FROM xla_aad_line_defn_assgns xad

8776: AND h.line_definition_code = xal.line_definition_code
8777: AND h.application_id = g_application_id
8778: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8779: AND EXISTS (SELECT 1
8780: FROM xla_aad_line_defn_assgns xad
8781: ,xla_line_defn_jlt_assgns xjl
8782: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8783: WHERE xjl.application_id = g_application_id
8784: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8815: ,xla_aad_line_defn_assgns xal

8811: AND grp.group_num = l_curr_group_num
8812: UNION
8813: SELECT 1
8814: FROM xla_line_defn_ac_assgns xac
8815: ,xla_aad_line_defn_assgns xal
8816: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8817: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8818: AND xac.analytical_criterion_code = h.analytical_criterion_code
8819: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8833: ,xla_aad_line_defn_assgns xad

8829: AND grp.group_num = l_curr_group_num)
8830: UNION
8831: SELECT xad.product_rule_type_code, xad.product_rule_code
8832: FROM xla_line_defn_ac_assgns h
8833: ,xla_aad_line_defn_assgns xad
8834: WHERE h.application_id = xad.application_id
8835: AND h.amb_context_code = xad.amb_context_code
8836: AND h.event_class_code = xad.event_class_code
8837: AND h.event_type_code = xad.event_type_code

Line 8855: ,xla_aad_line_defn_assgns xal

8851: AND grp.group_num = l_curr_group_num
8852: UNION
8853: SELECT 1
8854: FROM xla_line_defn_ac_assgns xac
8855: ,xla_aad_line_defn_assgns xal
8856: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8857: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8858: AND xac.analytical_criterion_code = h.analytical_criterion_code
8859: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8873: ,xla_aad_line_defn_assgns xad

8869: AND grp.group_num = l_curr_group_num)
8870: UNION
8871: SELECT xad.product_rule_type_code, xad.product_rule_code
8872: FROM xla_line_defn_adr_assgns h
8873: ,xla_aad_line_defn_assgns xad
8874: WHERE h.application_id = xad.application_id
8875: AND h.amb_context_code = xad.amb_context_code
8876: AND h.event_class_code = xad.event_class_code
8877: AND h.event_type_code = xad.event_type_code

Line 8884: ,xla_aad_line_defn_assgns xal

8880: AND h.application_id = g_application_id
8881: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8882: AND EXISTS (SELECT 1
8883: FROM xla_line_defn_adr_assgns xac
8884: ,xla_aad_line_defn_assgns xal
8885: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8886: WHERE xac.application_id = g_application_id
8887: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8888: AND xac.segment_rule_type_code = h.segment_rule_type_code

Line 8902: ,xla_aad_line_defn_assgns xal

8898: AND grp.group_num = l_curr_group_num)
8899: UNION
8900: SELECT xal.product_rule_type_code, xal.product_rule_code
8901: FROM xla_line_defn_adr_assgns adr
8902: ,xla_aad_line_defn_assgns xal
8903: ,xla_seg_rule_details xsr
8904: WHERE xal.application_id = adr.application_id
8905: AND xal.amb_context_code = adr.amb_context_code
8906: AND xal.event_class_code = adr.event_class_code

Line 8918: ,xla_aad_line_defn_assgns xal2

8914: AND xsr.application_id = g_application_id
8915: AND xsr.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8916: AND EXISTS (SELECT 1
8917: FROM xla_line_defn_adr_assgns adr2
8918: ,xla_aad_line_defn_assgns xal2
8919: ,xla_seg_rule_details xsr2
8920: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8921: WHERE xsr2.value_mapping_set_code = xsr.value_mapping_set_code
8922: AND xsr2.application_id = adr2.application_id