APPS.OPI_DBI_OPEN_JOB_DTL_PKG dependencies on STANDARD

Line 208: ,standard_value opi_measure3

204: ,status opi_attribute2
205: ,job_status_code
206: ,start_qty opi_measure1
207: ,actual_qty opi_measure2
208: ,standard_value opi_measure3
209: ,actual_value opi_measure4
210: ,(actual_value - standard_value) opi_measure5
211: ,(actual_value - standard_value)*100/(decode(standard_value,0,null,standard_value)) opi_measure6
212: ,standard_value_tot opi_measure7

Line 210: ,(actual_value - standard_value) opi_measure5

206: ,start_qty opi_measure1
207: ,actual_qty opi_measure2
208: ,standard_value opi_measure3
209: ,actual_value opi_measure4
210: ,(actual_value - standard_value) opi_measure5
211: ,(actual_value - standard_value)*100/(decode(standard_value,0,null,standard_value)) opi_measure6
212: ,standard_value_tot opi_measure7
213: ,actual_value_tot opi_measure8
214: ,(actual_value_tot - standard_value_tot) opi_measure9

Line 211: ,(actual_value - standard_value)*100/(decode(standard_value,0,null,standard_value)) opi_measure6

207: ,actual_qty opi_measure2
208: ,standard_value opi_measure3
209: ,actual_value opi_measure4
210: ,(actual_value - standard_value) opi_measure5
211: ,(actual_value - standard_value)*100/(decode(standard_value,0,null,standard_value)) opi_measure6
212: ,standard_value_tot opi_measure7
213: ,actual_value_tot opi_measure8
214: ,(actual_value_tot - standard_value_tot) opi_measure9
215: ,(actual_value_tot - standard_value_tot)*100/(decode(standard_value_tot,0,null,standard_value_tot)) opi_measure10

Line 212: ,standard_value_tot opi_measure7

208: ,standard_value opi_measure3
209: ,actual_value opi_measure4
210: ,(actual_value - standard_value) opi_measure5
211: ,(actual_value - standard_value)*100/(decode(standard_value,0,null,standard_value)) opi_measure6
212: ,standard_value_tot opi_measure7
213: ,actual_value_tot opi_measure8
214: ,(actual_value_tot - standard_value_tot) opi_measure9
215: ,(actual_value_tot - standard_value_tot)*100/(decode(standard_value_tot,0,null,standard_value_tot)) opi_measure10
216: from

Line 214: ,(actual_value_tot - standard_value_tot) opi_measure9

210: ,(actual_value - standard_value) opi_measure5
211: ,(actual_value - standard_value)*100/(decode(standard_value,0,null,standard_value)) opi_measure6
212: ,standard_value_tot opi_measure7
213: ,actual_value_tot opi_measure8
214: ,(actual_value_tot - standard_value_tot) opi_measure9
215: ,(actual_value_tot - standard_value_tot)*100/(decode(standard_value_tot,0,null,standard_value_tot)) opi_measure10
216: from
217: (select
218: jobs.job_name job_name,

Line 215: ,(actual_value_tot - standard_value_tot)*100/(decode(standard_value_tot,0,null,standard_value_tot)) opi_measure10

211: ,(actual_value - standard_value)*100/(decode(standard_value,0,null,standard_value)) opi_measure6
212: ,standard_value_tot opi_measure7
213: ,actual_value_tot opi_measure8
214: ,(actual_value_tot - standard_value_tot) opi_measure9
215: ,(actual_value_tot - standard_value_tot)*100/(decode(standard_value_tot,0,null,standard_value_tot)) opi_measure10
216: from
217: (select
218: jobs.job_name job_name,
219: jobs.job_id job_id,

Line 227: decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,

223: jobs.job_status_code job_status_code,
224: jobs.status status,
225: jobs.start_quantity start_qty,
226: fact.actual_prd_qty actual_qty,
227: decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,
228: ''G'',fact.standard_value_g,
229: ''SG'',fact.standard_value_sg) standard_value,
230: decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
231: ''G'',fact.actual_value_g,

Line 228: ''G'',fact.standard_value_g,

224: jobs.status status,
225: jobs.start_quantity start_qty,
226: fact.actual_prd_qty actual_qty,
227: decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,
228: ''G'',fact.standard_value_g,
229: ''SG'',fact.standard_value_sg) standard_value,
230: decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
231: ''G'',fact.actual_value_g,
232: ''SG'',fact.actual_value_sg) actual_value,

Line 229: ''SG'',fact.standard_value_sg) standard_value,

225: jobs.start_quantity start_qty,
226: fact.actual_prd_qty actual_qty,
227: decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,
228: ''G'',fact.standard_value_g,
229: ''SG'',fact.standard_value_sg) standard_value,
230: decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
231: ''G'',fact.actual_value_g,
232: ''SG'',fact.actual_value_sg) actual_value,
233: sum(decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,

Line 233: sum(decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,

229: ''SG'',fact.standard_value_sg) standard_value,
230: decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
231: ''G'',fact.actual_value_g,
232: ''SG'',fact.actual_value_sg) actual_value,
233: sum(decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,
234: ''G'',fact.standard_value_g,
235: ''SG'',fact.standard_value_sg)) over()
236: standard_value_tot,
237: sum(decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,

Line 234: ''G'',fact.standard_value_g,

230: decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
231: ''G'',fact.actual_value_g,
232: ''SG'',fact.actual_value_sg) actual_value,
233: sum(decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,
234: ''G'',fact.standard_value_g,
235: ''SG'',fact.standard_value_sg)) over()
236: standard_value_tot,
237: sum(decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
238: ''G'',fact.actual_value_g,

Line 235: ''SG'',fact.standard_value_sg)) over()

231: ''G'',fact.actual_value_g,
232: ''SG'',fact.actual_value_sg) actual_value,
233: sum(decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,
234: ''G'',fact.standard_value_g,
235: ''SG'',fact.standard_value_sg)) over()
236: standard_value_tot,
237: sum(decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
238: ''G'',fact.actual_value_g,
239: ''SG'',fact.actual_value_sg)) over()

Line 236: standard_value_tot,

232: ''SG'',fact.actual_value_sg) actual_value,
233: sum(decode(''' || l_currency_code || ''', ''B'',fact.standard_value_b,
234: ''G'',fact.standard_value_g,
235: ''SG'',fact.standard_value_sg)) over()
236: standard_value_tot,
237: sum(decode(''' || l_currency_code || ''', ''B'',fact.actual_value_b,
238: ''G'',fact.actual_value_g,
239: ''SG'',fact.actual_value_sg)) over()
240: actual_value_tot

Line 263: fact.standard_value_b,

259: jobs.job_status_code,
260: jobs.status,
261: jobs.start_quantity,
262: fact.actual_prd_qty,
263: fact.standard_value_b,
264: fact.standard_value_g,
265: fact.standard_value_sg,
266: fact.actual_value_b,
267: fact.actual_value_g,

Line 264: fact.standard_value_g,

260: jobs.status,
261: jobs.start_quantity,
262: fact.actual_prd_qty,
263: fact.standard_value_b,
264: fact.standard_value_g,
265: fact.standard_value_sg,
266: fact.actual_value_b,
267: fact.actual_value_g,
268: fact.actual_value_sg

Line 265: fact.standard_value_sg,

261: jobs.start_quantity,
262: fact.actual_prd_qty,
263: fact.standard_value_b,
264: fact.standard_value_g,
265: fact.standard_value_sg,
266: fact.actual_value_b,
267: fact.actual_value_g,
268: fact.actual_value_sg
269: )))f