APPS.GMD_VALIDITY_RULES dependencies on FM_MATL_DTL

Line 124: mtl_system_items_kfv I, fm_matl_dtl d

120: /* Cursor to get data based on item. */
121: CURSOR get_val_item(l_quantity NUMBER) IS
122: SELECT v.*
123: FROM gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_status_b s,
124: mtl_system_items_kfv I, fm_matl_dtl d
125: WHERE v.recipe_id = r.recipe_id
126: AND v.validity_rule_status = s.status_code
127: AND i.inventory_item_id = v.inventory_item_id
128: AND r.owner_organization_id = i.organization_id

Line 180: FROM fm_matl_dtl

176:
177: -- NPD Conv.
178: CURSOR Cur_get_qty(V_item_id NUMBER) IS
179: SELECT qty, scale_type, detail_uom
180: FROM fm_matl_dtl
181: WHERE formula_id = l_formula_id
182: AND inventory_item_id = V_item_id
183: AND line_type = 1
184: ORDER BY line_no;

Line 204: FROM fm_matl_dtl

200: FROM GMD_VAL_RULE_GTMP;
201:
202: CURSOR get_form_prod(l_formula_id NUMBER) IS
203: SELECT inventory_item_id, qty, detail_uom
204: FROM fm_matl_dtl
205: WHERE formula_id = l_formula_id
206: AND line_type = 1
207: AND line_no = 1;
208:

Line 780: FROM fm_matl_dtl

776: x_return_status OUT NOCOPY VARCHAR2,
777: X_output_ratio OUT NOCOPY NUMBER) IS
778: CURSOR Cur_get_prods IS
779: SELECT inventory_item_id, qty, detail_uom, scale_type
780: FROM fm_matl_dtl
781: WHERE formula_id = p_formula_id
782: AND line_type IN (1,2);
783:
784: l_batch_output NUMBER := 0;

Line 854: FROM fm_matl_dtl

850: x_return_status OUT NOCOPY VARCHAR2) IS
851: -- NPD Conv.
852: CURSOR Cur_get_details(V_line_type NUMBER) IS
853: SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
854: FROM fm_matl_dtl
855: WHERE formula_id = p_formula_id
856: AND line_type = V_line_type;
857:
858: l_sum_prods NUMBER := 0;

Line 950: FROM fm_matl_dtl

946: X_return_status OUT NOCOPY VARCHAR2) IS
947: CURSOR Cur_get_ingreds IS
948: -- NPD Conv.
949: SELECT inventory_item_id, qty, detail_uom, scale_type
950: FROM fm_matl_dtl
951: WHERE formula_id = p_formula_id
952: AND line_type = -1;
953:
954: CURSOR Cur_get_total_input IS

Line 1026: FROM fm_matl_dtl

1022: X_return_status OUT NOCOPY VARCHAR2) IS
1023: -- NPD Conv.
1024: CURSOR Cur_get_ingreds IS
1025: SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
1026: FROM fm_matl_dtl
1027: WHERE formula_id = p_formula_id
1028: AND line_type = -1;
1029:
1030: l_conv_qty NUMBER := 0;

Line 1121: FROM fm_matl_dtl

1117: X_return_status OUT NOCOPY VARCHAR2) IS
1118: -- NPD Conv.
1119: CURSOR Cur_get_prods IS
1120: SELECT inventory_item_id, qty, detail_uom, scale_type
1121: FROM fm_matl_dtl
1122: WHERE formula_id = p_formula_id
1123: AND line_type = 1;
1124:
1125: l_contributing_qty NUMBER := 0;

Line 1282: FROM gmd_recipes rcp, fm_matl_dtl d

1278: FROM GMD_VAL_RULE_GTMP;
1279:
1280: CURSOR Cur_get_form_id (v_recipe_id NUMBER, V_inventory_item_id NUMBER) IS
1281: SELECT rcp.formula_id, SUM(qty), MAX(detail_uom)
1282: FROM gmd_recipes rcp, fm_matl_dtl d
1283: WHERE rcp.recipe_id = v_recipe_id
1284: AND rcp.formula_id = d.formula_id
1285: AND d.line_type = 1
1286: AND d.inventory_item_id = V_inventory_item_id;

Line 1475: FROM gmd_recipes_b r, fm_matl_dtl d

1471: x_scale_factor OUT NOCOPY NUMBER,
1472: x_return_status OUT NOCOPY VARCHAR2) IS
1473: CURSOR Cur_get_product_lines IS
1474: SELECT qty, detail_uom
1475: FROM gmd_recipes_b r, fm_matl_dtl d
1476: WHERE r.recipe_id = p_recipe_id
1477: AND r.formula_id = d.formula_id
1478: AND d.line_type = 1
1479: AND d.inventory_item_id = p_item_id;

Line 1734: FROM fm_matl_dtl

1730: AND Default_cost_parameter = 1;
1731:
1732: CURSOR Cur_get_lines IS
1733: SELECT *
1734: FROM fm_matl_dtl
1735: WHERE formula_id = p_formula_id
1736: ORDER BY line_type, line_no;
1737:
1738: l_cost_mthd VARCHAR2(25);