DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK dependencies on MSC_PLAN_BUCKETS

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