APPS.MSC_SDA_UTILS dependencies on MSC_TRADING_PARTNERS

Line 734: msc_trading_partners mtp,

730: to_number(null) inventory_item_id
731: from
732: --msc_region_locations mrl,
733: --msc_location_associations mla,
734: msc_trading_partners mtp,
735: msc_plan_organizations mpo,
736: msc_form_query mfq
737: --,msc_zone_regions mzr
738: where mfq.query_id = p_region_query_id

Line 749: --pabram..commented out --msc_location_associations, msc_trading_partners for testing,

745: and mpo.plan_id = p_plan_id
746: and mpo.sr_instance_id = mtp.sr_instance_id
747: and mpo.organization_id = mtp.sr_tp_id
748: and p_view_type = 1 --region list selected by user
749: --pabram..commented out --msc_location_associations, msc_trading_partners for testing,
750: --we need to enable this when these tables are flushed correctly
751: --6736491, need to add mrl back
752: union all
753: select distinct

Line 759: from msc_trading_partners mtp

755: mtp.sr_instance_id inst_id,
756: mtp.sr_tp_id org_id,
757: msc_get_name.org_code(mtp.sr_tp_id, mtp.sr_instance_id) org_code,
758: to_number(null) inventory_item_id
759: from msc_trading_partners mtp
760: where mtp.sr_tp_id = p_org_id
761: and mtp.sr_instance_id = p_inst_id
762: and mtp.partner_type = 3
763: and p_org_type = c_org_view

Line 877: from msc_trading_partners mtp,

873: mtp.sr_instance_id inst_id,
874: mtp.sr_tp_id org_id,
875: msc_get_name.org_code(mtp.sr_tp_id, mtp.sr_instance_id) org_code,
876: mtp.sr_tp_id sort_column
877: from msc_trading_partners mtp,
878: msc_analysis_query maq
879: where maq.query_id = p_query_id
880: and maq.row_index = p_row_index
881: and mtp.sr_instance_id = maq.inst_id