[Home] [Help]
42: FROM msc_sup_dem_entries_v sd,
43: msc_trading_partner_maps map1,
44: msc_trading_partners tp,
45: msc_system_items item,
46: msc_company_relationships cr,
47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,
49: msc_item_suppliers mis,
50: msc_trading_partners tp2,
119: msc_trading_partner_maps map1,
120: msc_trading_partners tp,
121: msc_system_items item,
122: MSC_CAL_WEEK_START_DATES mcd,
123: msc_company_relationships cr,
124: msc_trading_partner_maps map2,
125: msc_trading_partner_maps map3,
126: msc_item_suppliers mis,
127: msc_trading_partners tp2,
203: msc_trading_partner_maps map1,
204: msc_trading_partners tp,
205: msc_system_items item,
206: MSC_PERIOD_START_DATES mpd,
207: msc_company_relationships cr,
208: msc_trading_partner_maps map2,
209: msc_trading_partner_maps map3,
210: msc_item_suppliers mis,
211: msc_trading_partners tp2,
455: BEGIN
456: SELECT distinct c.company_id
457: INTO l_map_supplier_id
458: FROM msc_trading_partner_maps map1,
459: msc_company_relationships rel,
460: msc_companies c,
461: msc_trading_partners tp
462: WHERE rel.relationship_type =2 AND --supplier
463: rel.object_id = c.company_id AND
649: begin
650: SELECT distinct tp.partner_id
651: INTO l_aps_supplier_id
652: FROM msc_trading_partner_maps map1,
653: msc_company_relationships rel,
654: msc_item_suppliers sup,
655: msc_trading_partners tp
656: WHERE rel.relationship_type =2 AND --supplier
657: rel.object_id = l_sce_supplier_id AND
712: BEGIN
713: SELECT distinct c.company_id
714: INTO l_map_supplier_id
715: FROM msc_trading_partner_maps map1,
716: msc_company_relationships rel,
717: msc_companies c,
718: msc_trading_partners tp
719: WHERE rel.relationship_type =2 AND --supplier
720: rel.object_id = c.company_id AND