eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIL_BI_PIPELINE_F_PKG dependencies on AS_STATUSES_B

Line 4594: as_statuses_b status1

4590: GROUP BY lead_id, --gapdays.report_date, gapdays.start_date, gapdays.end_date
4591: l_report_date, l_report_start, l_report_end
4592: ) maxlead,
4593: as_leads_log llog,
4594: as_statuses_b status1
4595: WHERE maxlead.max_id = llog.log_id
4596: and status1.status_Code = llog.status_Code
4597: and llog.decision_date >= g_global_start_date
4598: AND llog.decision_date >= maxlead.start_date

Line 5013: , as_statuses_b status

5009: FROM BIL_BI_OPDTL_DENLOG_TMP tmp
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

Line 5327: , as_statuses_b status

5323: FROM BIL_BI_OPDTL_DENLOG_TMP tmp
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

Line 6223: , as_statuses_b status

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
6226: SELECT
6227: leadlog2.lead_id lead_id