APPS.MSC_ANALYSIS_BUDGET dependencies on MSC_TRADING_PARTNERS

Line 66: FROM msc_trading_partners

62: l_target_service_level NUMBER;
63: BEGIN
64: SELECT service_level
65: INTO l_target_service_level
66: FROM msc_trading_partners
67: WHERE partner_type = 2
68: AND partner_id = customer_id;
69: RETURN l_target_service_level;
70: EXCEPTION WHEN OTHERS THEN RETURN NULL;

Line 143: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd

139: IS
140: CURSOR c1(p_plan_id NUMBER) IS
141: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
142: mpsd.period_start_date, mpb.bucket_type
143: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
144: WHERE mp.plan_id = p_plan_id
145: AND mtp.sr_tp_id = mp.organization_id
146: AND mtp.sr_instance_id = mp.sr_instance_id
147: AND mtp.partner_type = 3

Line 393: msc_trading_partners mtp, msc_plans mp

389: NULL AS week_nr, NULL AS period_start_date, NULL AS bucket_type, NVL(mbid.detail_level, DETAIL_LEVEL_PERIOD) AS detail_level,
390: SUM(nvl(mbid.inventory_value, 0)) AS achieved_budget_usd, NULL as delivered_quantity, 0 as required_quantity,
391: NULL AS target_sl, NULL AS num_target_sl, RECORD_BUDGET AS record_type
392: FROM msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
393: msc_trading_partners mtp, msc_plans mp
394: WHERE mbid.plan_id = p_plan_id
395: AND mbid.plan_id = mp.plan_id
396: AND mbid.plan_id = mis.plan_id
397: AND mbid.organization_id = mis.organization_id

Line 480: msc_item_categories mic, msc_trading_partners mtp

476: sum(nvl(msd.service_level, 50)) AS target_service_level,
477: count(*) AS num_target_service_level,
478: RECORD_SERVICE_LEVEL AS record_type
479: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,
480: msc_item_categories mic, msc_trading_partners mtp
481: WHERE mp.plan_id = p_plan_id
482: AND mp.plan_id = mpo.plan_id
483: AND mpo.plan_id = msd.plan_id
484: AND mpo.sr_instance_id = msd.sr_instance_id

Line 566: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp,

562: mic.sr_category_id AS sr_category_id, mic.category_name AS category_name,
563: mp.compile_designator AS plan_name,
564: mtp.organization_code AS org_name,
565: msi.item_name AS item_name, msd.customer_id AS partner_id
566: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp,
567: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
568: demands.customer_id, demands.demand_id
569: FROM msc_demands demands
570: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd,