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_MFG_JOB_DTL_PKG dependencies on STANDARD

Line 185: ,sum(fact.standard_value_b) opi_measure3_b

181: ,fact.assembly_item_id
182: ,fact.organization_id
183: ,sum(jobs.start_quantity) opi_measure1
184: ,sum(fact.actual_qty_completed) opi_measure2
185: ,sum(fact.standard_value_b) opi_measure3_b
186: ,sum(fact.actual_value_b) opi_measure4_b
187: ,sum(fact.actual_value_b)- sum(fact.standard_value_b) opi_measure5_b
188: ,((sum(fact.actual_value_b)-sum(fact.standard_value_b))/decode(sum(fact.standard_value_b),0,null,sum(fact.standard_value_b)))*100 opi_measure6
189: ,sum(sum(fact.standard_value_b)) over() opi_measure7_b

Line 187: ,sum(fact.actual_value_b)- sum(fact.standard_value_b) opi_measure5_b

183: ,sum(jobs.start_quantity) opi_measure1
184: ,sum(fact.actual_qty_completed) opi_measure2
185: ,sum(fact.standard_value_b) opi_measure3_b
186: ,sum(fact.actual_value_b) opi_measure4_b
187: ,sum(fact.actual_value_b)- sum(fact.standard_value_b) opi_measure5_b
188: ,((sum(fact.actual_value_b)-sum(fact.standard_value_b))/decode(sum(fact.standard_value_b),0,null,sum(fact.standard_value_b)))*100 opi_measure6
189: ,sum(sum(fact.standard_value_b)) over() opi_measure7_b
190: ,sum(sum(fact.actual_value_b)) over() opi_measure8_b
191:

Line 188: ,((sum(fact.actual_value_b)-sum(fact.standard_value_b))/decode(sum(fact.standard_value_b),0,null,sum(fact.standard_value_b)))*100 opi_measure6

184: ,sum(fact.actual_qty_completed) opi_measure2
185: ,sum(fact.standard_value_b) opi_measure3_b
186: ,sum(fact.actual_value_b) opi_measure4_b
187: ,sum(fact.actual_value_b)- sum(fact.standard_value_b) opi_measure5_b
188: ,((sum(fact.actual_value_b)-sum(fact.standard_value_b))/decode(sum(fact.standard_value_b),0,null,sum(fact.standard_value_b)))*100 opi_measure6
189: ,sum(sum(fact.standard_value_b)) over() opi_measure7_b
190: ,sum(sum(fact.actual_value_b)) over() opi_measure8_b
191:
192: from

Line 189: ,sum(sum(fact.standard_value_b)) over() opi_measure7_b

185: ,sum(fact.standard_value_b) opi_measure3_b
186: ,sum(fact.actual_value_b) opi_measure4_b
187: ,sum(fact.actual_value_b)- sum(fact.standard_value_b) opi_measure5_b
188: ,((sum(fact.actual_value_b)-sum(fact.standard_value_b))/decode(sum(fact.standard_value_b),0,null,sum(fact.standard_value_b)))*100 opi_measure6
189: ,sum(sum(fact.standard_value_b)) over() opi_measure7_b
190: ,sum(sum(fact.actual_value_b)) over() opi_measure8_b
191:
192: from
193: opi_dbi_mfg_cst_var_f fact