[Home] [Help]
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;
333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;
334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
335: l_item_id msc_sup_dem_entries.inventory_item_id%type;
336: l_item_name msc_items.item_name%type;
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
464: rel.subject_id = 1 AND --other company (OEM)
484: BEGIN
485: SELECT distinct s.company_site_id
486: INTO l_map_supplier_site_id
487: FROM msc_trading_partner_maps map1,
488: msc_companies c,
489: msc_company_sites s,
490: msc_trading_partners tp,
491: msc_trading_partner_sites tps
492: WHERE map1.map_type = 3 AND
681: begin
682: SELECT distinct tps.partner_site_id
683: INTO l_aps_supplier_site_id
684: FROM msc_trading_partner_maps map1,
685: msc_companies c,
686: msc_company_sites s,
687: msc_trading_partners tp,
688: msc_trading_partner_sites tps
689: WHERE map1.map_type = 3 AND
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
721: rel.subject_id = 1 AND --other company (OEM)
739: Begin
740: SELECT distinct s.company_site_id
741: INTO l_map_supplier_site_id
742: FROM msc_trading_partner_maps map1,
743: msc_companies c,
744: msc_company_sites s,
745: msc_trading_partners tp,
746: msc_trading_partner_sites tps
747: WHERE map1.map_type = 3 AND