APPS.GMD_API_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 1938: FROM mtl_system_items_b

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
1940: AND organization_id = V_organization_id
1941: AND recipe_enabled_flag = 'Y');
1942: CURSOR Cur_item IS

Line 1965: FROM mtl_system_items_b

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
1967: AND organization_id = V_organization_id
1968: AND process_execution_enabled_flag = 'Y');
1969:

Line 1975: FROM mtl_system_items_b

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
1977: AND organization_id = V_organization_id
1978: AND process_costing_enabled_flag = 'Y');
1979:

Line 1986: FROM mtl_system_items_b

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
1988: AND organization_id = V_organization_id
1989: AND serial_number_control_code IN (1,6));
1990: