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.

[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on MTL_RSV_QUANTITIES_TEMP

Line 2490: mtl_rsv_quantities_temp t

2486: msi.description,
2487: NVL(msi.locator_type, 1),
2488: t.atr
2489: FROM mtl_secondary_inventories msi,
2490: mtl_rsv_quantities_temp t
2491: WHERE node_level = 4
2492: AND t.organization_id = p_organization_id
2493: AND t.inventory_item_id = p_item_id
2494: AND nvl(t.revision,1) = nvl(p_revision, 1)

Line 2803: mtl_rsv_quantities_temp t

2799: a.description,
2800: a.inventory_location_id,
2801: ROUND(SUM(atr),4) atr
2802: FROM wms_item_locations_kfv a,
2803: mtl_rsv_quantities_temp t
2804: WHERE ((t.node_level = 4
2805: AND t.subinventory_code not in (select subinventory_code from
2806: mtl_rsv_quantities_temp where node_level = 5)) OR
2807: (t.node_level = 5))

Line 2806: mtl_rsv_quantities_temp where node_level = 5)) OR

2802: FROM wms_item_locations_kfv a,
2803: mtl_rsv_quantities_temp t
2804: WHERE ((t.node_level = 4
2805: AND t.subinventory_code not in (select subinventory_code from
2806: mtl_rsv_quantities_temp where node_level = 5)) OR
2807: (t.node_level = 5))
2808: AND t.organization_id = p_organization_id
2809: AND t.inventory_item_id = p_item_id
2810: AND nvl(t.revision, 1) = nvl(p_revision, 1)

Line 3316: FROM mtl_rsv_quantities_temp t

3312: ---decode(t.node_level,4,'',5,rtrim(substr(INV_UTILITIES.get_conc_segments(organization_id, locator_id),1,255)),'') locator,
3313: ROUND(SUM(atr),4) atr,
3314: grade_code
3315: ---locator_id
3316: FROM mtl_rsv_quantities_temp t
3317: WHERE ((t.node_level = 4
3318: AND subinventory_code not in (select subinventory_code from
3319: mtl_rsv_quantities_temp where node_level = 5)) OR
3320: (t.node_level = 5))

Line 3319: mtl_rsv_quantities_temp where node_level = 5)) OR

3315: ---locator_id
3316: FROM mtl_rsv_quantities_temp t
3317: WHERE ((t.node_level = 4
3318: AND subinventory_code not in (select subinventory_code from
3319: mtl_rsv_quantities_temp where node_level = 5)) OR
3320: (t.node_level = 5))
3321: AND t.organization_id = p_organization_id
3322: AND t.inventory_item_id = p_item_id
3323: AND nvl(t.revision, 1) = nvl(p_revision, 1)