APPS.MSC_SDA_UTILS dependencies on MSC_TRADING_PARTNERS

Line 369: msc_trading_partners mtp,

365: to_number(null) inventory_item_id
366: from
367: --msc_region_locations mrl,
368: --msc_location_associations mla,
369: msc_trading_partners mtp,
370: msc_plan_organizations mpo,
371: msc_form_query mfq
372: --,msc_zone_regions mzr
373: where mfq.query_id = p_region_query_id

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

380: and mpo.plan_id = p_plan_id
381: and mpo.sr_instance_id = mtp.sr_instance_id
382: and mpo.organization_id = mtp.sr_tp_id
383: and p_view_type = 1 --region list selected by user
384: --pabram..commented out --msc_location_associations, msc_trading_partners for testing,
385: --we need to enable this when these tables are flushed correctly
386: --6736491, need to add mrl back
387: union all
388: select distinct

Line 394: from msc_trading_partners mtp

390: mtp.sr_instance_id inst_id,
391: mtp.sr_tp_id org_id,
392: msc_get_name.org_code(mtp.sr_tp_id, mtp.sr_instance_id) org_code,
393: to_number(null) inventory_item_id
394: from msc_trading_partners mtp
395: where mtp.sr_tp_id = p_org_id
396: and mtp.sr_instance_id = p_inst_id
397: and mtp.partner_type = 3
398: and p_org_type = c_org_view

Line 512: from msc_trading_partners mtp,

508: mtp.sr_instance_id inst_id,
509: mtp.sr_tp_id org_id,
510: msc_get_name.org_code(mtp.sr_tp_id, mtp.sr_instance_id) org_code,
511: mtp.sr_tp_id sort_column
512: from msc_trading_partners mtp,
513: msc_analysis_query maq
514: where maq.query_id = p_query_id
515: and maq.row_index = p_row_index
516: and mtp.sr_instance_id = maq.inst_id