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 181: FROM fm_matl_dtl

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

Line 205: FROM fm_matl_dtl

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

Line 802: FROM fm_matl_dtl

798: x_return_status OUT NOCOPY VARCHAR2,
799: X_output_ratio OUT NOCOPY NUMBER) IS
800: CURSOR Cur_get_prods IS
801: SELECT inventory_item_id, qty, detail_uom, scale_type
802: FROM fm_matl_dtl
803: WHERE formula_id = p_formula_id
804: AND line_type IN (1,2);
805:
806: l_batch_output NUMBER := 0;

Line 876: FROM fm_matl_dtl

872: x_return_status OUT NOCOPY VARCHAR2) IS
873: -- NPD Conv.
874: CURSOR Cur_get_details(V_line_type NUMBER) IS
875: SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
876: FROM fm_matl_dtl
877: WHERE formula_id = p_formula_id
878: AND line_type = V_line_type;
879:
880: l_sum_prods NUMBER := 0;

Line 972: FROM fm_matl_dtl

968: X_return_status OUT NOCOPY VARCHAR2) IS
969: CURSOR Cur_get_ingreds IS
970: -- NPD Conv.
971: SELECT inventory_item_id, qty, detail_uom, scale_type
972: FROM fm_matl_dtl
973: WHERE formula_id = p_formula_id
974: AND line_type = -1;
975:
976: CURSOR Cur_get_total_input IS

Line 1048: FROM fm_matl_dtl

1044: X_return_status OUT NOCOPY VARCHAR2) IS
1045: -- NPD Conv.
1046: CURSOR Cur_get_ingreds IS
1047: SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
1048: FROM fm_matl_dtl
1049: WHERE formula_id = p_formula_id
1050: AND line_type = -1;
1051:
1052: l_conv_qty NUMBER := 0;

Line 1143: FROM fm_matl_dtl

1139: X_return_status OUT NOCOPY VARCHAR2) IS
1140: -- NPD Conv.
1141: CURSOR Cur_get_prods IS
1142: SELECT inventory_item_id, qty, detail_uom, scale_type
1143: FROM fm_matl_dtl
1144: WHERE formula_id = p_formula_id
1145: AND line_type = 1;
1146:
1147: l_contributing_qty NUMBER := 0;

Line 1304: FROM gmd_recipes rcp, fm_matl_dtl d

1300: FROM GMD_VAL_RULE_GTMP;
1301:
1302: CURSOR Cur_get_form_id (v_recipe_id NUMBER, V_inventory_item_id NUMBER) IS
1303: SELECT rcp.formula_id, SUM(qty), MAX(detail_uom)
1304: FROM gmd_recipes rcp, fm_matl_dtl d
1305: WHERE rcp.recipe_id = v_recipe_id
1306: AND rcp.formula_id = d.formula_id
1307: AND d.line_type = 1
1308: AND d.inventory_item_id = V_inventory_item_id;

Line 1497: FROM gmd_recipes_b r, fm_matl_dtl d

1493: x_scale_factor OUT NOCOPY NUMBER,
1494: x_return_status OUT NOCOPY VARCHAR2) IS
1495: CURSOR Cur_get_product_lines IS
1496: SELECT qty, detail_uom
1497: FROM gmd_recipes_b r, fm_matl_dtl d
1498: WHERE r.recipe_id = p_recipe_id
1499: AND r.formula_id = d.formula_id
1500: AND d.line_type = 1
1501: AND d.inventory_item_id = p_item_id;

Line 1756: FROM fm_matl_dtl

1752: AND Default_cost_parameter = 1;
1753:
1754: CURSOR Cur_get_lines IS
1755: SELECT *
1756: FROM fm_matl_dtl
1757: WHERE formula_id = p_formula_id
1758: ORDER BY line_type, line_no;
1759:
1760: l_cost_mthd VARCHAR2(25);