APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_SYSTEM_ITEMS

Line 551: log_message('MSC.MSC_SYSTEM_ITEMS');

547: log_message('MSC.MSC_BIS_INV_DETAIL');
548: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_BIS_INV_DETAIL TO ' || x_dem_schema;
549: execute immediate x_grant_sql;
550:
551: log_message('MSC.MSC_SYSTEM_ITEMS');
552: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_SYSTEM_ITEMS TO ' || x_dem_schema;
553: execute immediate x_grant_sql;
554:
555: log_message('MSC.MSC_PLAN_ORGANIZATIONS');

Line 552: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_SYSTEM_ITEMS TO ' || x_dem_schema;

548: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_BIS_INV_DETAIL TO ' || x_dem_schema;
549: execute immediate x_grant_sql;
550:
551: log_message('MSC.MSC_SYSTEM_ITEMS');
552: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_SYSTEM_ITEMS TO ' || x_dem_schema;
553: execute immediate x_grant_sql;
554:
555: log_message('MSC.MSC_PLAN_ORGANIZATIONS');
556: x_grant_sql := 'GRANT SELECT ON ' || x_msc_schema || '.MSC_PLAN_ORGANIZATIONS TO ' || x_dem_schema;

Line 1352: FROM msc_system_items msi

1348:
1349: /* First get the product family id */
1350: SELECT msi.product_family_id
1351: INTO x_product_family_id
1352: FROM msc_system_items msi
1353: WHERE
1354: msi.plan_id = -1
1355: AND msi.sr_instance_id = p_sr_instance_id
1356: AND msi.organization_id = p_master_org_id

Line 1366: FROM msc_system_items msi

1362: END IF;
1363:
1364: SELECT nvl(msi.ato_forecast_control, 3)
1365: INTO x_is_fcstable
1366: FROM msc_system_items msi
1367: WHERE msi.plan_id = -1
1368: AND msi.sr_instance_id = p_sr_instance_id
1369: AND msi.organization_id = p_master_org_id
1370: AND msi.inventory_item_id = x_product_family_id;

Line 1438: FROM msc_system_items msi

1434: END IF;
1435:
1436: SELECT nvl(msi.ato_forecast_control, 3)
1437: INTO x_is_fcstable
1438: FROM msc_system_items msi
1439: WHERE msi.plan_id = -1
1440: AND msi.sr_instance_id = p_sr_instance_id
1441: AND msi.organization_id = x_return_value
1442: AND msi.inventory_item_id = p_inventory_item_id;

Line 1941: FROM msc_system_items

1937: x_master_org := get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');
1938:
1939: SELECT nvl(uom_code,'Ea')
1940: INTO x_master_uom
1941: FROM msc_system_items
1942: WHERE plan_id = -1
1943: AND sr_instance_id = p_sr_instance_id
1944: AND organization_id = x_master_org
1945: AND inventory_item_id = p_inventory_item_id;