[Home] [Help]
3617:
3618: --get the item description
3619: CURSOR itm_dtls_csr(p_inv_itm_id IN NUMBER, p_organization_id IN NUMBER) IS
3620: SELECT TL.DESCRIPTION DESCRIPTION
3621: FROM MTL_SYSTEM_ITEMS_TL TL
3622: WHERE TL.ORGANIZATION_ID = p_organization_id
3623: AND TL.INVENTORY_ITEM_ID = p_inv_itm_id
3624: AND TL.LANGUAGE = USERENV('LANG');
3625: