DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_BIS_PERIODS

Line 1053: msc_bis_periods msbp

1049: msc_plan_organizations mpo,
1050: msc_demands msd,
1051: msc_system_items msi,
1052: msc_item_categories mic,
1053: msc_bis_periods msbp
1054: WHERE mp.plan_id = p_plan_id
1055: AND mp.plan_id = mpo.plan_id
1056: AND msd.organization_id = mpo.organization_id
1057: AND msd.sr_instance_id = mpo.sr_instance_id

Line 1266: msc_bis_periods msbp

1262: msc_plan_organizations mpo,
1263: msc_demands msd,
1264: msc_system_items msi,
1265: msc_item_categories mic,
1266: msc_bis_periods msbp
1267: WHERE mp.plan_id = p_plan_id
1268: AND mp.plan_id = mpo.plan_id
1269: AND msd.organization_id = mpo.organization_id
1270: AND msd.sr_instance_id = mpo.sr_instance_id

Line 1609: msc_bis_periods msbp

1605: msc_plan_organizations mpo,
1606: msc_demands msd,
1607: msc_system_items msi,
1608: msc_item_categories mic,
1609: msc_bis_periods msbp
1610: WHERE mp.plan_id = p_plan_id
1611: AND mp.plan_id = mpo.plan_id
1612: AND msd.organization_id = mpo.organization_id
1613: AND msd.sr_instance_id = mpo.sr_instance_id

Line 1883: msc_bis_periods mpsd

1879: msc_plan_organizations mpo,
1880: msc_bis_inv_detail mbid,
1881: msc_system_items mis,
1882: msc_item_categories mic,
1883: msc_bis_periods mpsd
1884: WHERE mp.plan_id = p_plan_id
1885: AND mp.plan_id = mpo.plan_id
1886: AND mpo.plan_id = mbid.plan_id
1887: AND mpo.organization_id = mbid.organization_id

Line 2639: msc_bis_periods mpsd

2635: SYSDATE AS last_update_date,
2636: -1 AS last_updated_by,
2637: SYSDATE AS CREATION_DATE
2638: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2639: msc_bis_periods mpsd
2640: WHERE mp.plan_id = l_planlist(l_index)
2641: AND mp.plan_id = mpo.plan_id
2642: AND mpo.plan_id = mbid.plan_id
2643: AND mpo.organization_id = mbid.organization_id

Line 2838: msc_item_categories mic, msc_bis_periods msbp

2834: SYSDATE,
2835: -1,
2836: SYSDATE
2837: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,
2838: msc_item_categories mic, msc_bis_periods msbp
2839: WHERE mp.plan_id = l_planlist(l_index)
2840: AND mp.plan_id = mpo.plan_id
2841: AND msd.organization_id = mpo.organization_id
2842: AND msd.sr_instance_id = mpo.sr_instance_id