APPS.BIL_BI_PIPELINE_F_PKG dependencies on AS_LEADS_ALL

Line 1295: (SELECT /*+ index_ffs(as_leads_all) parallel_index(as_leads_all) */ count(*) cnt FROM as_leads_all)

1291: SELECT /*+ index_ffs(as_leads_log) parallel_index(as_leads_log) */ count(*) cnt
1292: FROM as_leads_log
1293: UNION ALL
1294: SELECT -cnt FROM
1295: (SELECT /*+ index_ffs(as_leads_all) parallel_index(as_leads_all) */ count(*) cnt FROM as_leads_all)
1296: );
1297:
1298: IF (l_opty_cnt < 0 ) THEN
1299: -- log table has not been populated.

Line 4542: FROM as_leads_all leads

4538: , maxlog.opp_open_status_flag open_status_flag
4539: , sum(creditlog.credit_amount)
4540: , maxlog.report_date
4541: , nvl(linelog.forecast_date, maxlog.decision_date)
4542: FROM as_leads_all leads
4543: , as_lead_lines_log linelog
4544: , as_sales_credits_log creditlog
4545: , (-- alias maxlog
4546: SELECT /*+ parallel(linelog1) parallel(creditlog1) full(linelog1) full(creditlog1)

Line 5014: , as_leads_all lead

5010: ,as_sales_credits_log creditlog
5011: , as_lead_lines_log linelog
5012: , as_leads_log leadlog
5013: , as_statuses_b status
5014: , as_leads_all lead
5015: WHERE tmp.rev_flag = 'N'
5016: and tmp.lead_log_id = leadlog.log_id
5017: AND tmp.lead_line_log_id = linelog.log_id
5018: AND tmp.sales_credit_log_id = creditlog.log_id

Line 5328: , as_leads_all lead

5324: ,as_sales_credits_log creditlog
5325: , as_lead_lines_log linelog
5326: , as_leads_log leadlog
5327: , as_statuses_b status
5328: , as_leads_all lead
5329: WHERE tmp.rev_flag = 'N'
5330: and tmp.lead_log_id = leadlog.log_id
5331: AND tmp.lead_line_log_id = linelog.log_id
5332: AND tmp.sales_credit_log_id = creditlog.log_id

Line 6221: FROM as_leads_all lead

6217: , status.opp_open_status_flag open_status_flag
6218: , sum(creditlog.credit_amount)
6219: , maxlog.report_date
6220: , maxlog.decision_date
6221: FROM as_leads_all lead
6222: , as_lead_lines_log linelog
6223: , as_statuses_b status
6224: , as_sales_credits_log creditlog
6225: , (-- alias maxlog