APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_BIS_PERIODS

Line 1049: msc_bis_periods msbp

1045: msc_plan_organizations mpo,
1046: msc_demands msd,
1047: msc_system_items msi,
1048: msc_item_categories mic,
1049: msc_bis_periods msbp
1050: WHERE mp.plan_id = p_plan_id
1051: AND mp.plan_id = mpo.plan_id
1052: AND msd.organization_id = mpo.organization_id
1053: AND msd.sr_instance_id = mpo.sr_instance_id

Line 1391: msc_bis_periods msbp

1387: msc_plan_organizations mpo,
1388: msc_demands msd,
1389: msc_system_items msi,
1390: msc_item_categories mic,
1391: msc_bis_periods msbp
1392: WHERE mp.plan_id = p_plan_id
1393: AND mp.plan_id = mpo.plan_id
1394: AND msd.organization_id = mpo.organization_id
1395: AND msd.sr_instance_id = mpo.sr_instance_id

Line 1557: msc_bis_periods mpsd

1553: msc_plan_organizations mpo,
1554: msc_bis_inv_detail mbid,
1555: msc_system_items mis,
1556: msc_item_categories mic,
1557: msc_bis_periods mpsd
1558: WHERE mp.plan_id = p_plan_id
1559: AND mp.plan_id = mpo.plan_id
1560: AND mpo.plan_id = mbid.plan_id
1561: AND mpo.organization_id = mbid.organization_id

Line 2224: msc_bis_periods mpsd

2220: SYSDATE AS last_update_date,
2221: -1 AS last_updated_by,
2222: SYSDATE AS CREATION_DATE
2223: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2224: msc_bis_periods mpsd
2225: WHERE mp.plan_id = l_planlist(l_index)
2226: AND mp.plan_id = mpo.plan_id
2227: AND mpo.plan_id = mbid.plan_id
2228: AND mpo.organization_id = mbid.organization_id

Line 2424: msc_item_categories mic, msc_bis_periods msbp

2420: SYSDATE,
2421: -1,
2422: SYSDATE
2423: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,
2424: msc_item_categories mic, msc_bis_periods msbp
2425: WHERE mp.plan_id = l_planlist(l_index)
2426: AND mp.plan_id = mpo.plan_id
2427: AND msd.organization_id = mpo.organization_id
2428: AND msd.sr_instance_id = mpo.sr_instance_id