APPS.OPI_DBI_SCRAP_REASON_RPT_PKG dependencies on FND_GLOBAL

Line 129: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;

125: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
126: (p_join_tbl);
127: l_sel_clause :=
128: 'SELECT
129: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;
130:
131: l_sel_clause := l_sel_clause ||
132: ' OPI_MEASURE1
133: ,OPI_MEASURE2

Line 138: ,OPI_MEASURE7'|| fnd_global.newline;

134: ,OPI_MEASURE3
135: ,OPI_MEASURE4
136: ,OPI_MEASURE5
137: ,OPI_MEASURE6
138: ,OPI_MEASURE7'|| fnd_global.newline;
139:
140: l_sel_clause := l_sel_clause ||
141: 'FROM ( SELECT
142: rank() over (&ORDER_BY_CLAUSE nulls last '||', '||l_view_by_fact_col||') - 1 rnk

Line 152: ,OPI_MEASURE7'|| fnd_global.newline;

148: ,OPI_MEASURE3
149: ,OPI_MEASURE4
150: ,OPI_MEASURE5
151: ,OPI_MEASURE6
152: ,OPI_MEASURE7'|| fnd_global.newline;
153:
154: l_sel_clause := l_sel_clause ||
155: 'FROM ( SELECT ' || fnd_global.newline ||
156: l_view_by_fact_col || fnd_global.newline ||

Line 155: 'FROM ( SELECT ' || fnd_global.newline ||

151: ,OPI_MEASURE6
152: ,OPI_MEASURE7'|| fnd_global.newline;
153:
154: l_sel_clause := l_sel_clause ||
155: 'FROM ( SELECT ' || fnd_global.newline ||
156: l_view_by_fact_col || fnd_global.newline ||
157: ',' || opi_dbi_rpt_util_pkg.nvl_str (
158: p_str => 'p_scrap_val',
159: p_default_val => 0) || ' OPI_MEASURE1,

Line 156: l_view_by_fact_col || fnd_global.newline ||

152: ,OPI_MEASURE7'|| fnd_global.newline;
153:
154: l_sel_clause := l_sel_clause ||
155: 'FROM ( SELECT ' || fnd_global.newline ||
156: l_view_by_fact_col || fnd_global.newline ||
157: ',' || opi_dbi_rpt_util_pkg.nvl_str (
158: p_str => 'p_scrap_val',
159: p_default_val => 0) || ' OPI_MEASURE1,
160: ' || opi_dbi_rpt_util_pkg.nvl_str (