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.

[Home] [Help]

APPS.BIL_BI_PIPELINE_F_PKG dependencies on AS_LEAD_LINES_LOG

Line 4543: , as_lead_lines_log linelog

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)
4547: pq_distribute(creditlog1,hash,hash) pq_distribute(linelog1,hash,hash) no_merge */

Line 4563: as_lead_lines_log linelog1,

4559: , leadlog2.win_probability
4560: , leadlog2.decision_date
4561: FROM
4562: as_sales_credits_log creditlog1,
4563: as_lead_lines_log linelog1,
4564: ( -- alias leadlog2
4565: SELECT /*+ full(llog) parallel(llog) pq_distribute(STATUS1,none,broadcast) swap_join_inputs(STATUS1) no_merge */
4566: maxlead.report_date, maxlead.start_date,maxlead.lead_id, maxlead.max_id,
4567: llog.decision_date, llog.win_probability, status1.FORECAST_ROLLUP_FLAG,

Line 4762: , as_lead_lines_log linelog

4758: , MAX(creditlog.log_id) sales_credit_log_id
4759: , TRUNC(leadlog.last_update_date) last_update_date
4760: , DECODE(creditlog.log_mode,'D','D','N') rev_flag
4761: FROM as_sales_credits_log creditlog
4762: , as_lead_lines_log linelog
4763: , (SELECT
4764: log_mode,
4765: last_update_date,
4766: decision_date,

Line 4840: FROM as_lead_lines_log llog, bil_bi_time time

4836: RANK() OVER(PARTITION BY
4837: DECODE(GREATEST(TRUNC(llog.last_update_date), p_coll_start),TRUNC(llog.last_update_date),
4838: TRUNC(llog.last_update_date),time.end_date)
4839: ,llog.lead_line_id ORDER BY llog.log_id desc) log_id_rank
4840: FROM as_lead_lines_log llog, bil_bi_time time
4841: WHERE
4842: (llog.last_update_date >= p_start_date AND llog.last_update_date+0 < p_end_date)
4843: AND(llog.last_update_date >= time.start_date and llog.last_update_date < time.end_date+1)
4844: AND llog.endday_log_flag = 'Y'

Line 4903: , as_lead_lines_log linelog

4899: ) maxlog
4900: where log_id_rank = l_rank
4901:
4902: ) creditlog
4903: , as_lead_lines_log linelog
4904: , as_leads_log leadlog
4905: WHERE linelog.lead_id=leadlog.lead_id
4906: AND creditlog.lead_line_id=linelog.lead_line_id
4907: AND linelog.lead_id = creditlog.lead_id

Line 5011: , as_lead_lines_log linelog

5007: , tmp.last_update_date
5008: , NVL(linelog.forecast_date, leadlog.decision_date)
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'

Line 5087: , as_lead_lines_log linelog

5083: , MAX(creditlog.log_id) sales_credit_log_id
5084: , TRUNC(leadlog.last_update_date) last_update_date
5085: , DECODE(creditlog.log_mode,'D','D','N') rev_flag
5086: FROM as_sales_credits_log creditlog
5087: , as_lead_lines_log linelog
5088: , (SELECT
5089: log_mode,
5090: last_update_date,
5091: decision_date,

Line 5167: FROM as_lead_lines_log llog, bil_bi_time time

5163: RANK() OVER(PARTITION BY
5164: DECODE(GREATEST(TRUNC(llog.last_update_date), p_coll_start),TRUNC(llog.last_update_date),
5165: TRUNC(llog.last_update_date),time.end_date)
5166: ,llog.lead_line_id ORDER BY llog.log_id desc) log_id_rank
5167: FROM as_lead_lines_log llog, bil_bi_time time
5168: WHERE
5169: (llog.last_update_date >= p_start_date AND llog.last_update_date < p_end_date)
5170: AND(llog.last_update_date >= time.start_date and llog.last_update_date < time.end_date+1)
5171: AND llog.endday_log_flag = 'Y'

Line 5232: , as_lead_lines_log linelog

5228: ) maxlog
5229: where log_id_rank = l_rank
5230:
5231: ) creditlog
5232: , as_lead_lines_log linelog
5233: , as_leads_log leadlog
5234: WHERE linelog.lead_id=leadlog.lead_id
5235: AND creditlog.lead_line_id=linelog.lead_line_id
5236: AND linelog.lead_id = creditlog.lead_id

Line 5325: , as_lead_lines_log linelog

5321: , tmp.last_update_date
5322: , NVL(linelog.forecast_date, leadlog.decision_date)
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'

Line 6222: , as_lead_lines_log linelog

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
6226: SELECT

Line 6240: as_lead_lines_log linelog1,

6236: , leadlog2.win_probability
6237: , NVL(linelog1.forecast_date, leadlog2.decision_date) decision_date
6238: FROM
6239: as_sales_credits_log creditlog1,
6240: as_lead_lines_log linelog1,
6241: ( -- alias leadlog2
6242: SELECT maxlead.report_date, maxlead.start_date,maxlead.end_date,maxlead.lead_id, maxlead.max_id,
6243: llog.decision_date, llog.win_probability, llog.status_code,
6244: llog.currency_code