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 GME_MATERIAL_DETAILS

Line 635: GME_MATERIAL_DETAILS gmd

631: gmd.line_type,
632: gmd.material_detail_id line_id
633: from
634: OPI_DBI_JOBS_F jobs,
635: GME_MATERIAL_DETAILS gmd
636: where
637: jobs.job_id = gmd.batch_id and
638: jobs.status = 'Closed' and
639: jobs.source = 3

Line 697: gme_material_details dtl

693: led.Actual_Qty_Completed,
694: led.UOM_Code,
695: rates.Conversion_Rate,
696: rates.Sec_conversion_rate) var,
697: gme_material_details dtl
698: where
699: dtl.batch_id = var.job_id
700: AND dtl.line_type = 1
701: AND dtl.inventory_item_id = var.assembly_item_id

Line 922: GME_MATERIAL_DETAILS mtl_dtl,

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) */
925: jobs.Job_id,
926: jobs.job_type,

Line 939: GME_MATERIAL_DETAILS mtl_dtl

935: jobs.conversion_rate,
936: jobs.sec_conversion_rate
937: from
938: OPI_DBI_JOBS_F jobs,
939: GME_MATERIAL_DETAILS mtl_dtl
940: where
941: jobs.job_id = mtl_dtl.batch_id and
942: jobs.organization_id = mtl_dtl.organization_id and
943: mtl_dtl.line_type in (-1,1,2) and

Line 1346: GME_MATERIAL_DETAILS mtl_dtl

1342: mtl_dtl.Line_type,
1343: jobs.organization_id
1344: from
1345: OPI_DBI_JOBS_STG jobs,
1346: GME_MATERIAL_DETAILS mtl_dtl
1347: where
1348: jobs.job_id = mtl_dtl.batch_id and
1349: jobs.organization_id = mtl_dtl.organization_id and
1350: mtl_dtl.line_type in (-1,1,2) and

Line 1377: GME_MATERIAL_DETAILS mtl_dtl

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
1380: jobs.job_id = GTV.doc_id and
1381: (jobs.item_resource_id = to_char(GTV.inventory_item_id)

Line 1788: GME_MATERIAL_DETAILS MTL_DTL,

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) */
1791: jobs.Job_id,
1792: jobs.assembly_item_id,

Line 1804: GME_MATERIAL_DETAILS mtl_dtl

1800: mtl_dtl.line_type line_type,
1801: jobs.Organization_id
1802: from
1803: OPI_DBI_JOBS_F jobs,
1804: GME_MATERIAL_DETAILS mtl_dtl
1805: where
1806: jobs.source = 2 and
1807: jobs.line_type = 1 and
1808: jobs.job_id = mtl_dtl.batch_id and