APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on MSC_TRADING_PARTNERS

Line 3786: ' msc_trading_partners mtp ' ||

3782: ' from (select distinct ebs_base_model_code, ebs_base_model_sr_pk from msd_spf_model_orgs) msmo, ' ||
3783: ' ' || g_schema || '.t_ep_spf_base_model tesbm, ' || g_schema || '.t_ep_spf tes, ' ||
3784: ' ' || g_schema || '.t_ep_spf_levels tesl, ' || g_schema || '.t_ep_spf_members tesm, ' ||
3785: ' ' || g_schema || '.t_ep_organization teo, ' || g_schema || '.t_ep_spf_demand_type tesdt, '||
3786: ' msc_trading_partners mtp ' ||
3787: ' where tesbm.t_ep_spf_base_model_code = msmo.ebs_base_model_code ' ||
3788: ' and tes.t_ep_spf_base_model_id = tesbm.t_ep_spf_base_model_id ' ||
3789: ' and tesdt.t_ep_spf_demand_type_code = ''SPF-BM'' ' ||
3790: ' and tes.t_ep_spf_demand_type_id = tesdt.t_ep_spf_demand_type_id ' ||

Line 4154: SET dm_org_sr_pk = NVL((SELECT sr_tp_id FROM msc_trading_partners mtp

4150:
4151: msd_dem_common_utilities.log_message ('Update Source Organization Id...');
4152: msd_dem_common_utilities.log_debug('Update DM_ORG_SR_PK Query Start Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4153: UPDATE msd_spf_st_spare_usage su
4154: SET dm_org_sr_pk = NVL((SELECT sr_tp_id FROM msc_trading_partners mtp
4155: WHERE mtp.sr_instance_id = p_sr_instance_id
4156: AND mtp.partner_type = 3
4157: AND mtp.organization_code = su.dm_org_code), su.dm_org_sr_pk);
4158: var_row_count := SQL%ROWCOUNT;