APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AS_SALES_LEAD_LINES

Line 2702: from as_sales_lead_lines LL, ams_act_products actprod

2698: and lead.primary_contact_party_id = csch_parties.contact_rel_party_id))
2699: and lead.creation_date between csch_parties.last_activation_date
2700: and csch_parties.last_activation_date + l_inferred_period
2701: AND exists (select 1
2702: from as_sales_lead_lines LL, ams_act_products actprod
2703: where ll.inventory_item_id = actprod.INVENTORY_ITEM_ID
2704: and ll.organization_id = actprod.organization_id
2705: and ll.sales_lead_id = lead.sales_lead_id
2706: and actprod.arc_act_product_used_by = 'CSCH'

Line 2817: from as_sales_lead_lines LL, ams_act_products actprod

2813: and lead.primary_contact_party_id = csch_parties.contact_rel_party_id))
2814: and lead.creation_date between csch_parties.last_activation_date
2815: and csch_parties.last_activation_date + l_inferred_period
2816: AND exists (select 1
2817: from as_sales_lead_lines LL, ams_act_products actprod
2818: where ll.inventory_item_id = actprod.INVENTORY_ITEM_ID
2819: and ll.organization_id = actprod.organization_id
2820: and ll.sales_lead_id = lead.sales_lead_id
2821: and actprod.arc_act_product_used_by = 'CSCH'

Line 3556: from as_sales_lead_lines LL, ams_act_products actprod

3552: and lead.creation_date between csch_parties.last_activation_date
3553: and csch_parties.last_activation_date + l_inferred_period
3554: -- and csch_parties.last_activation_date + 90
3555: AND exists (select 1
3556: from as_sales_lead_lines LL, ams_act_products actprod
3557: where ll.inventory_item_id = actprod.INVENTORY_ITEM_ID
3558: and ll.organization_id = actprod.organization_id
3559: and ll.sales_lead_id = lead.sales_lead_id
3560: and actprod.arc_act_product_used_by = 'CSCH'