APPS.AMS_ACTMETRICS_SEED_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 485: FROM aso_quote_headers_all G

481: SELECT count(G.quote_header_id) quote_count,
482: sum(convert_currency(nvl(currency_code,G_FUNC_CURRENCY),
483: total_list_price + total_adjusted_amount)) quote_amount,
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

Line 496: and quote_version = (select max(quote_version) from aso_quote_headers_all

492: AND ALB.metric_id in (244,245,246,247,248,254,255,256,257,258)
493: AND ALB.enabled_flag = 'Y'
494: AND nvl(AL.last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS
495: )
496: and quote_version = (select max(quote_version) from aso_quote_headers_all
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,

Line 1042: FROM aso_quote_headers_all G

1038: SELECT count(G.quote_header_id) quote_count,
1039: sum(convert_currency(nvl(currency_code,G_FUNC_CURRENCY),
1040: total_list_price + total_adjusted_amount)) quote_amount,
1041: marketing_source_code_id
1042: FROM aso_quote_headers_all G
1043: WHERE G.marketing_source_code_id = l_source_code_id
1044: and quote_version = (select max(quote_version)
1045: from aso_quote_headers_all
1046: where quote_number = g.quote_number)

Line 1045: from aso_quote_headers_all

1041: marketing_source_code_id
1042: FROM aso_quote_headers_all G
1043: WHERE G.marketing_source_code_id = l_source_code_id
1044: and quote_version = (select max(quote_version)
1045: from aso_quote_headers_all
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,