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.OZF_SD_REQUEST_PUB dependencies on MTL_ITEM_UOMS_VIEW

Line 396: FROM mtl_item_uoms_view

392: CURSOR c_item_uom(p_item_uom IN VARCHAR2
393: ,p_inventory_item_id IN NUMBER
394: ,p_org_id IN NUMBER)IS
395: SELECT uom_code
396: FROM mtl_item_uoms_view
397: WHERE organization_id = p_org_id
398: AND inventory_item_id = p_inventory_item_id
399: AND uom_code = p_item_uom;
400:

Line 406: FROM mtl_item_uoms_view a,

402: CURSOR c_category_UOM_Y(p_parent_id IN NUMBER
403: ,p_org_id IN NUMBER
404: ,p_uom_code IN VARCHAR2) IS
405: SELECT DISTINCT a.uom_code
406: FROM mtl_item_uoms_view a,
407: (SELECT inventory_item_id
408: FROM mtl_item_categories
409: WHERE category_id IN(SELECT child_id
410: FROM eni_denorm_hierarchies

Line 1298: FROM mtl_item_uoms_view

1294: AND uom_code = p_item_uom;
1295: */
1296: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1297: SELECT uom_code
1298: FROM mtl_item_uoms_view
1299: WHERE organization_id = p_org_id
1300: AND inventory_item_id = p_inventory_item_id
1301: AND uom_code = p_item_uom;
1302: