APPS.GMD_API_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 1918: FROM mtl_system_items_b

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
1920: AND organization_id = V_organization_id
1921: AND recipe_enabled_flag = 'Y');
1922: CURSOR Cur_item IS

Line 1945: FROM mtl_system_items_b

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
1947: AND organization_id = V_organization_id
1948: AND process_execution_enabled_flag = 'Y');
1949:

Line 1955: FROM mtl_system_items_b

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
1957: AND organization_id = V_organization_id
1958: AND process_costing_enabled_flag = 'Y');
1959:

Line 1966: FROM mtl_system_items_b

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
1968: AND organization_id = V_organization_id
1969: AND serial_number_control_code IN (1,6));
1970: