DBA Data[Home] [Help]

APPS.BIM_CAMPAIGN_FACTS dependencies on JTF_IH_INTERACTIONS

Line 1079: ,jtf_ih_interactions X

1075: ,0 forecasted_responses
1076: ,count(Y.result_id) positive_responses
1077: ,0 targeted_customers
1078: FROM ams_campaigns_all_b A
1079: ,jtf_ih_interactions X
1080: ,jtf_ih_results_b Y
1081: WHERE
1082: A.source_code = X.source_code
1083: AND X.result_id = Y.result_id

Line 1586: ,jtf_ih_interactions X

1582: ,0 forecasted_responses
1583: ,sum(decode(A.use_parent_code_flag,'Y',0,1)) positive_responses
1584: ,0 targeted_customers
1585: FROM ams_campaign_schedules_b A
1586: ,jtf_ih_interactions X
1587: ,jtf_ih_results_b Y
1588: WHERE
1589: A.source_code = X.source_code
1590: AND X.result_id = Y.result_id

Line 3290: ,jtf_ih_interactions X

3286: ,0 forecasted_responses
3287: ,count(Y.result_id) positive_responses
3288: ,0 targeted_customers
3289: FROM ams_campaigns_all_b A
3290: ,jtf_ih_interactions X
3291: ,jtf_ih_results_b Y
3292: WHERE
3293: A.source_code = X.source_code
3294: AND X.result_id = Y.result_id

Line 3798: ,jtf_ih_interactions X

3794: ,0 forecasted_responses
3795: ,sum(decode(A.use_parent_code_flag,'Y',0,1)) positive_responses
3796: ,0 targeted_customers
3797: FROM ams_campaign_schedules_b A
3798: ,jtf_ih_interactions X
3799: ,jtf_ih_results_b Y
3800: WHERE
3801: A.source_code = X.source_code
3802: AND X.result_id = Y.result_id