APPS.GMD_AUTO_STEP_CALC dependencies on GMD_RECIPE_STEP_MATERIALS

Line 946: FROM gmd_recipe_step_materials s,

942: =====================*/
943: CURSOR Cur_get_material_lines (V_step_id NUMBER) IS
944: -- NPD Conv. Use inventory_iem_id and detail_uom instead of item_id and item_um
945: SELECT s.formulaline_id, d.line_type, d.qty, d.detail_uom, d.inventory_item_id, d.scale_type
946: FROM gmd_recipe_step_materials s,
947: fm_matl_dtl d
948: WHERE s.recipe_id = P_parent_id
949: AND s.formulaline_id = d.formulaline_id
950: AND s.routingstep_id = V_step_id

Line 1324: FROM gmd_recipe_step_materials s,

1320: =====================*/
1321: CURSOR Cur_get_material_lines (V_step_id NUMBER) IS
1322: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um from fm_matl_dtl
1323: SELECT s.formulaline_id, d.line_type, d.qty, d.detail_uom, d.inventory_item_id, d.scale_type
1324: FROM gmd_recipe_step_materials s,
1325: fm_matl_dtl d
1326: WHERE s.recipe_id = P_parent_id
1327: AND s.formulaline_id = d.formulaline_id
1328: AND s.routingstep_id = V_step_id

Line 1744: FROM gmd_recipe_step_materials

1740: FROM fm_matl_dtl
1741: WHERE formula_id = V_formula_id
1742: AND NVL(contribute_step_qty_ind, 'Y') = 'Y'
1743: AND formulaline_id NOT IN (SELECT formulaline_id
1744: FROM gmd_recipe_step_materials
1745: WHERE recipe_id = P_check.parent_id)
1746: AND (P_check.formulaline_id IS NULL OR
1747: formulaline_id <> P_check.formulaline_id)
1748: ;

Line 2078: FROM gmd_recipe_step_materials m,

2074:
2075: CURSOR Cur_get_step_mat_recipes (p_formulaline_id NUMBER, p_routingstep_id NUMBER) IS
2076: SELECT m.recipe_id,
2077: r.recipe_status
2078: FROM gmd_recipe_step_materials m,
2079: gmd_recipes_b r,
2080: gmd_status_b s
2081: WHERE s.status_code = r.recipe_status
2082: AND r.recipe_id = m.recipe_id

Line 2109: FROM gmd_recipe_step_materials

2105:
2106: P_check_step_mat.ASQC_RECIPES := x_recipe_cntr;
2107:
2108: SELECT COUNT(unique recipe_id) into P_check_step_mat.STEP_ASSOC_RECIPES
2109: FROM gmd_recipe_step_materials
2110: WHERE (P_check.formulaline_id is not null AND formulaline_id = P_check.formulaline_id)
2111: OR
2112: (p_check.routingstep_id is not null AND routingstep_id = P_check.routingstep_id) ;
2113:

Line 2133: -- GMD_RECIPE_STEP_MATERIALS. Then, if ASQC flag = yes, step qty's are

2129: -- DESCRIPTION:
2130: -- This PL/SQL procedure accepts a formulaline_id or routingstep_id
2131: -- which is being deleted from the formula material table or routing detail
2132: -- table, respectively. The formualine_id or routingstep_id is deleted from
2133: -- GMD_RECIPE_STEP_MATERIALS. Then, if ASQC flag = yes, step qty's are
2134: -- recalculated.
2135: --
2136: -- REQUIREMENTS
2137: -- Calling program must first call check_del_from_step_mat.

Line 2200: DELETE FROM gmd_recipe_step_materials

2196: -- For the next version, check if formulaline's which would go away because a routing step
2197: -- is deleted actually ARE marked as contributing-to-step-qty. If not, then asqc can be
2198: -- recalc'ed.
2199: IF P_check_step_mat.STEP_ASSOC_RECIPES > 0 THEN
2200: DELETE FROM gmd_recipe_step_materials
2201: WHERE (P_check.formulaline_id is not null AND formulaline_id = P_check.formulaline_id)
2202: OR
2203: (p_check.routingstep_id is not null AND routingstep_id = P_check.routingstep_id) ;
2204: