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_DEMANDS

Line 729: FROM msc_demands msd, msc_system_items msi,

725: count(*) AS nr_sl_records,
726: decode(GROUPING(msd.customer_id), 1, NULL, nvl(msd.customer_id, UNDEFINED_CUSTOMER_ID)) AS partner_id,
727: decode(GROUPING(cust.customer_class_code), 1, NULL, NVL(cust.customer_class_code, UNDEFINED_CUSTOMER_CODE)) AS customer_class_code,
728: RECORD_SERVICE_LEVEL AS record_type
729: FROM msc_demands msd, msc_system_items msi,
730: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo, msc_trading_partners cust
731: WHERE mp.plan_id = p_plan_id
732: AND msd.plan_id = msi.plan_id
733: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)

Line 921: msc_demands msd,

917: g_user_id,
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,

Line 1046: msc_demands msd,

1042: g_user_id,
1043: to_number(null)
1044: FROM msc_plans mp,
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

Line 1137: msc_demands msd,

1133: g_user_id,
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,

Line 1229: msc_demands msd,

1225: g_user_id,
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

Line 1313: msc_demands msd,

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
1317: AND mp.sr_instance_id = owning.sr_instance_id

Line 1388: msc_demands msd,

1384: g_user_id,
1385: to_number(null)
1386: FROM msc_plans mp,
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

Line 2423: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,

2419: mic.category_name AS category_name,
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