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 947: fm_matl_dtl d

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
951: AND NVL (d.contribute_step_qty_ind, 'Y') = 'Y'

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

1318:
1319: /* Cursor Definitions.
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

Line 1325: fm_matl_dtl d

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
1329: AND NVL (d.contribute_step_qty_ind, 'Y') = 'Y'

Line 1341: FROM fm_matl_dtl d ,

1337:
1338: /* Get all formulaline information */
1339: CURSOR Cur_get_formulaline_info IS
1340: SELECT d.*
1341: FROM fm_matl_dtl d ,
1342: gmd_recipes_b r
1343: WHERE r.recipe_id = P_parent_id
1344: AND r.formula_id = d.formula_id
1345: ORDER BY d.line_type, d.line_no;

Line 1740: FROM fm_matl_dtl

1736: -- the formula line would not be committed yet. Process the rest of
1737: -- the lines, not the line which is being deleted.
1738: CURSOR Cur_check_matl_lines_assoc (V_formula_id NUMBER) IS
1739: SELECT 1
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

Line 1752: FROM fm_matl_dtl d

1748: ;
1749:
1750: CURSOR Cur_get_material_lines (V_formula_id NUMBER) IS
1751: SELECT d.qty, d.detail_uom, d.inventory_item_id
1752: FROM fm_matl_dtl d
1753: WHERE d.formula_id = V_formula_id
1754: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1755: AND (P_check.formulaline_id IS NULL OR
1756: formulaline_id <> P_check.formulaline_id)

Line 1771: FROM fm_matl_dtl d ,mtl_units_of_measure m

1767: WHERE uom_class = V_uom_class;
1768:
1769: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS
1770: SELECT COUNT(distinct uom_class)
1771: FROM fm_matl_dtl d ,mtl_units_of_measure m
1772: WHERE d.detail_uom = m.uom_code
1773: AND d.formula_id = pformula_id
1774: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1775: AND (P_check.formulaline_id IS NULL OR

Line 1780: FROM fm_matl_dtl d ,mtl_units_of_measure m

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

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

2172: ALL_MTL_LINES_NOT_ASSOC EXCEPTION;
2173:
2174: BEGIN
2175: P_return_status := FND_API.G_RET_STS_SUCCESS;
2176: -- Calling program should delete from fm_matl_dtl.
2177: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2178: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2179: -- this formulaline exists in step/mat association,
2180: -- and where calculate_step_qty flag IS set (ASQC=Yes)

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

2173:
2174: BEGIN
2175: P_return_status := FND_API.G_RET_STS_SUCCESS;
2176: -- Calling program should delete from fm_matl_dtl.
2177: -- DELETE FROM fm_matl_dtl WHERE formulaline_id = P_formulaline_id;
2178: -- 1. Use gmd_auto_step_calc.check_del_from_step_mat to get a list of recipes where
2179: -- this formulaline exists in step/mat association,
2180: -- and where calculate_step_qty flag IS set (ASQC=Yes)
2181: -- and where delete_mark is NOT set

Line 2350: FROM fm_matl_dtl d ,mtl_units_of_measure m

2346: AND BASE_UOM_FLAG = 'Y';
2347:
2348: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS
2349: SELECT COUNT(distinct m.uom_class)
2350: FROM fm_matl_dtl d ,mtl_units_of_measure m
2351: WHERE d.DETAIL_UOM = m.uom_code
2352: AND d.formula_id = pformula_id
2353: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
2354: AND (P_check.formulaline_id IS NULL OR

Line 2359: FROM fm_matl_dtl d ,mtl_units_of_measure m

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