DBA Data[Home] [Help]

APPS.BIM_LEAD_FACTS_PKG dependencies on AS_STATUSES_B

Line 624: ,as_statuses_b Y

620: ,0 quotes_open
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

Line 672: ,as_statuses_b Y

668: ,0 quotes_open
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

Line 722: ,as_statuses_b Y

718: ,sum(decode(g.resource_id, null,0,decode(g.order_id, null, 1,0))) quotes_open
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

Line 781: ,as_statuses_b Y

777: ,0 quotes_open
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