APPS.MSC_SNAPSHOT_PK dependencies on MSC_BOD_SO_SR_LEVELS

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

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

Line 1145: DELETE MSC_BOD_SO_SR_LEVELS where plan_id = p_plan_id;

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

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

1197: and msa.assignment_set_id = mp.curr_assignment_set_id
1198: )
1199: ;
1200:
1201: INSERT /*+APPEND*/ into MSC_BOD_SO_SR_LEVELS
1202: ( INVENTORY_ITEM_ID ,
1203: ORGANIZATION_ID ,
1204: SR_INSTANCE_ID ,
1205: PLAN_ID ,

Line 1263: FROM MSC_BOD_SO_SR_LEVELS_V

1259: CUSTOMER_ID ,
1260: CUSTOMER_SITE_ID ,
1261: REGION_ID ,
1262: REGION_TYPE
1263: FROM MSC_BOD_SO_SR_LEVELS_V
1264: WHERE PLAN_ID = p_plan_id;
1265: COMMIT;
1266: END IF;
1267: EXCEPTION