DBA Data[Home] [Help]

APPS.MSC_X_UTIL dependencies on MSC_COMPANY_RELATIONSHIPS

Line 537: msc_company_relationships rels

533: l_tp_customer_id
534: FROM
535: msc_tp_id_lid tpl,
536: msc_trading_partner_maps map,
537: msc_company_relationships rels
538: WHERE tpl.tp_id = map.tp_key
539: and tpl.partner_type = 2
540: and tpl.sr_company_id = -1
541: and tpl.sr_instance_id = l_sr_instance_id

Line 782: msc_company_relationships rels

778: SELECT map.tp_key INTO
779: l_tp_supplier_id
780: FROM
781: msc_trading_partner_maps map,
782: msc_company_relationships rels
783: WHERE map.map_type = 1
784: and map.company_key = rels.relationship_id
785: and rels.object_id = l_supplier_id
786: and rels.subject_id = l_company_id

Line 991: msc_company_relationships cr

987: --dbms_output.put_line(' Inside SCE TO APS ' );
988: SELECT map.tp_key
989: INTO aps_partner_id
990: FROM msc_trading_partner_maps map,
991: msc_company_relationships cr
992: WHERE map.map_type = G_COMPANY_MAPPING
993: AND cr.object_id = p_sce_company_id
994: AND map.company_key = cr.relationship_id
995: AND cr.relationship_type = p_relationship_type