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]

VIEW: APPS.BIL_OBI_FST_PG_V

Source

View Text - Preformatted


SELECT sumry.effective_time_id , sumry.parent_sales_group_id, sumry.sales_group_id, nvl(sumry.salesrep_id,0) salesrep_id, sumry.product_category_id, DECODE(sumry.salesrep_id, null, 'Y', 'N') rollup_flag, sumry.forecast_amt, sumry.forecast_amt_s, sumry.forecast_amt_sub, sumry.forecast_amt_sub_s, sumry.opp_forecast_amt, sumry.opp_forecast_amt_s, sumry.opp_forecast_amt_sub, sumry.opp_forecast_amt_sub_s from BIL_OBI_FST_PG_MV sumry, fii_time_structures cal, (select ent_period_id ent_pr_id, end_date from fii_time_ent_period union all select ent_qtr_id ent_pr_id, end_date from fii_time_ent_qtr union all select ent_year_id ent_pr_id, end_date from fii_time_ent_year) ent WHERE 1=1 AND sumry.TXN_TIME_ID = cal.TIME_ID AND sumry.TXN_PERIOD_TYPE_ID = cal.PERIOD_TYPE_ID AND bitand(cal.record_type_id, 512)= 512 AND sumry.EFFECTIVE_PERIOD_TYPE_ID = (case fnd_profile.value('BIL_BI_BASE_FST_PERIOD_TYPE') when 'Week' then 16 when 'Month' then 32 when 'Quarter' then 64 when 'Year' then 128 end) AND NVL(sumry.credit_type_id, 1) = 1 AND sumry.effective_time_id = ent.ent_pr_id AND cal.report_date = ent.end_date WITH READ ONLY

View Text - HTML Formatted

SELECT SUMRY.EFFECTIVE_TIME_ID
, SUMRY.PARENT_SALES_GROUP_ID
, SUMRY.SALES_GROUP_ID
, NVL(SUMRY.SALESREP_ID
, 0) SALESREP_ID
, SUMRY.PRODUCT_CATEGORY_ID
, DECODE(SUMRY.SALESREP_ID
, NULL
, 'Y'
, 'N') ROLLUP_FLAG
, SUMRY.FORECAST_AMT
, SUMRY.FORECAST_AMT_S
, SUMRY.FORECAST_AMT_SUB
, SUMRY.FORECAST_AMT_SUB_S
, SUMRY.OPP_FORECAST_AMT
, SUMRY.OPP_FORECAST_AMT_S
, SUMRY.OPP_FORECAST_AMT_SUB
, SUMRY.OPP_FORECAST_AMT_SUB_S
FROM BIL_OBI_FST_PG_MV SUMRY
, FII_TIME_STRUCTURES CAL
, (SELECT ENT_PERIOD_ID ENT_PR_ID
, END_DATE
FROM FII_TIME_ENT_PERIOD UNION ALL SELECT ENT_QTR_ID ENT_PR_ID
, END_DATE
FROM FII_TIME_ENT_QTR UNION ALL SELECT ENT_YEAR_ID ENT_PR_ID
, END_DATE
FROM FII_TIME_ENT_YEAR) ENT
WHERE 1=1
AND SUMRY.TXN_TIME_ID = CAL.TIME_ID
AND SUMRY.TXN_PERIOD_TYPE_ID = CAL.PERIOD_TYPE_ID
AND BITAND(CAL.RECORD_TYPE_ID
, 512)= 512
AND SUMRY.EFFECTIVE_PERIOD_TYPE_ID = (CASE FND_PROFILE.VALUE('BIL_BI_BASE_FST_PERIOD_TYPE') WHEN 'WEEK' THEN 16 WHEN 'MONTH' THEN 32 WHEN 'QUARTER' THEN 64 WHEN 'YEAR' THEN 128 END)
AND NVL(SUMRY.CREDIT_TYPE_ID
, 1) = 1
AND SUMRY.EFFECTIVE_TIME_ID = ENT.ENT_PR_ID
AND CAL.REPORT_DATE = ENT.END_DATE WITH READ ONLY