DBA Data[Home] [Help]

APPS.BIM_I_LEAD_FACTS_PKG dependencies on AS_SALES_LEAD_LINES

Line 438: ,as_sales_lead_lines Y

434: ,'N' CUSTOMER_FLAG
435: ,x.DESCRIPTION
436: FROM
437: as_sales_leads X
438: ,as_sales_lead_lines Y
439: WHERE
440: X.creation_date between p_start_date and l_sysdate
441: AND X.sales_lead_id = Y.sales_lead_id(+) ;
442:

Line 1060: ,as_sales_lead_lines Y

1056: ,'N' CUSTOMER_FLAG
1057: ,x.DESCRIPTION
1058: FROM
1059: as_sales_leads X
1060: ,as_sales_lead_lines Y
1061: WHERE
1062: (X.last_update_date between p_start_date and l_sysdate OR Y.last_update_date between p_start_date and l_sysdate)
1063: AND X.sales_lead_id = Y.sales_lead_id
1064: AND X.creation_date >=p_global_date ;