APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_PLAN_BUCKETS

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

145: IS
146: CURSOR c1(p_plan_id NUMBER) IS
147: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
148: mpsd.period_start_date
149: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
150: WHERE mp.plan_id = p_plan_id
151: AND mtp.sr_tp_id = mp.organization_id
152: AND mtp.sr_instance_id = mp.sr_instance_id
153: AND mtp.partner_type = 3

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

204: IS
205: CURSOR c1(p_plan_id NUMBER) IS
206: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
207: mpsd.period_start_date, mpb.bucket_type
208: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
209: WHERE mp.plan_id = p_plan_id
210: AND mtp.sr_tp_id = mp.organization_id
211: AND mtp.sr_instance_id = mp.sr_instance_id
212: AND mtp.partner_type = 3

Line 922: msc_plan_buckets mpb,

918: to_number(null)
919: FROM msc_plans mp,
920: msc_plan_organizations mpo,
921: msc_demands msd,
922: msc_plan_buckets mpb,
923: msc_system_items msi,
924: msc_item_categories mic,
925: msc_trading_partners owning,
926: msc_period_start_dates mpsd

Line 1138: msc_plan_buckets mpb,

1134: to_number(null)
1135: FROM msc_plans mp,
1136: msc_plan_organizations mpo,
1137: msc_demands msd,
1138: msc_plan_buckets mpb,
1139: msc_system_items msi,
1140: msc_item_categories mic,
1141: msc_trading_partners owning,
1142: msc_period_start_dates mpsd

Line 1230: msc_plan_buckets mpb,

1226: to_number(null)
1227: FROM msc_plans mp,
1228: msc_plan_organizations mpo,
1229: msc_demands msd,
1230: msc_plan_buckets mpb,
1231: msc_system_items msi,
1232: msc_item_categories mic,
1233: msc_trading_partners owning
1234: --msc_period_start_dates mpsd

Line 1473: msc_plan_buckets mpb

1469: msc_system_items mis,
1470: msc_item_categories mic,
1471: msc_trading_partners mtp,
1472: msc_period_start_dates mpsd,
1473: msc_plan_buckets mpb
1474: WHERE mp.plan_id = p_plan_id
1475: AND mp.plan_id = mpo.plan_id
1476: AND mpo.plan_id = mbid.plan_id
1477: AND mpo.organization_id = mbid.organization_id

Line 2118: msc_trading_partners mtp, msc_period_start_dates mpsd, msc_plan_buckets mpb

2114: SYSDATE AS last_update_date,
2115: -1 AS last_updated_by,
2116: SYSDATE AS CREATION_DATE
2117: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2118: msc_trading_partners mtp, msc_period_start_dates mpsd, msc_plan_buckets mpb
2119: WHERE mp.plan_id = l_planlist(l_index)
2120: AND mp.plan_id = mpo.plan_id
2121: AND mpo.plan_id = mbid.plan_id
2122: AND mpo.organization_id = mbid.organization_id