APPS.MSC_SNAPSHOT_PK dependencies on MSC_SALES_ORDER_ITEMS

Line 1203: DELETE MSC_SALES_ORDER_ITEMS where plan_id = p_plan_id;

1199: and msa.assignment_set_id = mp.curr_assignment_set_id
1200: )
1201: ;
1202:
1203: DELETE MSC_SALES_ORDER_ITEMS where plan_id = p_plan_id;
1204: COMMIT;
1205:
1206: INSERT /*+APPEND*/ into MSC_SALES_ORDER_ITEMS
1207: (PLAN_ID,

Line 1206: INSERT /*+APPEND*/ into MSC_SALES_ORDER_ITEMS

1202:
1203: DELETE MSC_SALES_ORDER_ITEMS where plan_id = p_plan_id;
1204: COMMIT;
1205:
1206: INSERT /*+APPEND*/ into MSC_SALES_ORDER_ITEMS
1207: (PLAN_ID,
1208: SR_INSTANCE_ID,
1209: ORGANIZATION_ID,
1210: INVENTORY_ITEM_ID,