APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_PERIOD_START_DATES

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

159: IS
160: CURSOR c1(p_plan_id NUMBER) IS
161: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
162: mpsd.period_start_date
163: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
164: WHERE mp.plan_id = p_plan_id
165: AND mtp.sr_tp_id = mp.organization_id
166: AND mtp.sr_instance_id = mp.sr_instance_id
167: AND mtp.partner_type = 3

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

218: IS
219: CURSOR c1(p_plan_id NUMBER) IS
220: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
221: mpsd.period_start_date, mpb.bucket_type
222: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
223: WHERE mp.plan_id = p_plan_id
224: AND mtp.sr_tp_id = mp.organization_id
225: AND mtp.sr_instance_id = mp.sr_instance_id
226: AND mtp.partner_type = 3

Line 941: msc_period_start_dates mpsd

937: msc_plan_buckets mpb,
938: msc_system_items msi,
939: msc_item_categories mic,
940: msc_trading_partners owning,
941: msc_period_start_dates mpsd
942: WHERE mp.plan_id = p_plan_id
943: AND msd.plan_id = msi.plan_id
944: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
945: AND msd.sr_instance_id = msi.sr_instance_id

Line 1143: msc_period_start_dates mpsd

1139: msc_plan_buckets mpb,
1140: msc_system_items msi,
1141: msc_item_categories mic,
1142: msc_trading_partners owning,
1143: msc_period_start_dates mpsd
1144: WHERE mp.plan_id = p_plan_id
1145: AND msd.plan_id = msi.plan_id
1146: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
1147: AND msd.sr_instance_id = msi.sr_instance_id

Line 1360: msc_period_start_dates mpsd

1356: msc_plan_buckets mpb,
1357: msc_system_items msi,
1358: msc_item_categories mic,
1359: msc_trading_partners owning,
1360: msc_period_start_dates mpsd
1361: WHERE mp.plan_id = p_plan_id
1362: AND msd.plan_id = msi.plan_id
1363: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
1364: AND msd.sr_instance_id = msi.sr_instance_id

Line 1452: --msc_period_start_dates mpsd

1448: msc_plan_buckets mpb,
1449: msc_system_items msi,
1450: msc_item_categories mic,
1451: msc_trading_partners owning
1452: --msc_period_start_dates mpsd
1453: WHERE mp.plan_id = p_plan_id
1454: AND msd.plan_id = msi.plan_id
1455: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
1456: AND msd.sr_instance_id = msi.sr_instance_id

Line 1530: msc_period_start_dates mpsd,

1526: g_user_id,
1527: to_number(null)
1528: FROM msc_plans mp,
1529: msc_trading_partners owning,
1530: msc_period_start_dates mpsd,
1531: msc_demands msd,
1532: msc_system_items msi,
1533: msc_item_categories mic
1534: WHERE mp.plan_id = p_plan_id

Line 1798: msc_period_start_dates mpsd,

1794: msc_bis_inv_detail mbid,
1795: msc_system_items mis,
1796: msc_item_categories mic,
1797: msc_trading_partners mtp,
1798: msc_period_start_dates mpsd,
1799: msc_plan_buckets mpb
1800: WHERE mp.plan_id = p_plan_id
1801: AND mp.plan_id = mpo.plan_id
1802: AND mpo.plan_id = mbid.plan_id

Line 2533: msc_trading_partners mtp, msc_period_start_dates mpsd, msc_plan_buckets mpb

2529: SYSDATE AS last_update_date,
2530: -1 AS last_updated_by,
2531: SYSDATE AS CREATION_DATE
2532: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2533: msc_trading_partners mtp, msc_period_start_dates mpsd, msc_plan_buckets mpb
2534: WHERE mp.plan_id = l_planlist(l_index)
2535: AND mp.plan_id = mpo.plan_id
2536: AND mpo.plan_id = mbid.plan_id
2537: AND mpo.organization_id = mbid.organization_id