APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_SYSTEM_ITEMS

Line 813: FROM msc_system_items msi

809:
810: /* First get the product family id */
811: SELECT msi.product_family_id
812: INTO x_product_family_id
813: FROM msc_system_items msi
814: WHERE
815: msi.plan_id = -1
816: AND msi.sr_instance_id = p_sr_instance_id
817: AND msi.organization_id = p_master_org_id

Line 827: FROM msc_system_items msi

823: END IF;
824:
825: SELECT nvl(msi.ato_forecast_control, 3)
826: INTO x_is_fcstable
827: FROM msc_system_items msi
828: WHERE msi.plan_id = -1
829: AND msi.sr_instance_id = p_sr_instance_id
830: AND msi.organization_id = p_master_org_id
831: AND msi.inventory_item_id = x_product_family_id;

Line 883: FROM msc_system_items msi

879: EXECUTE IMMEDIATE x_sql USING OUT x_return_value;
880:
881: SELECT nvl(msi.ato_forecast_control, 3)
882: INTO x_is_fcstable
883: FROM msc_system_items msi
884: WHERE msi.plan_id = -1
885: AND msi.sr_instance_id = p_sr_instance_id
886: AND msi.organization_id = x_return_value
887: AND msi.inventory_item_id = p_inventory_item_id;