596: IF publisher_is_supplier%ISOPEN THEN
597: CLOSE publisher_is_supplier;
598: END IF;
599: --If the publisher is not the OEM and the order type is order forecast
600: --obtain the uom from MSC_ITEM_CUSTOMERS, since the publisher is usually
601: --the customer
602: ELSIF (v_pub_id <> 1) AND (v_i_order_type(cnt) = 2) THEN
603: BEGIN
604: SELECT mic.uom_code
602: ELSIF (v_pub_id <> 1) AND (v_i_order_type(cnt) = 2) THEN
603: BEGIN
604: SELECT mic.uom_code
605: INTO l_primary_uom
606: FROM msc_item_customers mic,
607: msc_trading_partner_maps map,
608: msc_trading_partner_maps map1,
609: msc_company_relationships r
610: WHERE mic.inventory_item_id = v_i_item_id(cnt)
673: ELSE
674: BEGIN
675: SELECT mic.uom_code
676: INTO l_tp_uom
677: FROM msc_item_customers mic,
678: msc_trading_partner_maps map,
679: msc_trading_partner_maps map1,
680: msc_company_relationships r
681: WHERE mic.inventory_item_id = v_i_item_id(cnt)