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.INV_UI_ITEM_LOVS dependencies on INV_UI_ITEM_LOVS

Line 1: PACKAGE BODY inv_ui_item_lovs AS

1: PACKAGE BODY inv_ui_item_lovs AS
2: /* $Header: INVITMLB.pls 120.38.12020000.5 2013/03/01 08:32:44 raminoch ship $ */
3:
4:
5: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

Line 8: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_UI_ITEM_LOVS';

4:
5: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
6: g_gtin_code_length NUMBER := 14;
7: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_UI_ITEM_LOVS';
9:
10: -- Name: GET_ITEM_LOV
11: -- Input parameters:
12: -- p_Organization_Id which restricts LOV SQL to current org

Line 741: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

737: l_code := SUBSTR(p_UOM_Code,1,INSTR(p_UOM_Code,'(')-1);
738: END IF;
739:
740: OPEN x_uoms FOR
741: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
742: p_Organization_Id,
743: p_Inventory_Item_Id)) uom_code_comp
744: , unit_of_measure
745: , description

Line 751: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

747: FROM mtl_item_uoms_view
748: WHERE organization_id = p_organization_id
749: AND inventory_item_id = p_inventory_item_id
750: AND uom_code LIKE (l_code)
751: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
752: p_Organization_Id,
753: p_Inventory_Item_Id)) asc, Upper(uom_code);
754: END get_uom_lov;
755:

Line 793: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

789: IF (p_item_id IS NOT NULL
790: AND p_item_id > 0
791: ) THEN
792: OPEN x_uoms FOR
793: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
794: p_organization_id,
795: Inventory_Item_Id)) uom_code_comp
796: , unit_of_measure
797: , description

Line 804: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

800: WHERE organization_id = p_organization_id
801: AND inventory_item_id(+) = p_item_id
802: AND NVL(uom_type, 3) = NVL(p_uom_type, 3)
803: AND uom_code LIKE (l_code)
804: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
805: p_organization_id,
806: Inventory_Item_Id)) asc, Upper(uom_code);
807: -- Bug 2192815
808: -- The following is commented out as this is part of INVRCVLB.pls now

Line 2544: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

2540: l_code := SUBSTR(p_UOM_Code,1,INSTR(p_UOM_Code,'(')-1);
2541: END IF;
2542:
2543: OPEN x_uoms FOR
2544: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
2545: p_Organization_Id,
2546: p_Inventory_Item_Id)) uom_code_comp
2547: , unit_of_measure
2548: , description

Line 2554: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

2550: FROM mtl_item_uoms_view
2551: WHERE organization_id = p_organization_id
2552: AND inventory_item_id = p_inventory_item_id
2553: AND uom_code LIKE (l_code)
2554: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
2555: p_Organization_Id,
2556: p_Inventory_Item_Id)) asc, Upper(uom_code);
2557: END get_phyinv_uom_lov;
2558:

Line 3112: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

3108:
3109: OPEN x_uoms FOR
3110: /* UOM LOV Enhancements */
3111: -- SELECT uom_code
3112: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
3113: p_organization_id,
3114: p_inventory_item_id)) uom_code_comp
3115: , unit_of_measure
3116: , description

Line 3122: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

3118: FROM mtl_item_uoms_view
3119: WHERE organization_id = p_organization_id
3120: AND inventory_item_id = p_inventory_item_id
3121: AND uom_code LIKE (l_code)
3122: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
3123: p_Organization_Id,
3124: p_Inventory_Item_Id)) asc, Upper(uom_code);
3125: -- ORDER BY UPPER(uom_code);
3126: END get_cyc_uom_lov;

Line 4175: SELECT DISTINCT (inv_ui_item_lovs.get_conversion_rate(wlc.uom_code,

4171: l_code := SUBSTR(p_UOM_Code,1,INSTR(p_UOM_Code,'(')-1);
4172: END IF;
4173:
4174: OPEN x_uoms FOR
4175: SELECT DISTINCT (inv_ui_item_lovs.get_conversion_rate(wlc.uom_code,
4176: p_Organization_Id,
4177: p_Inventory_Item_Id)) uom_code_comp
4178: , miuv.unit_of_measure
4179: , miuv.description

Line 4189: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(wlc.uom_code,

4185: AND miuv.organization_id = wlc.organization_id
4186: AND miuv.inventory_item_id = wlc.inventory_item_id
4187: AND miuv.uom_code = wlc.uom_code
4188: AND wlc.uom_code LIKE (l_code)
4189: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(wlc.uom_code,
4190: p_Organization_Id,
4191: p_Inventory_Item_Id)) asc, Upper(wlc.uom_code);
4192: END get_cont_uom_lov;
4193:

Line 6204: FROM (SELECT ( inv_ui_item_lovs.Get_conversion_rate(uom_code, p_organization_id,

6200: SELECT uom_code_comp,
6201: unit_of_measure,
6202: description,
6203: uom_class
6204: FROM (SELECT ( inv_ui_item_lovs.Get_conversion_rate(uom_code, p_organization_id,
6205: inventory_item_id,
6206: Nvl( p_fulfillment_base,'P'))) uom_code_comp,
6207: unit_of_measure,
6208: description,

Line 6218: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.Get_conversion_rate(Substr(uom_code_comp, 1,

6214: AND uom_code LIKE ( l_code ))
6215: WHERE ((Nvl(p_fulfillment_base,'P') = 'S'
6216: AND inv_convert.is_uom_in_same_class( Substr(uom_code_comp, 1, Instr(uom_code_comp, '(') - 1), p_organization_id , p_item_id , Nvl(p_fulfillment_base,'P')) = 'Y')
6217: OR (Nvl(p_fulfillment_base,'P') = 'P'))
6218: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.Get_conversion_rate(Substr(uom_code_comp, 1,
6219: Instr(uom_code_comp, '(') - 1),
6220: p_organization_id,
6221: p_item_id,
6222: Nvl( p_fulfillment_base,'P'))) ASC, Upper(Substr(uom_code_comp, 1, Instr(uom_code_comp, '(') - 1));

Line 6227: END inv_ui_item_lovs;

6223:
6224: END IF;
6225: END;
6226:
6227: END inv_ui_item_lovs;