APPS.GMD_API_GRP dependencies on FM_MATL_DTL

Line 1460: FROM fm_matl_dtl

1456: LocalDateRecord c_get_formula%ROWTYPE;
1457:
1458: CURSOR c_get_formula_item IS
1459: SELECT inventory_item_id, revision, detail_uom, qty
1460: FROM fm_matl_dtl
1461: WHERE formula_id = p_formula_id
1462: AND line_type = 1
1463: ORDER BY line_no;
1464:

Line 1681: FROM fm_matl_dtl

1677: FROM FND_DUAL;
1678:
1679: CURSOR c_get_item_id IS
1680: SELECT inventory_item_id
1681: FROM fm_matl_dtl
1682: WHERE formula_id = p_formula_id
1683: AND line_type = 1;
1684:
1685: CURSOR c_get_recipe_info(l_orgn_id NUMBER) IS

Line 1915: FROM fm_matl_dtl d

1911: X_item_rev_list VARCHAR2(2000);
1912:
1913: CURSOR Cur_check_item (V_organization_id NUMBER) IS
1914: SELECT inventory_item_id
1915: FROM fm_matl_dtl d
1916: WHERE formula_id = p_formula_id
1917: AND NOT EXISTS (SELECT 1
1918: FROM mtl_system_items_b
1919: WHERE inventory_item_id = d.inventory_item_id

Line 1924: FROM fm_matl_dtl

1920: AND organization_id = V_organization_id
1921: AND recipe_enabled_flag = 'Y');
1922: CURSOR Cur_item IS
1923: SELECT inventory_item_id
1924: FROM fm_matl_dtl
1925: WHERE formula_id = p_formula_id;
1926:
1927: CURSOR Cur_check_item_revision (V_organization_id NUMBER) IS
1928: SELECT d.revision, b.concatenated_segments

Line 1929: FROM fm_matl_dtl d, mtl_system_items_kfv b

1925: WHERE formula_id = p_formula_id;
1926:
1927: CURSOR Cur_check_item_revision (V_organization_id NUMBER) IS
1928: SELECT d.revision, b.concatenated_segments
1929: FROM fm_matl_dtl d, mtl_system_items_kfv b
1930: WHERE formula_id = p_formula_id
1931: AND b.inventory_item_id = d.inventory_item_id
1932: AND b.organization_id = V_organization_id
1933: AND revision IS NOT NULL

Line 1942: FROM fm_matl_dtl d

1938: AND revision = d.revision);
1939:
1940: CURSOR Cur_check_item_prod_enabled (V_organization_id NUMBER) IS
1941: SELECT inventory_item_id
1942: FROM fm_matl_dtl d
1943: WHERE formula_id = p_formula_id
1944: AND NOT EXISTS (SELECT 1
1945: FROM mtl_system_items_b
1946: WHERE inventory_item_id = d.inventory_item_id

Line 1952: FROM fm_matl_dtl d

1948: AND process_execution_enabled_flag = 'Y');
1949:
1950: CURSOR Cur_check_item_cost_enabled (V_organization_id NUMBER) IS
1951: SELECT inventory_item_id
1952: FROM fm_matl_dtl d
1953: WHERE formula_id = p_formula_id
1954: AND NOT EXISTS (SELECT 1
1955: FROM mtl_system_items_b
1956: WHERE inventory_item_id = d.inventory_item_id

Line 1963: FROM fm_matl_dtl d

1959:
1960: -- Bug 5350197
1961: CURSOR Cur_check_item_serial_enabled (V_organization_id NUMBER) IS
1962: SELECT inventory_item_id
1963: FROM fm_matl_dtl d
1964: WHERE formula_id = p_formula_id
1965: AND NOT EXISTS (SELECT 1
1966: FROM mtl_system_items_b
1967: WHERE inventory_item_id = d.inventory_item_id

Line 2484: ** updating fm_matl_dtl with end date.

2480: **
2481: ** HISTORY
2482: ** 30-Apr-2005 B4479101 TDaniel Created.
2483: ** 28-Nov-2006 B5640547 akaruppa Removed the organization_id check when
2484: ** updating fm_matl_dtl with end date.
2485: **+========================================================================+*/
2486:
2487: PROCEDURE update_end_date (p_substitution_id IN NUMBER) IS
2488:

Line 2512: UPDATE fm_matl_dtl

2508: BEGIN
2509: FOR l_rec IN Cur_get_substitution LOOP
2510: /* Substitution is approved so lets update the formula line end date */
2511: IF l_rec.substitution_status BETWEEN 700 AND 799 THEN
2512: UPDATE fm_matl_dtl
2513: SET ingredient_end_date = l_rec.start_date
2514: WHERE formula_id = l_rec.formula_id
2515: AND line_type = -1
2516: AND inventory_item_id = l_rec.original_inventory_item_id

Line 2528: UPDATE fm_matl_dtl

2524: l_rec.owner_organization_id);
2525: FETCH Cur_check_substitute INTO l_start_date;
2526: CLOSE Cur_check_substitute;
2527:
2528: UPDATE fm_matl_dtl
2529: SET ingredient_end_date = l_start_date
2530: WHERE formula_id = l_rec.formula_id
2531: AND line_type = -1
2532: AND inventory_item_id = l_rec.original_inventory_item_id;

Line 2647: FROM fm_matl_dtl

2643: x_enable_revision OUT NOCOPY VARCHAR2,
2644: x_revision OUT NOCOPY VARCHAR2) IS
2645: CURSOR Cur_get_prod_lines IS
2646: SELECT revision
2647: FROM fm_matl_dtl
2648: WHERE formula_id = p_formula_id
2649: AND inventory_item_id = p_inventory_item_id
2650: AND line_type = 1
2651: ORDER BY revision;