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.GMF_UTILITIES_GRP dependencies on MTL_ITEM_FLEXFIELDS

Line 322: CURSOR cur_item_number (cp_inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE,

318: ==========================================================*/
319: FUNCTION get_item_number (p_inventory_item_id IN NUMBER,
320: p_organization_id IN NUMBER) RETURN VARCHAR2 IS
321:
322: CURSOR cur_item_number (cp_inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE,
323: cp_organization_id mtl_item_flexfields.organization_id%TYPE) IS
324: SELECT item_number FROM mtl_item_flexfields
325: WHERE inventory_item_id = cp_inventory_item_id
326: AND organization_id = cp_organization_id;

Line 323: cp_organization_id mtl_item_flexfields.organization_id%TYPE) IS

319: FUNCTION get_item_number (p_inventory_item_id IN NUMBER,
320: p_organization_id IN NUMBER) RETURN VARCHAR2 IS
321:
322: CURSOR cur_item_number (cp_inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE,
323: cp_organization_id mtl_item_flexfields.organization_id%TYPE) IS
324: SELECT item_number FROM mtl_item_flexfields
325: WHERE inventory_item_id = cp_inventory_item_id
326: AND organization_id = cp_organization_id;
327:

Line 324: SELECT item_number FROM mtl_item_flexfields

320: p_organization_id IN NUMBER) RETURN VARCHAR2 IS
321:
322: CURSOR cur_item_number (cp_inventory_item_id mtl_item_flexfields.inventory_item_id%TYPE,
323: cp_organization_id mtl_item_flexfields.organization_id%TYPE) IS
324: SELECT item_number FROM mtl_item_flexfields
325: WHERE inventory_item_id = cp_inventory_item_id
326: AND organization_id = cp_organization_id;
327:
328: l_item_number VARCHAR2(2000);