368: p_i_cust_site_id IN NUMBER,
369: p_pub_id IN NUMBER,
370: p_i_pub_site_id IN NUMBER) IS
371: SELECT mis.uom_code
372: FROM msc_item_suppliers mis,
373: msc_trading_partner_maps map,
374: msc_trading_partners mtp,
375: msc_trading_partner_maps map1,
376: msc_company_relationships rel,
398: p_pub_site_id NUMBER,
399: p_supp_id NUMBER,
400: p_supp_site_id NUMBER) IS
401: SELECT mis.uom_code
402: FROM msc_item_suppliers mis,
403: msc_trading_partner_maps map,
404: msc_trading_partner_maps map1,
405: msc_trading_partner_maps map2,
406: msc_trading_partners mtp,