685: --INVCONV
686: CURSOR c_get_item_no (p_inventory_item_id IN NUMBER, p_organization_id IN NUMBER) IS
687: SELECT concatenated_segments item_number,
688: description item_description
689: FROM mtl_system_items_b_kfv
690: WHERE inventory_item_id = p_inventory_item_id
691: AND organization_id = p_organization_id;
692:
693:
1573: wsh_delivery_details wdd,
1574: wsh_new_deliveries wnd,
1575: wsh_delivery_assignments wda,
1576: mtl_parameters ship_from_org,
1577: mtl_system_items_b_kfv msi, --INVCONV
1578: hz_cust_accounts c,
1579: hz_cust_site_uses_all s,
1580: hz_cust_acct_sites_all a,
1581: hz_parties pr
1656: wsh_delivery_details wdd,
1657: wsh_new_deliveries wnd,
1658: wsh_delivery_assignments wda,
1659: mtl_parameters ship_from_org,
1660: mtl_system_items_b_kfv msi, --INVCONV
1661: hz_cust_accounts c,
1662: hz_cust_site_uses_all s,
1663: hz_cust_acct_sites_all a,
1664: hz_parties pr
1718: FROM
1719: oe_order_headers_all h,
1720: oe_order_lines_all l,
1721: mtl_parameters ship_from_org,
1722: mtl_system_items_b_kfv msi, --INVCONV
1723: hz_cust_accounts c,
1724: hz_cust_site_uses_all s,
1725: hz_cust_acct_sites_all a,
1726: hz_parties pr