34452:
34453: UPDATE MSC_ST_SUPPLIES t1
34454: SET PLANNING_PARTNER_SITE_ID =
34455: (SELECT mtps.sr_tp_site_id
34456: FROM msc_trading_partner_sites mtps
34457: WHERE mtps.partner_type = G_VENDOR
34458: AND mtps.sr_instance_id = v_instance_id
34459: AND mtps.tp_site_code = PLANNING_PARTNER_SITE_CODE
34460: AND rownum =1)
34503:
34504: UPDATE MSC_ST_SUPPLIES t1
34505: SET OWNING_PARTNER_SITE_ID =
34506: (SELECT mtps.sr_tp_site_id
34507: FROM msc_trading_partner_sites mtps
34508: WHERE mtps.partner_type = G_VENDOR
34509: AND mtps.sr_instance_id = v_instance_id
34510: AND mtps.tp_site_code = OWNING_PARTNER_SITE_CODE
34511: AND rownum =1)