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.JMF_SHIKYU_RPT_UTIL dependencies on MTL_UNITS_OF_MEASURE_TL

Line 296: l_uom_code mtl_units_of_measure_tl.uom_code%TYPE; -- or mtl_units_of_measure_tl.uom_code???

292: -- PRE-COND :
293: -- EXCEPTIONS:
294: --========================================================================
295: FUNCTION uom_to_code(p_unit_of_measure IN VARCHAR2) RETURN VARCHAR2 IS
296: l_uom_code mtl_units_of_measure_tl.uom_code%TYPE; -- or mtl_units_of_measure_tl.uom_code???
297: BEGIN
298: --get the uom_code
299: BEGIN
300: -- get l_from_unit_name

Line 303: FROM MTL_UNITS_OF_MEASURE_TL

299: BEGIN
300: -- get l_from_unit_name
301: SELECT UOM_CODE
302: INTO l_uom_code
303: FROM MTL_UNITS_OF_MEASURE_TL
304: WHERE LANGUAGE = USERENV('LANG')
305: AND UNIT_OF_MEASURE = p_unit_of_measure;
306:
307:

Line 313: FROM MTL_UNITS_OF_MEASURE_TL

309: WHEN no_data_found THEN
310: -- get l_from_unit_name
311: SELECT UOM_CODE
312: INTO l_uom_code
313: FROM MTL_UNITS_OF_MEASURE_TL
314: WHERE LANGUAGE = 'US'
315: AND UNIT_OF_MEASURE = p_unit_of_measure;
316: END;
317:

Line 362: l_current_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???

358: , p_current_uom_code IN VARCHAR2
359: )
360: RETURN VARCHAR2
361: IS
362: l_current_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
363: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
364: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE; -- or mtl_units_of_measure_tl.uom_code???
365: BEGIN
366:

Line 363: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???

359: )
360: RETURN VARCHAR2
361: IS
362: l_current_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
363: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
364: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE; -- or mtl_units_of_measure_tl.uom_code???
365: BEGIN
366:
367: IF p_item_id IS NULL

Line 364: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE; -- or mtl_units_of_measure_tl.uom_code???

360: RETURN VARCHAR2
361: IS
362: l_current_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
363: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
364: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE; -- or mtl_units_of_measure_tl.uom_code???
365: BEGIN
366:
367: IF p_item_id IS NULL
368: THEN

Line 410: l_current_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???

406: , p_current_qty IN NUMBER
407: )
408: RETURN NUMBER
409: IS
410: l_current_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
411: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
412: l_primary_quantity NUMBER;
413: BEGIN
414: --get the current unit of measure from the given uom_code;

Line 411: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???

407: )
408: RETURN NUMBER
409: IS
410: l_current_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
411: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE; -- or mtl_units_of_measure_tl.uom_code???
412: l_primary_quantity NUMBER;
413: BEGIN
414: --get the current unit of measure from the given uom_code;
415: SELECT unit_of_measure

Line 445: -- PARAMETERS: p_from_unit the 3-character UOM_CODE of INV.MTL_UNITS_OF_MEASURE_TL

441: END get_item_primary_quantity;
442:
443: --========================================================================
444: -- FUNCTION : po_uom_convert_p PUBLIC
445: -- PARAMETERS: p_from_unit the 3-character UOM_CODE of INV.MTL_UNITS_OF_MEASURE_TL
446: -- : p_to_unit the 3-character UOM_CODE of INV.MTL_UNITS_OF_MEASURE_TL
447: -- : p_item_id the item id
448: -- RETURN :
449: -- Created a function po_uom_convert_p which is pure function to be used in

Line 446: -- : p_to_unit the 3-character UOM_CODE of INV.MTL_UNITS_OF_MEASURE_TL

442:
443: --========================================================================
444: -- FUNCTION : po_uom_convert_p PUBLIC
445: -- PARAMETERS: p_from_unit the 3-character UOM_CODE of INV.MTL_UNITS_OF_MEASURE_TL
446: -- : p_to_unit the 3-character UOM_CODE of INV.MTL_UNITS_OF_MEASURE_TL
447: -- : p_item_id the item id
448: -- RETURN :
449: -- Created a function po_uom_convert_p which is pure function to be used in
450: -- the where and select clauses of a SQL

Line 462: l_from_unit_name MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;

458: , p_item_id IN NUMBER
459: )
460: RETURN NUMBER
461: IS
462: l_from_unit_name MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
463: l_to_unit_name MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
464: BEGIN
465: BEGIN
466: -- get l_from_unit_name

Line 463: l_to_unit_name MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;

459: )
460: RETURN NUMBER
461: IS
462: l_from_unit_name MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
463: l_to_unit_name MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
464: BEGIN
465: BEGIN
466: -- get l_from_unit_name
467: SELECT UNIT_OF_MEASURE

Line 469: FROM MTL_UNITS_OF_MEASURE_TL

465: BEGIN
466: -- get l_from_unit_name
467: SELECT UNIT_OF_MEASURE
468: INTO l_from_unit_name
469: FROM MTL_UNITS_OF_MEASURE_TL
470: WHERE LANGUAGE = USERENV('LANG')
471: AND UOM_CODE = p_from_unit;
472: -- get l_to_unit_name
473: SELECT UNIT_OF_MEASURE

Line 475: FROM MTL_UNITS_OF_MEASURE_TL

471: AND UOM_CODE = p_from_unit;
472: -- get l_to_unit_name
473: SELECT UNIT_OF_MEASURE
474: INTO l_to_unit_name
475: FROM MTL_UNITS_OF_MEASURE_TL
476: WHERE LANGUAGE = USERENV('LANG')
477: AND UOM_CODE = p_to_unit;
478:
479:

Line 485: FROM MTL_UNITS_OF_MEASURE_TL

481: WHEN no_data_found THEN
482: -- get l_from_unit_name
483: SELECT UNIT_OF_MEASURE
484: INTO l_from_unit_name
485: FROM MTL_UNITS_OF_MEASURE_TL
486: WHERE LANGUAGE = 'US'
487: AND UOM_CODE = p_from_unit;
488: -- get l_to_unit_name
489: SELECT UNIT_OF_MEASURE

Line 491: FROM MTL_UNITS_OF_MEASURE_TL

487: AND UOM_CODE = p_from_unit;
488: -- get l_to_unit_name
489: SELECT UNIT_OF_MEASURE
490: INTO l_to_unit_name
491: FROM MTL_UNITS_OF_MEASURE_TL
492: WHERE LANGUAGE = 'US'
493: AND UOM_CODE = p_to_unit;
494: END;
495: --get the current unit of measure from the given uom_code;