APPS.AMS_ACTMETRICS_SEED_PVT dependencies on JTF_IH_RESULTS_B

Line 841: and exists (select 1 from jtf_ih_results_b Y

837: and b.metric_id in (168,169,165,166,167)
838: AND NVL(a.last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS
839: AND b.enabled_flag = G_IS_ENABLED
840: and z.source_code_id = c.source_code_id
841: and exists (select 1 from jtf_ih_results_b Y
842: where y.result_id = z.result_id
843: and rownum = 1
844: and positive_response_flag = G_POSITIVE_RESPONSE)
845: ) Z,

Line 1386: WHERE exists (select 1 from jtf_ih_results_b Y

1382: AL.activity_metric_id, AL.func_actual_value
1383: FROM
1384: (SELECT arc_source_code_for, source_code_for_id, party_id
1385: FROM jtf_ih_interactions Z, ams_source_codes C
1386: WHERE exists (select 1 from jtf_ih_results_b Y
1387: where z.result_id = y.result_id
1388: AND y.positive_response_flag = G_POSITIVE_RESPONSE
1389: and rownum = 1)
1390: AND Z.source_code_id = C.source_code_id

Line 2037: FROM JTF_IH_INTERACTIONS INTER, JTF_IH_RESULTS_B RESULT

2033: AND actlist.list_act_type = 'LIST'
2034: ) LIST_PARTIES
2035: -- CHECK EACH PARTY FOR A POSITIVE RESPONSE WITHIN THE SOURCE CODE.
2036: WHERE EXISTS (SELECT 1
2037: FROM JTF_IH_INTERACTIONS INTER, JTF_IH_RESULTS_B RESULT
2038: WHERE RESULT.POSITIVE_RESPONSE_FLAG = 'Y'
2039: AND RESULT.RESULT_ID = INTER.RESULT_ID
2040: AND INTER.SOURCE_CODE_ID = LIST_PARTIES.SOURCE_CODE_ID
2041: AND INTER.PARTY_ID = LIST_PARTIES.PARTY_ID

Line 2481: from jtf_ih_interactions inter, jtf_ih_results_b result

2477: AND REL.DIRECTIONAL_FLAG(+) = 'F'
2478: ) csch_parties
2479: -- Check each party for a positive response within active period.
2480: where exists (select /*+ use_concat */ 1
2481: from jtf_ih_interactions inter, jtf_ih_results_b result
2482: WHERE result.positive_response_flag = 'Y'
2483: AND result.result_id = inter.result_id
2484: and ((source_category = 'B2B'
2485: and inter.contact_rel_party_id = csch_parties.contact_rel_party_id

Line 2588: from jtf_ih_interactions inter, jtf_ih_results_b result

2584: AND REL.DIRECTIONAL_FLAG(+) = 'F'
2585: ) csch_parties
2586: -- Check each party for a positive response within active period.
2587: where exists (select /*+ use_concat */ 1
2588: from jtf_ih_interactions inter, jtf_ih_results_b result
2589: WHERE result.positive_response_flag = 'Y'
2590: AND result.result_id = inter.result_id
2591: and ((source_category = 'B2B'
2592: and inter.contact_rel_party_id = csch_parties.contact_rel_party_id

Line 3244: from jtf_ih_interactions inter, jtf_ih_results_b result

3240: FROM (
3241: select count(1) actual_value, ACTIVITY_METRIC_ID
3242: from AMS_INFMET_RESP_GT csch_parties
3243: where exists (select /*+ use_concat */ 1
3244: from jtf_ih_interactions inter, jtf_ih_results_b result
3245: WHERE result.positive_response_flag = 'Y'
3246: AND result.result_id = inter.result_id
3247: and ((source_category = 'B2B'
3248: and inter.contact_rel_party_id = csch_parties.contact_rel_party_id