APPS.BIM_CAMPAIGN_FACTS dependencies on AS_LEADS_ALL

Line 873: ,as_leads_all X

869: ,0 targeted_customers
870: FROM
871: ams_campaigns_all_b A
872: ,ams_source_codes C
873: ,as_leads_all X
874: WHERE
875: A.campaign_id = C.source_code_for_id
876: AND C.arc_source_code_for = 'CAMP'
877: AND A.source_code = C.source_code

Line 912: ,as_leads_all E

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
915: ,oe_order_headers_all H
916: ,oe_order_lines_all I

Line 1380: ,as_leads_all X

1376: ,0 targeted_customers
1377: FROM
1378: ams_campaign_schedules_b A
1379: ,ams_source_codes C
1380: ,as_leads_all X
1381: WHERE
1382: A.schedule_id = C.source_code_for_id
1383: AND C.arc_source_code_for = 'CSCH'
1384: AND A.source_code = C.source_code

Line 1419: ,as_leads_all E

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
1422: ,oe_order_headers_all H
1423: ,oe_order_lines_all I

Line 3084: ,as_leads_all X

3080: ,0 targeted_customers
3081: FROM
3082: ams_campaigns_all_b A
3083: ,ams_source_codes C
3084: ,as_leads_all X
3085: WHERE
3086: A.campaign_id = C.source_code_for_id
3087: AND C.arc_source_code_for = 'CAMP'
3088: AND A.source_code = C.source_code

Line 3123: ,as_leads_all E

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
3126: ,oe_order_headers_all H
3127: ,oe_order_lines_all I

Line 3592: ,as_leads_all X

3588: ,0 targeted_customers
3589: FROM
3590: ams_campaign_schedules_b A
3591: ,ams_source_codes C
3592: ,as_leads_all X
3593: WHERE
3594: A.schedule_id = C.source_code_for_id
3595: AND C.arc_source_code_for = 'CSCH'
3596: AND A.source_code = C.source_code

Line 3631: ,as_leads_all E

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
3634: ,oe_order_headers_all H
3635: ,oe_order_lines_all I