eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_PERIOD_START_DATES

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 926: msc_period_start_dates mpsd

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
927: WHERE mp.plan_id = p_plan_id
928: AND msd.plan_id = msi.plan_id
929: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
930: AND msd.sr_instance_id = msi.sr_instance_id

Line 1142: msc_period_start_dates mpsd

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
1143: WHERE mp.plan_id = p_plan_id
1144: AND msd.plan_id = msi.plan_id
1145: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
1146: AND msd.sr_instance_id = msi.sr_instance_id

Line 1234: --msc_period_start_dates mpsd

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
1235: WHERE mp.plan_id = p_plan_id
1236: AND msd.plan_id = msi.plan_id
1237: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
1238: AND msd.sr_instance_id = msi.sr_instance_id

Line 1312: msc_period_start_dates mpsd,

1308: g_user_id,
1309: to_number(null)
1310: FROM msc_plans mp,
1311: msc_trading_partners owning,
1312: msc_period_start_dates mpsd,
1313: msc_demands msd,
1314: msc_system_items msi,
1315: msc_item_categories mic
1316: WHERE mp.plan_id = p_plan_id

Line 1472: msc_period_start_dates mpsd,

1468: msc_bis_inv_detail mbid,
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

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