DBA Data[Home] [Help]

APPS.BIM_LEAD_FACTS_PKG dependencies on BIM_R_SOURCE_CODES

Line 625: ,bim_r_source_codes A

621: ,0 orders
622: FROM
623: as_sales_leads X
624: ,as_statuses_b Y
625: ,bim_r_source_codes A
626: WHERE
627: trunc(X.creation_date) between p_start_date and p_end_date
628: AND X.status_code = Y.status_code
629: AND Y.lead_flag = 'Y'

Line 673: ,bim_r_source_codes A

669: ,0 orders
670: FROM
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

Line 723: ,bim_r_source_codes A

719: ,0 orders
720: FROM
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

Line 782: ,bim_r_source_codes A

778: ,count(h.header_id) orders
779: FROM
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