APPS.MSC_X_WFNOTIFY_PKG dependencies on MSC_TRADING_PARTNERS

Line 109: msc_trading_partners part,

105: SELECT distinct pl.user_name
106: FROM msc_system_items msi,
107: msc_company_sites s,
108: msc_trading_partner_maps map,
109: msc_trading_partners part,
110: msc_planners pl
111: WHERE s.company_id = 1
112: AND s.company_site_id = p_company_site_id
113: AND map.map_type = 2

Line 143: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt

139: AND map1.company_key =p_oem_site_id
140: AND map1.map_type= 2
141: AND site.company_id = p_company_id
142: AND site.company_site_id = p_company_site_id
143: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt
144: where msi.plan_id = -1 --- Bug # 6242764
145: and msi.sr_instance_id = con.sr_instance_id
146: and msi.inventory_item_id = p_inventory_item_id
147: and mt.partner_id = map1.tp_key

Line 185: AND exists ( select 1 from msc_system_items msi,msc_trading_partners mt

181: AND map1.company_key =p_oem_id
182: AND map1.map_type= 2
183: AND con.partner_type = 1 --suplier
184: AND c.company_id = p_company_id
185: AND exists ( select 1 from msc_system_items msi,msc_trading_partners mt
186: where msi.plan_id = -1 --- Bug # 6242764
187: and msi.sr_instance_id = con.sr_instance_id
188: and msi.inventory_item_id = p_inventory_item_id
189: and mt.partner_id = map1.tp_key

Line 208: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt

204: AND map1.company_key =p_oem_id
205: AND map1.map_type= 2
206: AND con.partner_type = 2 --customer
207: AND c.company_id = p_company_id
208: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt
209: where msi.plan_id = -1 --- Bug # 6242764
210: and msi.sr_instance_id = con.sr_instance_id
211: and msi.inventory_item_id = p_inventory_item_id
212: and mt.partner_id = map1.tp_key

Line 561: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt

557: AND map1.company_key =decode(t_supplier_id(j),1,t_supplier_site_id(j),t_customer_site_id(j))
558: AND map1.map_type= 2
559: AND site.company_id = t_company_id(j)
560: AND site.company_site_id = t_company_site_id(j)
561: AND exists ( select 1 from msc_system_items msi, msc_trading_partners mt
562: where msi.plan_id = -1 --- Bug # 6242764
563: and msi.sr_instance_id = con.sr_instance_id
564: and msi.inventory_item_id = t_item_id(j)
565: and mt.partner_id = map1.tp_key

Line 730: msc_trading_partners mt

726: OR con.partner_type = 2) --customer
727: AND c.company_id = t_company_id(j)
728: AND exists ( SELECT 1
729: FROM msc_system_items msi,
730: msc_trading_partners mt
731: WHERE msi.plan_id = -1 --- Bug # 6242764
732: AND msi.sr_instance_id = con.sr_instance_id
733: AND msi.inventory_item_id = t_item_id(j)
734: AND mt.partner_id = map1.tp_key

Line 1382: msc_trading_partners p

1378: exists (select cs.company_site_id
1379: from msc_plan_organizations o,
1380: msc_company_sites cs,
1381: msc_trading_partner_maps m,
1382: msc_trading_partners p
1383: where o.plan_id = p_plan_id
1384: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)
1385: AND O.SR_INSTANCE_ID = NVL(p_sr_instance_id , O.SR_INSTANCE_ID)
1386: AND P.SR_TP_ID = O.ORGANIZATION_ID

Line 1512: msc_trading_partners p

1508: sd.publisher_site_id IN (select cs.company_site_id
1509: from msc_plan_organizations o,
1510: msc_company_sites cs,
1511: msc_trading_partner_maps m,
1512: msc_trading_partners p
1513: where o.plan_id = p_plan_id and
1514: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1515: p.sr_instance_id = nvl(p_sr_instance_id,
1516: o.sr_instance_id) and