APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_PLAN_BUCKETS

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 937: msc_plan_buckets mpb,

933: to_number(null)
934: FROM msc_plans mp,
935: msc_plan_organizations mpo,
936: msc_demands msd,
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

Line 1139: msc_plan_buckets mpb,

1135: to_number(null)
1136: FROM msc_plans mp,
1137: msc_plan_organizations mpo,
1138: msc_demands msd,
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

Line 1356: msc_plan_buckets mpb,

1352: to_number(null)
1353: FROM msc_plans mp,
1354: msc_plan_organizations mpo,
1355: msc_demands msd,
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

Line 1448: msc_plan_buckets mpb,

1444: to_number(null)
1445: FROM msc_plans mp,
1446: msc_plan_organizations mpo,
1447: msc_demands msd,
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

Line 1799: msc_plan_buckets mpb

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
1803: AND mpo.organization_id = mbid.organization_id

Line 2048: msc_plan_buckets mpb

2044: NULL AS customer_class_code,
2045: RECORD_SAFETY_STOCK AS record_type
2046: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
2047: msc_system_items msi, msc_item_categories mic,
2048: msc_plan_buckets mpb
2049: WHERE mss.sr_instance_id = msi.sr_instance_id
2050: AND mss.plan_id = msi.plan_id
2051: AND mss.organization_id = msi.organization_id
2052: AND mss.inventory_item_id = msi.inventory_item_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