[Home] [Help]
484: marketing_source_code_id
485: FROM aso_quote_headers_all G
486: WHERE G.marketing_source_code_id in (select c.source_code_id
487: from ams_act_metrics_all AL, ams_metrics_all_b ALB,
488: ams_source_codes c
489: where AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
490: AND AL.act_metric_used_by_id = C.source_code_for_id
491: AND AL.metric_id = ALB.metric_id
492: AND ALB.metric_id in (244,245,246,247,248,254,255,256,257,258)
497: where quote_number = g.quote_number)
498: GROUP BY marketing_source_code_id
499: ) quotes,
500: ams_act_metrics_all AL, ams_metrics_all_b ALB,
501: ams_source_codes c
502: where quotes.marketing_source_code_id(+) = c.source_code_id
503: AND AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
504: AND AL.act_metric_used_by_id = C.source_code_for_id
505: AND AL.metric_id = ALB.metric_id
593: X.status_code
594: FROM as_sales_leads X, as_statuses_b Y,
595: (select distinct c.source_code_id,
596: c.arc_source_code_for, c.source_code_for_id
597: FROM ams_source_codes C,
598: ams_metrics_all_b b, ams_act_metrics_all a
599: where a.metric_id = b.metric_id
600: AND c.arc_source_code_for = a.arc_act_metric_used_by
601: and c.source_code_for_id = a.act_metric_used_by_id
629: SELECT
630: COUNT(X.lead_id) actual_value, AL.activity_metric_id,
631: AL.func_actual_value
632: FROM
633: ams_source_codes C,
634: as_leads_all X,
635: ams_act_metrics_all AL, ams_metrics_all_b ALB
636: WHERE X.source_promotion_id(+) = C.source_code_id
637: AND AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
725: I.INVOICED_QUANTITY,
726: NVL(H.TRANSACTIONAL_CURR_CODE,G_FUNC_CURRENCY) CURRENCY_CODE
727: FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL I,
728: (SELECT DISTINCT ARC_SOURCE_CODE_FOR, SOURCE_CODE_FOR_ID, SOURCE_CODE_ID
729: FROM AMS_SOURCE_CODES C, AMS_ACT_METRICS_ALL A, AMS_METRICS_ALL_B B
730: WHERE A.ARC_ACT_METRIC_USED_BY = C.ARC_SOURCE_CODE_FOR
731: AND A.ACT_METRIC_USED_BY_ID = C.SOURCE_CODE_FOR_ID
732: AND A.METRIC_ID = B.METRIC_ID
733: AND DECODE(B.METRIC_CATEGORY,G_REVENUE_ID,
828: SELECT COUNT(distinct Z.party_id) actual_value,
829: AL.activity_metric_id, AL.func_actual_value
830: FROM
831: (select arc_source_code_for, source_code_for_id, party_id
832: from jtf_ih_interactions Z, ams_source_codes C,
833: ams_act_metrics_all a, ams_metrics_all_b b
834: where c.arc_source_code_for = a.arc_act_metric_used_by
835: AND c.source_code_for_id = a.act_metric_used_by_id
836: AND a.metric_id = b.metric_id
995: CURSOR c_get_source_code_id (p_object_type VARCHAR2,
996: p_object_id NUMBER) IS
997: select c.source_code_id
998: from ams_act_metrics_all AL, ams_metrics_all_b ALB,
999: ams_source_codes c
1000: where AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
1001: AND AL.act_metric_used_by_id = C.source_code_for_id
1002: AND AL.metric_id = ALB.metric_id
1003: AND ALB.metric_id in (244,245,246,247,248,254,255,256,257,258)
1046: where quote_number = g.quote_number)
1047: GROUP BY marketing_source_code_id
1048: ) quotes,
1049: ams_act_metrics_all AL, ams_metrics_all_b ALB,
1050: ams_source_codes c
1051: where quotes.marketing_source_code_id(+) = c.source_code_id
1052: AND AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
1053: AND AL.act_metric_used_by_id = C.source_code_for_id
1054: AND AL.metric_id = ALB.metric_id
1146: X.status_code
1147: FROM as_sales_leads X, as_statuses_b Y,
1148: (select distinct c.source_code_id,
1149: c.arc_source_code_for, c.source_code_for_id
1150: FROM ams_source_codes C,
1151: ams_metrics_all_b b, ams_act_metrics_all a
1152: where a.metric_id = b.metric_id
1153: AND c.arc_source_code_for = a.arc_act_metric_used_by
1154: and c.source_code_for_id = a.act_metric_used_by_id
1185: SELECT
1186: COUNT(X.lead_id) actual_value, AL.activity_metric_id,
1187: AL.func_actual_value
1188: FROM
1189: ams_source_codes C,
1190: as_leads_all X,
1191: ams_act_metrics_all AL, ams_metrics_all_b ALB
1192: WHERE X.source_promotion_id(+) = C.source_code_id
1193: AND AL.ARC_ACT_METRIC_USED_BY = C.arc_source_code_for
1286: decode(H.flow_status_code, G_BOOKED, I.ordered_quantity, 0) ordered_quantity,
1287: I.invoiced_quantity,
1288: nvl(H.transactional_curr_code,G_FUNC_CURRENCY) currency_code
1289: FROM oe_order_headers_all H, oe_order_lines_all I,
1290: ams_source_codes C
1291: WHERE H.header_id = I.header_id(+)
1292: AND H.booked_flag = G_BOOKED_FLAG
1293: AND H.booked_date IS NOT NULL
1294: AND H.marketing_source_code_id = C.source_code_id
1381: SELECT COUNT(DISTINCT C.party_id) actual_value,
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)
2009: 'B2B',REL.OBJECT_ID,null) PARTY_ID,
2010: SOURCE.SOURCE_CODE_ID, src.source_category
2011: FROM AMS_ACT_LISTS ACTLIST,
2012: AMS_LIST_ENTRIES ENTRY,
2013: AMS_SOURCE_CODES SOURCE,
2014: AMS_LIST_SRC_TYPES SRC,
2015: HZ_RELATIONSHIPS REL,
2016: AMS_METRICS_ALL_B B,
2017: AMS_ACT_METRICS_ALL A
2089: 'B2B',REL.OBJECT_ID,null) PARTY_ID,
2090: SOURCE.SOURCE_CODE_ID, src.source_category
2091: FROM AMS_ACT_LISTS ACTLIST,
2092: AMS_LIST_ENTRIES ENTRY,
2093: AMS_SOURCE_CODES SOURCE,
2094: AMS_LIST_SRC_TYPES SRC,
2095: HZ_RELATIONSHIPS REL,
2096: AMS_METRICS_ALL_B B,
2097: AMS_ACT_METRICS_ALL A
2162: 'B2B',REL.OBJECT_ID,null) PARTY_ID,
2163: SOURCE.SOURCE_CODE_ID, src.source_category
2164: FROM AMS_ACT_LISTS ACTLIST,
2165: AMS_LIST_ENTRIES ENTRY,
2166: AMS_SOURCE_CODES SOURCE,
2167: AMS_LIST_SRC_TYPES SRC,
2168: HZ_RELATIONSHIPS REL,
2169: AMS_METRICS_ALL_B B,
2170: AMS_ACT_METRICS_ALL A
2300: (select distinct source_code_for_id, arc_source_code_for,
2301: source_code_id, 'ALIST' object_type,
2302: ACTLIST.ACT_LIST_HEADER_ID object_id,
2303: ACTLIST.LIST_HEADER_ID
2304: from ams_source_codes source, AMS_ACT_LISTS ACTLIST,
2305: ams_metrics_all_b b, ams_act_metrics_all a
2306: where a.metric_id = b.metric_id
2307: AND b.metric_id in (336,341,346)
2308: AND b.enabled_flag = G_IS_ENABLED