APPS.MSC_SNAPSHOT_PK dependencies on MSC_BOD_SO_SR_LEVELS

Line 1032: DBMS_MVIEW.REFRESH ('MSC_BOD_SO_SR_LEVELS_MV','c');

1028: lv_p_plan_so number;
1029: lv_p_plan_type number;
1030: BEGIN
1031: /* DBMS_MVIEW.REFRESH ('MSC_ITEM_FCST_BOD_SR_LEVELS_MV','c');
1032: DBMS_MVIEW.REFRESH ('MSC_BOD_SO_SR_LEVELS_MV','c');
1033: */
1034: IF p_global_forecast = SYS_YES THEN
1035: DELETE MSC_ITEM_FCST_BOD_SR_LEVELS where plan_id = p_plan_id;
1036: COMMIT;

Line 1147: DELETE MSC_BOD_SO_SR_LEVELS where plan_id = p_plan_id;

1143: END IF;
1144:
1145: IF lv_p_plan_so > 0 THEN
1146:
1147: DELETE MSC_BOD_SO_SR_LEVELS where plan_id = p_plan_id;
1148: COMMIT;
1149:
1150: INSERT INTO MSC_TEMP_REGION_LOCATIONS(
1151: REGION_ID ,

Line 1227: INSERT /*+APPEND*/ into MSC_BOD_SO_SR_LEVELS

1223: AND so.ship_to_site_use_id IS NOT NULL);
1224:
1225: COMMIT;
1226:
1227: INSERT /*+APPEND*/ into MSC_BOD_SO_SR_LEVELS
1228: ( INVENTORY_ITEM_ID ,
1229: ORGANIZATION_ID ,
1230: SR_INSTANCE_ID ,
1231: PLAN_ID ,

Line 1289: FROM MSC_BOD_SO_SR_LEVELS_V

1285: CUSTOMER_ID ,
1286: CUSTOMER_SITE_ID ,
1287: REGION_ID ,
1288: REGION_TYPE
1289: FROM MSC_BOD_SO_SR_LEVELS_V
1290: WHERE PLAN_ID = p_plan_id;
1291: COMMIT;
1292: END IF;
1293: EXCEPTION