15: CURSOR GET_ITEM_DISPLAY_NAME_CUR IS
16: SELECT
17: CONCATENATED_SEGMENTS
18: FROM
19: MTL_SYSTEM_ITEMS_VL
20: WHERE
21: INVENTORY_ITEM_ID = P_ITEM_ID;
22:
23: --This variable would hold the item display name.
72: CURSOR GET_ITEM_DESCRIPTION_CUR IS
73: SELECT
74: DESCRIPTION
75: FROM
76: MTL_SYSTEM_ITEMS_VL
77: WHERE
78: INVENTORY_ITEM_ID = P_ITEM_ID;
79:
80: --This variable would hold the item description.
707: L_RETURN_VALUE NUMBER;
708: BEGIN
709:
710: SELECT PRIMARY_UOM_CODE INTO L_ITEM_UOM
711: FROM MTL_SYSTEM_ITEMS
712: WHERE INVENTORY_ITEM_ID = P_ITEM_ID
713: AND ORGANIZATION_ID = NVL(P_ORGANIZATION_ID, ORGANIZATION_ID)
714: AND ROWNUM =1;
715: