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_PLAN_ORGANIZATIONS

Line 730: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo, msc_trading_partners cust

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)
734: AND trunc(msd.using_assembly_demand_date) between l_start_date AND l_end_date

Line 920: msc_plan_organizations mpo,

916: sysdate,
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,

Line 1045: msc_plan_organizations mpo,

1041: sysdate,
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

Line 1136: msc_plan_organizations mpo,

1132: sysdate,
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,

Line 1228: msc_plan_organizations mpo,

1224: sysdate,
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,

Line 1387: msc_plan_organizations mpo,

1383: sysdate,
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

Line 1467: msc_plan_organizations mpo,

1463: sysdate,
1464: g_user_id,
1465: to_number(null)
1466: FROM msc_plans mp,
1467: msc_plan_organizations mpo,
1468: msc_bis_inv_detail mbid,
1469: msc_system_items mis,
1470: msc_item_categories mic,
1471: msc_trading_partners mtp,

Line 1553: msc_plan_organizations mpo,

1549: sysdate,
1550: g_user_id,
1551: to_number(null)
1552: FROM msc_plans mp,
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

Line 1657: FROM msc_plan_organizations mpo, msc_safety_stocks mss,

1653: 0 AS nr_sl_records,
1654: NULL AS partner_id,
1655: NULL AS customer_class_code,
1656: RECORD_SAFETY_STOCK AS record_type
1657: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
1658: msc_system_items msi, msc_item_categories mic
1659: WHERE mss.sr_instance_id = msi.sr_instance_id
1660: AND mss.plan_id = msi.plan_id
1661: AND mss.organization_id = msi.organization_id

Line 1799: msc_plans mp, msc_plan_organizations mpo

1795: NULL AS partner_id,
1796: NULL AS customer_class_code,
1797: RECORD_SAFETY_STOCK AS record_type
1798: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,
1799: msc_plans mp, msc_plan_organizations mpo
1800: WHERE mss.sr_instance_id = msi.sr_instance_id
1801: AND mss.plan_id = msi.plan_id
1802: AND mss.organization_id = msi.organization_id
1803: AND mss.inventory_item_id = msi.inventory_item_id

Line 2117: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,

2113: NULL AS item_id,
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

Line 2223: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,

2219: NULL AS item_id,
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

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