APPS.BIM_CAMPAIGN_FACTS dependencies on AS_SALES_LEADS

Line 84: FROM as_sales_leads a, as_sales_leads_log b

80:
81: FUNCTION ret_max_date(p_sales_lead_id in number) return date is
82: CURSOR get_max_date IS
83: SELECT max(b.creation_date)
84: FROM as_sales_leads a, as_sales_leads_log b
85: WHERE a.sales_lead_id = b.sales_lead_id
86: AND b.sales_lead_id = p_sales_lead_id ;
87:
88: l_date date;

Line 831: ,as_sales_leads X

827: ,0 targeted_customers
828: FROM
829: ams_campaigns_all_b A
830: ,ams_source_codes C
831: ,as_sales_leads X
832: ,as_statuses_b Y
833: WHERE
834: X.status_code = Y.status_code
835: AND A.campaign_id = C.source_code_for_id

Line 910: ,as_sales_leads D

906: ,0 targeted_customers
907: FROM
908: ams_campaigns_all_b A
909: ,ams_source_codes C
910: ,as_sales_leads D
911: ,as_sales_lead_opportunity D1
912: ,as_leads_all E
913: ,aso_quote_related_objects F
914: ,aso_quote_headers_all G

Line 1338: ,as_sales_leads X

1334: ,0 targeted_customers
1335: FROM
1336: ams_campaign_schedules_b A
1337: ,ams_source_codes C
1338: ,as_sales_leads X
1339: ,as_statuses_b Y
1340: WHERE
1341: A.schedule_id = C.source_code_for_id
1342: AND C.arc_source_code_for = 'CSCH'

Line 1417: ,as_sales_leads D

1413: ,0 targeted_customers
1414: FROM
1415: ams_campaign_schedules_b A
1416: ,ams_source_codes C
1417: ,as_sales_leads D
1418: ,as_sales_lead_opportunity D1
1419: ,as_leads_all E
1420: ,aso_quote_related_objects F
1421: ,aso_quote_headers_all G

Line 3042: ,as_sales_leads X

3038: ,0 targeted_customers
3039: FROM
3040: ams_campaigns_all_b A
3041: ,ams_source_codes C
3042: ,as_sales_leads X
3043: ,as_statuses_b Y
3044: WHERE
3045: X.status_code = Y.status_code
3046: AND A.campaign_id = C.source_code_for_id

Line 3121: ,as_sales_leads D

3117: ,0 targeted_customers
3118: FROM
3119: ams_campaigns_all_b A
3120: ,ams_source_codes C
3121: ,as_sales_leads D
3122: ,as_sales_lead_opportunity D1
3123: ,as_leads_all E
3124: ,aso_quote_related_objects F
3125: ,aso_quote_headers_all G

Line 3550: ,as_sales_leads X

3546: ,0 targeted_customers
3547: FROM
3548: ams_campaign_schedules_b A
3549: ,ams_source_codes C
3550: ,as_sales_leads X
3551: ,as_statuses_b Y
3552: WHERE
3553: A.schedule_id = C.source_code_for_id
3554: AND C.arc_source_code_for = 'CSCH'

Line 3629: ,as_sales_leads D

3625: ,0 targeted_customers
3626: FROM
3627: ams_campaign_schedules_b A
3628: ,ams_source_codes C
3629: ,as_sales_leads D
3630: ,as_sales_lead_opportunity D1
3631: ,as_leads_all E
3632: ,aso_quote_related_objects F
3633: ,aso_quote_headers_all G