APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AS_STATUSES_B

Line 594: FROM as_sales_leads X, as_statuses_b Y,

590: (SELECT c.arc_source_code_for, c.source_code_for_id,
591: x.sales_lead_id, x.lead_rank_score,
592: NVL(X.ACCEPT_FLAG,G_NOT_ACCEPTED) accepted_flag,
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

Line 1147: FROM as_sales_leads X, as_statuses_b Y,

1143: (SELECT c.arc_source_code_for, c.source_code_for_id,
1144: x.sales_lead_id, x.lead_rank_score,
1145: NVL(X.ACCEPT_FLAG,G_NOT_ACCEPTED) accepted_flag,
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

Line 2083: , as_statuses_b lead_status

2079: (
2080: SELECT lead.sales_lead_id,
2081: LIST_PARTIES.activity_metric_id
2082: FROM as_sales_leads lead
2083: , as_statuses_b lead_status
2084: , (
2085: -- SELECT DISTINCT LIST OF B2C AND B2B PARTIES
2086: SELECT distinct A.activity_metric_id,
2087: decode(src.source_category,

Line 2690: from as_sales_leads lead, as_statuses_b lead_status

2686: AND REL.PARTY_ID(+) = ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID
2687: AND REL.DIRECTIONAL_FLAG(+) = 'F'
2688: ) csch_parties
2689: where exists (select /*+ use_concat */1
2690: from as_sales_leads lead, as_statuses_b lead_status
2691: where lead.status_code = lead_status.status_code
2692: AND lead_status.lead_flag = 'Y'
2693: AND lead_status.enabled_flag = 'Y'
2694: AND NVL(lead.deleted_flag, 'N') <> 'Y'

Line 2805: from as_sales_leads lead, as_statuses_b lead_status

2801: AND REL.PARTY_ID(+) = ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID
2802: AND REL.DIRECTIONAL_FLAG(+) = 'F'
2803: ) csch_parties
2804: where exists (select /*+ use_concat */ 1
2805: from as_sales_leads lead, as_statuses_b lead_status
2806: where lead.status_code = lead_status.status_code
2807: AND lead_status.lead_flag = 'Y'
2808: AND lead_status.enabled_flag = 'Y'
2809: AND NVL(lead.deleted_flag, 'N') <> 'Y'

Line 3543: from as_sales_leads lead, as_statuses_b lead_status

3539: from (
3540: select count(1) actual_value, activity_metric_id
3541: from AMS_INFMET_LEAD_GT csch_parties
3542: where exists (select 1
3543: from as_sales_leads lead, as_statuses_b lead_status
3544: where lead.status_code = lead_status.status_code
3545: AND lead_status.lead_flag = 'Y'
3546: AND lead_status.enabled_flag = 'Y'
3547: AND NVL(lead.deleted_flag, 'N') <> 'Y'