DBA Data[Home] [Help]

APPS.BIM_LEAD_FACTS_PKG dependencies on AS_LEADS_ALL

Line 675: ,as_leads_all E

671: as_sales_leads X
672: ,as_statuses_b Y
673: ,bim_r_source_codes A
674: ,as_sales_lead_opportunity D
675: ,as_leads_all E
676: WHERE
677: trunc(d.creation_date) between p_start_date and p_end_date
678: AND X.sales_lead_id = D.sales_lead_id
679: AND D.opportunity_id = E.lead_id

Line 725: ,as_leads_all E

721: as_sales_leads X
722: ,as_statuses_b Y
723: ,bim_r_source_codes A
724: ,as_sales_lead_opportunity D
725: ,as_leads_all E
726: ,aso_quote_related_objects F
727: ,aso_quote_headers_all G
728: WHERE
729: trunc(f.creation_date) between p_start_date and p_end_date

Line 784: ,as_leads_all E

780: as_sales_leads X
781: ,as_statuses_b Y
782: ,bim_r_source_codes A
783: ,as_sales_lead_opportunity D
784: ,as_leads_all E
785: ,aso_quote_related_objects F
786: ,aso_quote_headers_all G
787: ,oe_order_headers_all H
788: ,oe_order_lines_all I