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.OPI_DBI_CURR_VAR_RPT_PKG dependencies on STANDARD

Line 78: -- STANDARD_VALUE_, ACTUAL_VALUE_

74: 'NONE');
75:
76:
77: -- The measure columns that need to be aggregated are
78: -- STANDARD_VALUE_, ACTUAL_VALUE_
79: -- If viewing by item as, then sum up
80: -- ACTUAL_PRD_QTY
81: poa_dbi_util_pkg.add_column (l_col_tbl,
82: 'STANDARD_VALUE_' || l_cur_suffix,

Line 82: 'STANDARD_VALUE_' || l_cur_suffix,

78: -- STANDARD_VALUE_, ACTUAL_VALUE_
79: -- If viewing by item as, then sum up
80: -- ACTUAL_PRD_QTY
81: poa_dbi_util_pkg.add_column (l_col_tbl,
82: 'STANDARD_VALUE_' || l_cur_suffix,
83: 'STANDARD_VALUE');
84:
85: poa_dbi_util_pkg.add_column (l_col_tbl,
86: 'ACTUAL_VALUE_' || l_cur_suffix,

Line 83: 'STANDARD_VALUE');

79: -- If viewing by item as, then sum up
80: -- ACTUAL_PRD_QTY
81: poa_dbi_util_pkg.add_column (l_col_tbl,
82: 'STANDARD_VALUE_' || l_cur_suffix,
83: 'STANDARD_VALUE');
84:
85: poa_dbi_util_pkg.add_column (l_col_tbl,
86: 'ACTUAL_VALUE_' || l_cur_suffix,
87: 'ACTUAL_VALUE');

Line 167: oset.C_STANDARD_VALUE OPI_MEASURE1,

163: l_sel_clause := l_sel_clause || 'NULL OPI_ATTRIBUTE4 ,';
164: END IF;
165:
166: l_sel_clause := l_sel_clause || '
167: oset.C_STANDARD_VALUE OPI_MEASURE1,
168: oset.C_ACTUAL_VALUE OPI_MEASURE2,
169: '|| l_qty || ' OPI_MEASURE3,
170: oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE OPI_MEASURE4,
171: decode(oset.C_STANDARD_VALUE,0, to_number(null), ((oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE)/oset.C_STANDARD_VALUE)*100) OPI_MEASURE5,

Line 170: oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE OPI_MEASURE4,

166: l_sel_clause := l_sel_clause || '
167: oset.C_STANDARD_VALUE OPI_MEASURE1,
168: oset.C_ACTUAL_VALUE OPI_MEASURE2,
169: '|| l_qty || ' OPI_MEASURE3,
170: oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE OPI_MEASURE4,
171: decode(oset.C_STANDARD_VALUE,0, to_number(null), ((oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE)/oset.C_STANDARD_VALUE)*100) OPI_MEASURE5,
172: oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE6,
173: oset.C_ACTUAL_VALUE_TOTAL OPI_MEASURE7,
174: oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE8,

Line 171: decode(oset.C_STANDARD_VALUE,0, to_number(null), ((oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE)/oset.C_STANDARD_VALUE)*100) OPI_MEASURE5,

167: oset.C_STANDARD_VALUE OPI_MEASURE1,
168: oset.C_ACTUAL_VALUE OPI_MEASURE2,
169: '|| l_qty || ' OPI_MEASURE3,
170: oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE OPI_MEASURE4,
171: decode(oset.C_STANDARD_VALUE,0, to_number(null), ((oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE)/oset.C_STANDARD_VALUE)*100) OPI_MEASURE5,
172: oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE6,
173: oset.C_ACTUAL_VALUE_TOTAL OPI_MEASURE7,
174: oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE8,
175: CASE WHEN oset.C_STANDARD_VALUE_TOTAL = 0 THEN to_number(NULL)

Line 172: oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE6,

168: oset.C_ACTUAL_VALUE OPI_MEASURE2,
169: '|| l_qty || ' OPI_MEASURE3,
170: oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE OPI_MEASURE4,
171: decode(oset.C_STANDARD_VALUE,0, to_number(null), ((oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE)/oset.C_STANDARD_VALUE)*100) OPI_MEASURE5,
172: oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE6,
173: oset.C_ACTUAL_VALUE_TOTAL OPI_MEASURE7,
174: oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE8,
175: CASE WHEN oset.C_STANDARD_VALUE_TOTAL = 0 THEN to_number(NULL)
176: ELSE ((oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL)/oset.C_STANDARD_VALUE_TOTAL)*100 END OPI_MEASURE9 ';

Line 174: oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE8,

170: oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE OPI_MEASURE4,
171: decode(oset.C_STANDARD_VALUE,0, to_number(null), ((oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE)/oset.C_STANDARD_VALUE)*100) OPI_MEASURE5,
172: oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE6,
173: oset.C_ACTUAL_VALUE_TOTAL OPI_MEASURE7,
174: oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE8,
175: CASE WHEN oset.C_STANDARD_VALUE_TOTAL = 0 THEN to_number(NULL)
176: ELSE ((oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL)/oset.C_STANDARD_VALUE_TOTAL)*100 END OPI_MEASURE9 ';
177:
178: return l_sel_clause;

Line 175: CASE WHEN oset.C_STANDARD_VALUE_TOTAL = 0 THEN to_number(NULL)

171: decode(oset.C_STANDARD_VALUE,0, to_number(null), ((oset.C_ACTUAL_VALUE - oset.C_STANDARD_VALUE)/oset.C_STANDARD_VALUE)*100) OPI_MEASURE5,
172: oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE6,
173: oset.C_ACTUAL_VALUE_TOTAL OPI_MEASURE7,
174: oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE8,
175: CASE WHEN oset.C_STANDARD_VALUE_TOTAL = 0 THEN to_number(NULL)
176: ELSE ((oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL)/oset.C_STANDARD_VALUE_TOTAL)*100 END OPI_MEASURE9 ';
177:
178: return l_sel_clause;
179:

Line 176: ELSE ((oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL)/oset.C_STANDARD_VALUE_TOTAL)*100 END OPI_MEASURE9 ';

172: oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE6,
173: oset.C_ACTUAL_VALUE_TOTAL OPI_MEASURE7,
174: oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL OPI_MEASURE8,
175: CASE WHEN oset.C_STANDARD_VALUE_TOTAL = 0 THEN to_number(NULL)
176: ELSE ((oset.C_ACTUAL_VALUE_TOTAL - oset.C_STANDARD_VALUE_TOTAL)/oset.C_STANDARD_VALUE_TOTAL)*100 END OPI_MEASURE9 ';
177:
178: return l_sel_clause;
179:
180: END get_status_sel_clause;