DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_TRADING_PARTNER_SITES

Line 34456: FROM msc_trading_partner_sites mtps

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)

Line 34507: FROM msc_trading_partner_sites mtps

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)