DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK dependencies on MSC_TRADING_PARTNERS

Line 105: FROM msc_trading_partners

101: l_target_service_level NUMBER;
102: BEGIN
103: SELECT service_level
104: INTO l_target_service_level
105: FROM msc_trading_partners
106: WHERE partner_type = 2
107: AND partner_id = customer_id;
108: RETURN l_target_service_level;
109: EXCEPTION WHEN OTHERS THEN RETURN NULL;

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

131:
132: CURSOR c1(p_plan_id NUMBER) IS
133: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
134: mpsd.period_start_date, mpb.bucket_type
135: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
136: WHERE mp.plan_id = p_plan_id
137: AND mtp.sr_tp_id = mp.organization_id
138: AND mtp.sr_instance_id = mp.sr_instance_id
139: AND mtp.partner_type = 3

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

481: mic.sr_category_id AS sr_category_id, mic.category_name AS category_name,
482: mp.compile_designator AS plan_name,
483: mtp.organization_code AS org_name,
484: msi.item_name AS item_name, cust.partner_id
485: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp, msc_trading_partners cust,
486: msc_safety_stocks mss,
487: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
488: demands.customer_id, demands.demand_id
489: FROM msc_demands demands

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

532: mic.sr_category_id AS sr_category_id, mic.category_name AS category_name,
533: mp.compile_designator AS plan_name,
534: mtp.organization_code AS org_name,
535: cust.partner_id, cust.partner_name, cust.customer_class_code, msi.item_name AS item_name
536: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp, msc_trading_partners cust,
537: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
538: demands.customer_id, demands.demand_id
539: FROM msc_demands demands
540: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd

Line 652: msc_trading_partners cust

648: cust.customer_class_code AS customer_class_code,
649: RECORD_SERVICE_LEVEL AS record_type
650: FROM msc_demands msd, msc_system_items msi,
651: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo,
652: msc_trading_partners cust
653: WHERE mp.plan_id = p_plan_id
654: AND msd.plan_id = msi.plan_id
655: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
656: AND msd.sr_instance_id = msi.sr_instance_id