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.BIX_PMV_DBI_UTL_PKG dependencies on FND_GLOBAL

Line 735: || fnd_global.newline;

731:
732: l_col_names :=
733: l_col_names
734: || ',NULL c_'|| p_col_name (i).column_alias
735: || fnd_global.newline;
736:
737: ELSE
738: l_date_decode_begin := 'decode(fact.time_id,';
739: l_cur_date_clause := l_c_calc_end_date || ',';

Line 752: || fnd_global.newline;

748: || p_col_name (i).column_name
749: || l_date_decode_end
750: || ') c_'
751: || p_col_name (i).column_alias
752: || fnd_global.newline;
753:
754: END IF;
755: -- Regular current column
756: -- Prev column (based on prior_code)

Line 766: || fnd_global.newline;

762: IF (p_col_name(i).column_name='NULL') THEN
763: l_col_names:=
764: l_col_names
765: || ',NULL p_'|| p_col_name (i).column_alias
766: || fnd_global.newline;
767:
768: ELSE
769: l_col_names :=
770: l_col_names

Line 778: || fnd_global.newline;

774: || p_col_name (i).column_name
775: || l_date_decode_end
776: || ') p_'
777: || p_col_name (i).column_alias
778: || fnd_global.newline;
779: END IF;
780: END IF;
781:
782: -- If grand total is flagged, do current and prior grand totals

Line 796: || fnd_global.newline;

792: || l_date_decode_end
793: || ')) over () c_'
794: || p_col_name (i).column_alias
795: || '_total'
796: || fnd_global.newline;
797:
798: -- Sum of prev column (based on prior_code flagging)
799: IF ( p_col_name (i).prior_code = poa_dbi_util_pkg.both_priors
800: OR p_col_name(i).prior_code = poa_dbi_util_pkg.prev_prev

Line 813: || fnd_global.newline;

809: || l_date_decode_end
810: || ')) over () p_'
811: || p_col_name (i).column_alias
812: || '_total'
813: || fnd_global.newline;
814: END IF;
815:
816:
817: END IF;

Line 1631: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS

1627: --Move into the IF block if its just a pseudo column value ('0')
1628: IF p_bix_col_tab(i).COLUMN_NAME = '0' THEN
1629: --If prior value for this measure is also to be calculated, then do it here.
1630: IF p_bix_col_tab(i).prior_code = 2 THEN
1631: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS
1632: ||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'p_'||p_bix_col_tab(i).COLUMN_ALIAS;
1633: ELSE--003
1634: --Form the SELECT list where prior value is not required.
1635: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS;

Line 1632: ||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'p_'||p_bix_col_tab(i).COLUMN_ALIAS;

1628: IF p_bix_col_tab(i).COLUMN_NAME = '0' THEN
1629: --If prior value for this measure is also to be calculated, then do it here.
1630: IF p_bix_col_tab(i).prior_code = 2 THEN
1631: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS
1632: ||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'p_'||p_bix_col_tab(i).COLUMN_ALIAS;
1633: ELSE--003
1634: --Form the SELECT list where prior value is not required.
1635: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS;
1636: END IF;

Line 1635: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS;

1631: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS
1632: ||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'p_'||p_bix_col_tab(i).COLUMN_ALIAS;
1633: ELSE--003
1634: --Form the SELECT list where prior value is not required.
1635: l_select_list := l_select_list||fnd_global.newline||','||p_bix_col_tab(i).COLUMN_NAME||' '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS;
1636: END IF;
1637: ELSE
1638: --Get the prior values for the actual column names.
1639: IF p_bix_col_tab(i).prior_code = 2 THEN

Line 1640: l_select_list := l_select_list||fnd_global.newline||','||

1636: END IF;
1637: ELSE
1638: --Get the prior values for the actual column names.
1639: IF p_bix_col_tab(i).prior_code = 2 THEN
1640: l_select_list := l_select_list||fnd_global.newline||','||
1641: 'SUM(CASE when(fii1.start_date between &BIS_CURRENT_REPORT_START_DATE and &BIS_CURRENT_ASOF_DATE)
1642: THEN '||p_bix_col_tab(i).COLUMN_NAME||' ELSE 0 END) '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS
1643: ||fnd_global.newline||','||'SUM(CASE when(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)
1644: THEN '||p_bix_col_tab(i).COLUMN_NAME||' ELSE 0 END) '||'p_'||p_bix_col_tab(i).COLUMN_ALIAS;

Line 1643: ||fnd_global.newline||','||'SUM(CASE when(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)

1639: IF p_bix_col_tab(i).prior_code = 2 THEN
1640: l_select_list := l_select_list||fnd_global.newline||','||
1641: 'SUM(CASE when(fii1.start_date between &BIS_CURRENT_REPORT_START_DATE and &BIS_CURRENT_ASOF_DATE)
1642: THEN '||p_bix_col_tab(i).COLUMN_NAME||' ELSE 0 END) '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS
1643: ||fnd_global.newline||','||'SUM(CASE when(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)
1644: THEN '||p_bix_col_tab(i).COLUMN_NAME||' ELSE 0 END) '||'p_'||p_bix_col_tab(i).COLUMN_ALIAS;
1645: ELSE --003
1646: l_select_list := l_select_list||fnd_global.newline||','||
1647: 'SUM(CASE when(fii1.start_date between &BIS_CURRENT_REPORT_START_DATE and &BIS_CURRENT_ASOF_DATE)

Line 1646: l_select_list := l_select_list||fnd_global.newline||','||

1642: THEN '||p_bix_col_tab(i).COLUMN_NAME||' ELSE 0 END) '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS
1643: ||fnd_global.newline||','||'SUM(CASE when(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)
1644: THEN '||p_bix_col_tab(i).COLUMN_NAME||' ELSE 0 END) '||'p_'||p_bix_col_tab(i).COLUMN_ALIAS;
1645: ELSE --003
1646: l_select_list := l_select_list||fnd_global.newline||','||
1647: 'SUM(CASE when(fii1.start_date between &BIS_CURRENT_REPORT_START_DATE and &BIS_CURRENT_ASOF_DATE)
1648: THEN '||p_bix_col_tab(i).COLUMN_NAME||' ELSE 0 END) '||'curr_'||p_bix_col_tab(i).COLUMN_ALIAS;
1649: END IF;
1650: END IF;

Line 1657: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'||' fii_time_rpt_struct ' ||' cal ,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1 ';

1653: p_bix_col_tab.DELETE;
1654:
1655: --Form the FROM list and the where clause for reports that display session level values.
1656: IF p_mv_set = 'SES' THEN
1657: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'||' fii_time_rpt_struct ' ||' cal ,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1 ';
1658: l_where_clause := fnd_global.newline
1659: ||'WHERE fact.time_id = cal.time_id '
1660: ||fnd_global.newline||'AND bitand(cal.record_type_id,&BIS_NESTED_PATTERN)=cal.record_type_id '
1661: ||fnd_global.newline||'AND cal.period_type_id = fact.period_type_id '

Line 1658: l_where_clause := fnd_global.newline

1654:
1655: --Form the FROM list and the where clause for reports that display session level values.
1656: IF p_mv_set = 'SES' THEN
1657: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'||' fii_time_rpt_struct ' ||' cal ,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1 ';
1658: l_where_clause := fnd_global.newline
1659: ||'WHERE fact.time_id = cal.time_id '
1660: ||fnd_global.newline||'AND bitand(cal.record_type_id,&BIS_NESTED_PATTERN)=cal.record_type_id '
1661: ||fnd_global.newline||'AND cal.period_type_id = fact.period_type_id '
1662: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '

Line 1660: ||fnd_global.newline||'AND bitand(cal.record_type_id,&BIS_NESTED_PATTERN)=cal.record_type_id '

1656: IF p_mv_set = 'SES' THEN
1657: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'||' fii_time_rpt_struct ' ||' cal ,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1 ';
1658: l_where_clause := fnd_global.newline
1659: ||'WHERE fact.time_id = cal.time_id '
1660: ||fnd_global.newline||'AND bitand(cal.record_type_id,&BIS_NESTED_PATTERN)=cal.record_type_id '
1661: ||fnd_global.newline||'AND cal.period_type_id = fact.period_type_id '
1662: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '
1663: ||p_where_clause;
1664:

Line 1661: ||fnd_global.newline||'AND cal.period_type_id = fact.period_type_id '

1657: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'||' fii_time_rpt_struct ' ||' cal ,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1 ';
1658: l_where_clause := fnd_global.newline
1659: ||'WHERE fact.time_id = cal.time_id '
1660: ||fnd_global.newline||'AND bitand(cal.record_type_id,&BIS_NESTED_PATTERN)=cal.record_type_id '
1661: ||fnd_global.newline||'AND cal.period_type_id = fact.period_type_id '
1662: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '
1663: ||p_where_clause;
1664:
1665: IF (p_comparison_type = 'Y' AND p_xtd <> 'YTD') THEN

Line 1662: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '

1658: l_where_clause := fnd_global.newline
1659: ||'WHERE fact.time_id = cal.time_id '
1660: ||fnd_global.newline||'AND bitand(cal.record_type_id,&BIS_NESTED_PATTERN)=cal.record_type_id '
1661: ||fnd_global.newline||'AND cal.period_type_id = fact.period_type_id '
1662: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '
1663: ||p_where_clause;
1664:
1665: IF (p_comparison_type = 'Y' AND p_xtd <> 'YTD') THEN
1666: l_where_clause := l_where_clause ||fnd_global.newline||'AND cal.report_date = (CASE WHEN(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)

Line 1666: l_where_clause := l_where_clause ||fnd_global.newline||'AND cal.report_date = (CASE WHEN(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)

1662: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '
1663: ||p_where_clause;
1664:
1665: IF (p_comparison_type = 'Y' AND p_xtd <> 'YTD') THEN
1666: l_where_clause := l_where_clause ||fnd_global.newline||'AND cal.report_date = (CASE WHEN(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)
1667: THEN least(fii1.end_date, &BIS_PREVIOUS_ASOF_DATE) ELSE least(fii1.end_date, &BIS_CURRENT_ASOF_DATE) END) ';
1668: ELSE
1669: l_where_clause := l_where_clause || fnd_global.newline||' AND cal.report_date = least(fii1.end_date, &BIS_CURRENT_ASOF_DATE) ';
1670: END IF;

Line 1669: l_where_clause := l_where_clause || fnd_global.newline||' AND cal.report_date = least(fii1.end_date, &BIS_CURRENT_ASOF_DATE) ';

1665: IF (p_comparison_type = 'Y' AND p_xtd <> 'YTD') THEN
1666: l_where_clause := l_where_clause ||fnd_global.newline||'AND cal.report_date = (CASE WHEN(fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE and &BIS_PREVIOUS_ASOF_DATE)
1667: THEN least(fii1.end_date, &BIS_PREVIOUS_ASOF_DATE) ELSE least(fii1.end_date, &BIS_CURRENT_ASOF_DATE) END) ';
1668: ELSE
1669: l_where_clause := l_where_clause || fnd_global.newline||' AND cal.report_date = least(fii1.end_date, &BIS_CURRENT_ASOF_DATE) ';
1670: END IF;
1671:
1672: ELSE
1673: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1';

Line 1673: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1';

1669: l_where_clause := l_where_clause || fnd_global.newline||' AND cal.report_date = least(fii1.end_date, &BIS_CURRENT_ASOF_DATE) ';
1670: END IF;
1671:
1672: ELSE
1673: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1';
1674: l_where_clause := fnd_global.newline
1675: ||'WHERE fact.period_type_id = 1 '
1676: ||fnd_global.newline||'AND fact.time_id = TO_CHAR(fii1.start_date,''J'') '
1677: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '

Line 1674: l_where_clause := fnd_global.newline

1670: END IF;
1671:
1672: ELSE
1673: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1';
1674: l_where_clause := fnd_global.newline
1675: ||'WHERE fact.period_type_id = 1 '
1676: ||fnd_global.newline||'AND fact.time_id = TO_CHAR(fii1.start_date,''J'') '
1677: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '
1678: ||p_where_clause;

Line 1676: ||fnd_global.newline||'AND fact.time_id = TO_CHAR(fii1.start_date,''J'') '

1672: ELSE
1673: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1';
1674: l_where_clause := fnd_global.newline
1675: ||'WHERE fact.period_type_id = 1 '
1676: ||fnd_global.newline||'AND fact.time_id = TO_CHAR(fii1.start_date,''J'') '
1677: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '
1678: ||p_where_clause;
1679: END IF;
1680:

Line 1677: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '

1673: l_from_list := fnd_global.newline||' FROM '||get_mv(p_mv_set,'6.0.4') ||' fact,'|| poa_dbi_util_pkg.get_calendar_table(p_xtd) ||' fii1';
1674: l_where_clause := fnd_global.newline
1675: ||'WHERE fact.period_type_id = 1 '
1676: ||fnd_global.newline||'AND fact.time_id = TO_CHAR(fii1.start_date,''J'') '
1677: ||fnd_global.newline||'AND fii1.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE AND &BIS_CURRENT_ASOF_DATE '
1678: ||p_where_clause;
1679: END IF;
1680:
1681: