APPS.MSC_SNAPSHOT_PK dependencies on MSC_ITEM_FCST_BOD_SR_LEVELS

Line 1029: /* DBMS_MVIEW.REFRESH ('MSC_ITEM_FCST_BOD_SR_LEVELS_MV','c');

1025: ) IS
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;

Line 1033: DELETE MSC_ITEM_FCST_BOD_SR_LEVELS where plan_id = p_plan_id;

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;
1035:
1036: INSERT /*+APPEND*/ INTO MSC_ITEM_FCST_BOD_SR_LEVELS
1037: (

Line 1036: INSERT /*+APPEND*/ INTO MSC_ITEM_FCST_BOD_SR_LEVELS

1032: IF p_global_forecast = SYS_YES THEN
1033: DELETE MSC_ITEM_FCST_BOD_SR_LEVELS where plan_id = p_plan_id;
1034: COMMIT;
1035:
1036: INSERT /*+APPEND*/ INTO MSC_ITEM_FCST_BOD_SR_LEVELS
1037: (
1038: INVENTORY_ITEM_ID ,
1039: SR_INVENTORY_ITEM_ID ,
1040: ORGANIZATION_ID ,

Line 1097: FROM MSC_ITEM_FCST_BOD_SR_LEVELS_V

1093: OWNING_ORG_ID ,
1094: CUSTOMER_ID ,
1095: CUSTOMER_SITE_ID ,
1096: ZONE_ID
1097: FROM MSC_ITEM_FCST_BOD_SR_LEVELS_V
1098: WHERE PLAN_ID = p_plan_id;
1099: COMMIT;
1100: END IF;
1101: