APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_MATERIAL_PLANS

Line 3084: -- flush_item_plan inserts into MRP_MATERIAL_PLANS

3080: END;
3081:
3082: -- =============================================================================
3083: --
3084: -- flush_item_plan inserts into MRP_MATERIAL_PLANS
3085: --
3086: -- =============================================================================
3087: PROCEDURE flush_item_plan(inv_item_id IN NUMBER,
3088: org_id IN NUMBER) IS

Line 3287: INSERT INTO mrp_material_plans(

3283: END IF;
3284: END IF;
3285:
3286: FOR loop_counter IN 1..NUM_OF_TYPES LOOP
3287: INSERT INTO mrp_material_plans(
3288: plan_id,
3289: organization_id,
3290: compile_designator,
3291: plan_organization_id,

Line 3381: INSERT INTO mrp_material_plans(

3377: bucket_cells_tab(REQ_OFF)+bucket_cells_tab(TRANSIT_OFF)+
3378: bucket_cells_tab(RECEIVING_OFF)+bucket_cells_tab(PLANNED_OFF)+
3379: bucket_cells_tab(PB_SUPPLY_OFF);
3380:
3381: INSERT INTO mrp_material_plans(
3382: plan_id,
3383: organization_id,
3384: compile_designator,
3385: plan_organization_id,

Line 3457: -- update mrp_material_plans set quantity6 = quantity1+quantity2+quantity3

3453: bucket_cells_tab(34),
3454: bucket_cells_tab(35),
3455: bucket_cells_tab(36));
3456: -- apatanka
3457: -- update mrp_material_plans set quantity6 = quantity1+quantity2+quantity3
3458: -- +quantity4+quantity5
3459: -- where inventory_item_id = inv_item_id and
3460: -- organization_id = arg_plan_organization_id and
3461: -- compile_designator = arg_compile_designator and