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.GME_MOBILE_LOVS dependencies on MTL_RSV_QUANTITIES_TEMP

Line 2463: mtl_rsv_quantities_temp t

2459: msi.description,
2460: NVL(msi.locator_type, 1),
2461: t.atr
2462: FROM mtl_secondary_inventories msi,
2463: mtl_rsv_quantities_temp t
2464: WHERE node_level = 4
2465: AND t.organization_id = p_organization_id
2466: AND t.inventory_item_id = p_item_id
2467: AND nvl(t.revision,1) = nvl(p_revision, 1)

Line 2776: mtl_rsv_quantities_temp t

2772: a.description,
2773: a.inventory_location_id,
2774: ROUND(SUM(atr),4) atr
2775: FROM wms_item_locations_kfv a,
2776: mtl_rsv_quantities_temp t
2777: WHERE ((t.node_level = 4
2778: AND t.subinventory_code not in (select subinventory_code from
2779: mtl_rsv_quantities_temp where node_level = 5)) OR
2780: (t.node_level = 5))

Line 2779: mtl_rsv_quantities_temp where node_level = 5)) OR

2775: FROM wms_item_locations_kfv a,
2776: mtl_rsv_quantities_temp t
2777: WHERE ((t.node_level = 4
2778: AND t.subinventory_code not in (select subinventory_code from
2779: mtl_rsv_quantities_temp where node_level = 5)) OR
2780: (t.node_level = 5))
2781: AND t.organization_id = p_organization_id
2782: AND t.inventory_item_id = p_item_id
2783: AND nvl(t.revision, 1) = nvl(p_revision, 1)

Line 3232: FROM mtl_rsv_quantities_temp t

3228: ---decode(t.node_level,4,'',5,rtrim(substr(INV_UTILITIES.get_conc_segments(organization_id, locator_id),1,255)),'') locator,
3229: ROUND(SUM(atr),4) atr,
3230: grade_code
3231: ---locator_id
3232: FROM mtl_rsv_quantities_temp t
3233: WHERE ((t.node_level = 4
3234: AND subinventory_code not in (select subinventory_code from
3235: mtl_rsv_quantities_temp where node_level = 5)) OR
3236: (t.node_level = 5))

Line 3235: mtl_rsv_quantities_temp where node_level = 5)) OR

3231: ---locator_id
3232: FROM mtl_rsv_quantities_temp t
3233: WHERE ((t.node_level = 4
3234: AND subinventory_code not in (select subinventory_code from
3235: mtl_rsv_quantities_temp where node_level = 5)) OR
3236: (t.node_level = 5))
3237: AND t.organization_id = p_organization_id
3238: AND t.inventory_item_id = p_item_id
3239: AND nvl(t.revision, 1) = nvl(p_revision, 1)