APPS.GMD_API_GRP dependencies on FM_MATL_DTL

Line 1466: FROM fm_matl_dtl

1462: LocalDateRecord c_get_formula%ROWTYPE;
1463:
1464: CURSOR c_get_formula_item IS
1465: SELECT inventory_item_id, revision, detail_uom, qty
1466: FROM fm_matl_dtl
1467: WHERE formula_id = p_formula_id
1468: AND line_type = 1
1469: ORDER BY line_no;
1470:

Line 1688: FROM fm_matl_dtl

1684: FROM FND_DUAL;
1685:
1686: CURSOR c_get_item_id IS
1687: SELECT inventory_item_id
1688: FROM fm_matl_dtl
1689: WHERE formula_id = p_formula_id
1690: AND line_type = 1;
1691:
1692: CURSOR c_get_recipe_info(l_orgn_id NUMBER) IS

Line 1935: FROM fm_matl_dtl d

1931: X_item_rev_list VARCHAR2(2000);
1932:
1933: CURSOR Cur_check_item (V_organization_id NUMBER) IS
1934: SELECT inventory_item_id
1935: FROM fm_matl_dtl d
1936: WHERE formula_id = p_formula_id
1937: AND NOT EXISTS (SELECT 1
1938: FROM mtl_system_items_b
1939: WHERE inventory_item_id = d.inventory_item_id

Line 1944: FROM fm_matl_dtl

1940: AND organization_id = V_organization_id
1941: AND recipe_enabled_flag = 'Y');
1942: CURSOR Cur_item IS
1943: SELECT inventory_item_id
1944: FROM fm_matl_dtl
1945: WHERE formula_id = p_formula_id;
1946:
1947: CURSOR Cur_check_item_revision (V_organization_id NUMBER) IS
1948: SELECT d.revision, b.concatenated_segments

Line 1949: FROM fm_matl_dtl d, mtl_system_items_kfv b

1945: WHERE formula_id = p_formula_id;
1946:
1947: CURSOR Cur_check_item_revision (V_organization_id NUMBER) IS
1948: SELECT d.revision, b.concatenated_segments
1949: FROM fm_matl_dtl d, mtl_system_items_kfv b
1950: WHERE formula_id = p_formula_id
1951: AND b.inventory_item_id = d.inventory_item_id
1952: AND b.organization_id = V_organization_id
1953: AND revision IS NOT NULL

Line 1962: FROM fm_matl_dtl d

1958: AND revision = d.revision);
1959:
1960: CURSOR Cur_check_item_prod_enabled (V_organization_id NUMBER) IS
1961: SELECT inventory_item_id
1962: FROM fm_matl_dtl d
1963: WHERE formula_id = p_formula_id
1964: AND NOT EXISTS (SELECT 1
1965: FROM mtl_system_items_b
1966: WHERE inventory_item_id = d.inventory_item_id

Line 1972: FROM fm_matl_dtl d

1968: AND process_execution_enabled_flag = 'Y');
1969:
1970: CURSOR Cur_check_item_cost_enabled (V_organization_id NUMBER) IS
1971: SELECT inventory_item_id
1972: FROM fm_matl_dtl d
1973: WHERE formula_id = p_formula_id
1974: AND NOT EXISTS (SELECT 1
1975: FROM mtl_system_items_b
1976: WHERE inventory_item_id = d.inventory_item_id

Line 1983: FROM fm_matl_dtl d

1979:
1980: -- Bug 5350197
1981: CURSOR Cur_check_item_serial_enabled (V_organization_id NUMBER) IS
1982: SELECT inventory_item_id
1983: FROM fm_matl_dtl d
1984: WHERE formula_id = p_formula_id
1985: AND NOT EXISTS (SELECT 1
1986: FROM mtl_system_items_b
1987: WHERE inventory_item_id = d.inventory_item_id

Line 2504: ** updating fm_matl_dtl with end date.

2500: **
2501: ** HISTORY
2502: ** 30-Apr-2005 B4479101 TDaniel Created.
2503: ** 28-Nov-2006 B5640547 akaruppa Removed the organization_id check when
2504: ** updating fm_matl_dtl with end date.
2505: **+========================================================================+*/
2506:
2507: PROCEDURE update_end_date (p_substitution_id IN NUMBER) IS
2508:

Line 2532: UPDATE fm_matl_dtl

2528: BEGIN
2529: FOR l_rec IN Cur_get_substitution LOOP
2530: /* Substitution is approved so lets update the formula line end date */
2531: IF l_rec.substitution_status BETWEEN 700 AND 799 THEN
2532: UPDATE fm_matl_dtl
2533: SET ingredient_end_date = l_rec.start_date
2534: WHERE formula_id = l_rec.formula_id
2535: AND line_type = -1
2536: AND inventory_item_id = l_rec.original_inventory_item_id

Line 2548: UPDATE fm_matl_dtl

2544: l_rec.owner_organization_id);
2545: FETCH Cur_check_substitute INTO l_start_date;
2546: CLOSE Cur_check_substitute;
2547:
2548: UPDATE fm_matl_dtl
2549: SET ingredient_end_date = l_start_date
2550: WHERE formula_id = l_rec.formula_id
2551: AND line_type = -1
2552: AND inventory_item_id = l_rec.original_inventory_item_id;

Line 2667: FROM fm_matl_dtl

2663: x_enable_revision OUT NOCOPY VARCHAR2,
2664: x_revision OUT NOCOPY VARCHAR2) IS
2665: CURSOR Cur_get_prod_lines IS
2666: SELECT revision
2667: FROM fm_matl_dtl
2668: WHERE formula_id = p_formula_id
2669: AND inventory_item_id = p_inventory_item_id
2670: AND line_type = 1
2671: ORDER BY revision;