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_MTL_VARIANCE_PKG dependencies on GMF_TRANSACTION_VALUATION

Line 920: GMF_TRANSACTION_VALUATION GTV,

916: -txn_base_value,0),0)) standard_Value_b,
917: -sum(Decode(jobs.line_type,-1,txn_base_value*mtl_dtl.cost_alloc,
918: 2,txn_base_value*mtl_dtl.cost_alloc, 0)) actual_Value_b
919: from
920: GMF_TRANSACTION_VALUATION GTV,
921: OPI_DBI_ORG_LE_TEMP tmp,
922: GME_MATERIAL_DETAILS mtl_dtl,
923: (
924: select /*+ no_merge ordered use_hash(mtl_dtl) full(jobs) parallel(mtl_dtl) parallel(jobs) */

Line 1375: GMF_TRANSACTION_VALUATION GTV,

1371: jobs.source = 2 and
1372: jobs.status in ('Closed') and
1373: jobs.line_type = 1
1374: ) Jobs ,
1375: GMF_TRANSACTION_VALUATION GTV,
1376: OPI_DBI_ORG_LE_TEMP tmp,
1377: GME_MATERIAL_DETAILS mtl_dtl
1378: where
1379: jobs.organization_id = GTV.organization_id and

Line 1786: GMF_TRANSACTION_VALUATION GTV,

1782: jobs.planned_qty planned_qty,
1783: jobs.actual_qty_completed,
1784: jobs.uom_code
1785: from
1786: GMF_TRANSACTION_VALUATION GTV,
1787: OPI_DBI_ORG_LE_TEMP tmp,
1788: GME_MATERIAL_DETAILS MTL_DTL,
1789: (
1790: select /*+ no_merge ordered full(jobs) use_hash(mtl_dtl) full(mtl_dtl) */