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.24.12010000.2 2008/10/10 07:57:23 ksivasa ship $ */
3:
4:
5: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

Line 637: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

633: l_code := SUBSTR(p_UOM_Code,1,INSTR(p_UOM_Code,'(')-1);
634: END IF;
635:
636: OPEN x_uoms FOR
637: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
638: p_Organization_Id,
639: p_Inventory_Item_Id)) uom_code_comp
640: , unit_of_measure
641: , description

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

643: FROM mtl_item_uoms_view
644: WHERE organization_id = p_organization_id
645: AND inventory_item_id = p_inventory_item_id
646: AND uom_code LIKE (l_code)
647: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
648: p_Organization_Id,
649: p_Inventory_Item_Id)) asc, Upper(uom_code);
650: END get_uom_lov;
651:

Line 689: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

685: IF (p_item_id IS NOT NULL
686: AND p_item_id > 0
687: ) THEN
688: OPEN x_uoms FOR
689: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
690: p_organization_id,
691: Inventory_Item_Id)) uom_code_comp
692: , unit_of_measure
693: , description

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

696: WHERE organization_id = p_organization_id
697: AND inventory_item_id(+) = p_item_id
698: AND NVL(uom_type, 3) = NVL(p_uom_type, 3)
699: AND uom_code LIKE (l_code)
700: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
701: p_organization_id,
702: Inventory_Item_Id)) asc, Upper(uom_code);
703: -- Bug 2192815
704: -- The following is commented out as this is part of INVRCVLB.pls now

Line 2403: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

2399: l_code := SUBSTR(p_UOM_Code,1,INSTR(p_UOM_Code,'(')-1);
2400: END IF;
2401:
2402: OPEN x_uoms FOR
2403: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
2404: p_Organization_Id,
2405: p_Inventory_Item_Id)) uom_code_comp
2406: , unit_of_measure
2407: , description

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

2409: FROM mtl_item_uoms_view
2410: WHERE organization_id = p_organization_id
2411: AND inventory_item_id = p_inventory_item_id
2412: AND uom_code LIKE (l_code)
2413: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
2414: p_Organization_Id,
2415: p_Inventory_Item_Id)) asc, Upper(uom_code);
2416: END get_phyinv_uom_lov;
2417:

Line 2957: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,

2953:
2954: OPEN x_uoms FOR
2955: /* UOM LOV Enhancements */
2956: -- SELECT uom_code
2957: SELECT (inv_ui_item_lovs.get_conversion_rate(uom_code,
2958: p_organization_id,
2959: p_inventory_item_id)) uom_code_comp
2960: , unit_of_measure
2961: , description

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

2963: FROM mtl_item_uoms_view
2964: WHERE organization_id = p_organization_id
2965: AND inventory_item_id = p_inventory_item_id
2966: AND uom_code LIKE (l_code)
2967: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,
2968: p_Organization_Id,
2969: p_Inventory_Item_Id)) asc, Upper(uom_code);
2970: -- ORDER BY UPPER(uom_code);
2971: END get_cyc_uom_lov;

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

3924: l_code := SUBSTR(p_UOM_Code,1,INSTR(p_UOM_Code,'(')-1);
3925: END IF;
3926:
3927: OPEN x_uoms FOR
3928: SELECT DISTINCT (inv_ui_item_lovs.get_conversion_rate(wlc.uom_code,
3929: p_Organization_Id,
3930: p_Inventory_Item_Id)) uom_code_comp
3931: , miuv.unit_of_measure
3932: , miuv.description

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

3938: AND miuv.organization_id = wlc.organization_id
3939: AND miuv.inventory_item_id = wlc.inventory_item_id
3940: AND miuv.uom_code = wlc.uom_code
3941: AND wlc.uom_code LIKE (l_code)
3942: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(wlc.uom_code,
3943: p_Organization_Id,
3944: p_Inventory_Item_Id)) asc, Upper(wlc.uom_code);
3945: END get_cont_uom_lov;
3946:

Line 5778: END inv_ui_item_lovs;

5774: --dbms_output.put_line(l_sql_stmt1);
5775: OPEN x_items FOR l_sql_stmt1;
5776: END get_ostatus_items_lov;
5777:
5778: END inv_ui_item_lovs;