APPS.MSC_X_CUST_FACING_RELEASE dependencies on MSC_TRADING_PARTNERS

Line 671: msc_trading_partners mtp,

667:
668: select mtil.sr_tp_id
669: into lv_sr_cust_id
670: from msc_tp_id_lid mtil,
671: msc_trading_partners mtp,
672: msc_trading_partners mtp1
673: where mtp.partner_type = 3
674: and mtp.sr_tp_id = l_cust_organization_id
675: and mtp.sr_instance_id = l_sr_instance_id

Line 672: msc_trading_partners mtp1

668: select mtil.sr_tp_id
669: into lv_sr_cust_id
670: from msc_tp_id_lid mtil,
671: msc_trading_partners mtp,
672: msc_trading_partners mtp1
673: where mtp.partner_type = 3
674: and mtp.sr_tp_id = l_cust_organization_id
675: and mtp.sr_instance_id = l_sr_instance_id
676: and mtp.modeled_customer_id = mtil.tp_id

Line 691: msc_trading_partners mtp

687: select mtsil.sr_tp_site_id
688: into lv_sr_cust_site_id
689: from msc_tp_site_id_lid mtsil,
690: msc_trading_partner_sites mtps,
691: msc_trading_partners mtp
692: where mtp.partner_type = 3
693: and mtp.sr_tp_id = l_cust_organization_id
694: and mtp.sr_instance_id = l_sr_instance_id
695: and mtps.PARTNER_SITE_ID = mtp.modeled_customer_site_id

Line 1019: from msc_trading_partners

1015:
1016: if (lv_ship_from_org_id is not null) then
1017: select organization_code
1018: into lv_supplier_site_name
1019: from msc_trading_partners
1020: where partner_type = 3
1021: and sr_instance_id = l_sr_instance_id
1022: and sr_tp_id = lv_ship_from_org_id;
1023: end if;