eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_AUTO_STEP_CALC dependencies on FM_MATL_DTL

Line 951: fm_matl_dtl d

947: CURSOR Cur_get_material_lines (V_step_id NUMBER) IS
948: -- NPD Conv. Use inventory_iem_id and detail_uom instead of item_id and item_um
949: SELECT s.formulaline_id, d.line_type, d.qty, d.detail_uom, d.inventory_item_id, d.scale_type
950: FROM gmd_recipe_step_materials s,
951: fm_matl_dtl d
952: WHERE s.recipe_id = P_parent_id
953: AND s.formulaline_id = d.formulaline_id
954: AND s.routingstep_id = V_step_id
955: AND NVL (d.contribute_step_qty_ind, 'Y') = 'Y'

Line 1328: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um from fm_matl_dtl

1324:
1325: /* Cursor Definitions.
1326: =====================*/
1327: CURSOR Cur_get_material_lines (V_step_id NUMBER) IS
1328: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um from fm_matl_dtl
1329: SELECT s.formulaline_id, d.line_type, d.qty, d.detail_uom, d.inventory_item_id, d.scale_type
1330: FROM gmd_recipe_step_materials s,
1331: fm_matl_dtl d
1332: WHERE s.recipe_id = P_parent_id

Line 1331: fm_matl_dtl d

1327: CURSOR Cur_get_material_lines (V_step_id NUMBER) IS
1328: -- NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um from fm_matl_dtl
1329: SELECT s.formulaline_id, d.line_type, d.qty, d.detail_uom, d.inventory_item_id, d.scale_type
1330: FROM gmd_recipe_step_materials s,
1331: fm_matl_dtl d
1332: WHERE s.recipe_id = P_parent_id
1333: AND s.formulaline_id = d.formulaline_id
1334: AND s.routingstep_id = V_step_id
1335: AND NVL (d.contribute_step_qty_ind, 'Y') = 'Y'

Line 1347: FROM fm_matl_dtl d ,

1343:
1344: /* Get all formulaline information */
1345: CURSOR Cur_get_formulaline_info IS
1346: SELECT d.*
1347: FROM fm_matl_dtl d ,
1348: gmd_recipes_b r
1349: WHERE r.recipe_id = P_parent_id
1350: AND r.formula_id = d.formula_id
1351: ORDER BY d.line_type, d.line_no;

Line 1746: FROM fm_matl_dtl

1742: -- the formula line would not be committed yet. Process the rest of
1743: -- the lines, not the line which is being deleted.
1744: CURSOR Cur_check_matl_lines_assoc (V_formula_id NUMBER) IS
1745: SELECT 1
1746: FROM fm_matl_dtl
1747: WHERE formula_id = V_formula_id
1748: AND NVL(contribute_step_qty_ind, 'Y') = 'Y'
1749: AND formulaline_id NOT IN (SELECT formulaline_id
1750: FROM gmd_recipe_step_materials

Line 1758: FROM fm_matl_dtl d

1754: ;
1755:
1756: CURSOR Cur_get_material_lines (V_formula_id NUMBER) IS
1757: SELECT d.qty, d.detail_uom, d.inventory_item_id
1758: FROM fm_matl_dtl d
1759: WHERE d.formula_id = V_formula_id
1760: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1761: AND (P_check.formulaline_id IS NULL OR
1762: formulaline_id <> P_check.formulaline_id)

Line 1779: FROM fm_matl_dtl d ,mtl_units_of_measure m

1775: AND BASE_UOM_FLAG = 'Y';
1776:
1777: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS
1778: SELECT COUNT(distinct uom_class)
1779: FROM fm_matl_dtl d ,mtl_units_of_measure m
1780: WHERE d.detail_uom = m.uom_code
1781: AND d.formula_id = pformula_id
1782: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1783: AND (P_check.formulaline_id IS NULL OR

Line 1788: FROM fm_matl_dtl d ,mtl_units_of_measure m

1784: formulaline_id <> P_check.formulaline_id);
1785:
1786: CURSOR Cur_get_mtl_umtype(pformula_id NUMBER) IS
1787: SELECT distinct m.uom_class
1788: FROM fm_matl_dtl d ,mtl_units_of_measure m
1789: WHERE d.detail_uom = m.uom_code
1790: AND d.formula_id = pformula_id
1791: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1792: AND (P_check.formulaline_id IS NULL OR

Line 2184: -- Calling program should delete from fm_matl_dtl.

2180: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;
2181:
2182: BEGIN
2183: P_return_status := FND_API.G_RET_STS_SUCCESS;
2184: -- Calling program should delete from fm_matl_dtl.
2185: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2186: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2187: -- this formulaline exists in step/mat association,
2188: -- and where calculate_step_qty flag IS set (ASQC=Yes)

Line 2185: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;

2181:
2182: BEGIN
2183: P_return_status := FND_API.G_RET_STS_SUCCESS;
2184: -- Calling program should delete from fm_matl_dtl.
2185: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2186: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2187: -- this formulaline exists in step/mat association,
2188: -- and where calculate_step_qty flag IS set (ASQC=Yes)
2189: -- and where delete_mark is NOT set

Line 2358: FROM fm_matl_dtl d ,mtl_units_of_measure m

2354: AND BASE_UOM_FLAG = 'Y';
2355:
2356: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS
2357: SELECT COUNT(distinct m.uom_class)
2358: FROM fm_matl_dtl d ,mtl_units_of_measure m
2359: WHERE d.DETAIL_UOM = m.uom_code
2360: AND d.formula_id = pformula_id
2361: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
2362: AND (P_check.formulaline_id IS NULL OR

Line 2367: FROM fm_matl_dtl d ,mtl_units_of_measure m

2363: formulaline_id <> P_check.formulaline_id);
2364:
2365: CURSOR Cur_get_mtl_umtype(pformula_id NUMBER) IS
2366: SELECT distinct m.uom_class
2367: FROM fm_matl_dtl d ,mtl_units_of_measure m
2368: WHERE d.DETAIL_UOM= m.uom_code
2369: AND d.formula_id = pformula_id
2370: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
2371: AND (P_check.formulaline_id IS NULL OR