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_PRODUCT_RULES_B

Line 3416: FROM xla_product_rules_b w

3412: IS
3413: CURSOR c_comp IS
3414: SELECT w.product_rule_type_code
3415: , w.product_rule_code
3416: FROM xla_product_rules_b w
3417: WHERE w.application_id = g_application_id
3418: AND w.amb_context_code = g_amb_context_code
3419: AND w.product_rule_type_code = C_OWNER_ORACLE
3420: AND NOT EXISTS (

Line 3422: FROM xla_product_rules_b s

3418: AND w.amb_context_code = g_amb_context_code
3419: AND w.product_rule_type_code = C_OWNER_ORACLE
3420: AND NOT EXISTS (
3421: SELECT 1
3422: FROM xla_product_rules_b s
3423: WHERE s.application_id = g_application_id
3424: AND s.amb_context_code = g_staging_context_code
3425: AND s.product_rule_type_code = w.product_rule_type_code
3426: AND s.product_rule_code = w.product_rule_code);

Line 3495: , xla_product_rules_b b

3491: , w.product_rule_code
3492: , w.event_class_code
3493: , w.event_type_code
3494: FROM xla_prod_acct_headers w
3495: , xla_product_rules_b b
3496: WHERE b.application_id = g_application_id
3497: AND b.amb_context_code = g_staging_context_code
3498: AND b.product_rule_type_code = w.product_rule_type_code
3499: AND b.product_rule_code = w.product_rule_code

Line 8244: JOIN xla_product_rules_b b

8240: , w.description_type_code w_description_type_code
8241: , s.description_code s_description_code
8242: , w.description_code w_description_code
8243: FROM xla_prod_acct_headers s
8244: JOIN xla_product_rules_b b
8245: ON b.application_id = g_application_id
8246: AND b.amb_context_code = g_amb_context_code
8247: AND b.product_rule_type_code = s.product_rule_type_code
8248: AND b.product_rule_code = s.product_rule_code

Line 8414: FROM xla_product_rules_b bs

8410: , bs.product_rule_version s_product_rule_version
8411: , bw.product_rule_version w_product_rule_version
8412: , bs.version_num s_version_num
8413: , bw.version_num w_version_num
8414: FROM xla_product_rules_b bs
8415: JOIN xla_product_rules_tl ts
8416: ON ts.application_id = bs.application_id
8417: AND ts.amb_context_code = bs.amb_context_code
8418: AND ts.product_rule_type_code = bs.product_rule_type_code

Line 8421: LEFT OUTER JOIN xla_product_rules_b bw

8417: AND ts.amb_context_code = bs.amb_context_code
8418: AND ts.product_rule_type_code = bs.product_rule_type_code
8419: AND ts.product_rule_code = bs.product_rule_code
8420: AND ts.language = USERENV('LANG')
8421: LEFT OUTER JOIN xla_product_rules_b bw
8422: ON bw.application_id = bs.application_id
8423: AND bw.amb_context_code = g_amb_context_code
8424: AND bw.product_rule_type_code = bs.product_rule_type_code
8425: AND bw.product_rule_code = bs.product_rule_code

Line 8677: FROM xla_product_rules_b

8673: CURSOR c_aad IS
8674: SELECT product_rule_type_code
8675: ,product_rule_code
8676: ,decode(min(decode(amb_context_code,g_amb_context_code,1,2)),1,'Y','N') required_flag
8677: FROM xla_product_rules_b
8678: WHERE application_id = g_application_id
8679: AND amb_context_code IN (g_amb_context_code,g_staging_context_code)
8680: GROUP BY product_rule_type_code, product_rule_code;
8681: