APPS.GMD_COMMON_VAL dependencies on MTL_ITEM_REVISIONS

Line 2239: FROM mtl_system_items m, mtl_item_revisions mir

2235: WHERE formula_id =p_formula_id
2236: AND fm.owner_organization_id = o.organization_id
2237: AND formula_status < 1000
2238: AND NOT EXISTS (SELECT 1
2239: FROM mtl_system_items m, mtl_item_revisions mir
2240: WHERE m.inventory_item_id = p_inventory_item_id
2241: AND mir.revision = p_revision
2242: AND m.inventory_item_id = mir.inventory_item_id
2243: AND m.recipe_enabled_flag = 'Y'

Line 2270: FROM mtl_system_items m, mtl_item_revisions mir

2266: WHERE formula_id = p_formula_id
2267: AND r.owner_organization_id = o.organization_id
2268: AND recipe_status < 1000
2269: AND NOT EXISTS (SELECT 1
2270: FROM mtl_system_items m, mtl_item_revisions mir
2271: WHERE m.inventory_item_id = p_inventory_item_id
2272: AND mir.revision = p_revision
2273: AND m.inventory_item_id = mir.inventory_item_id
2274: AND m.recipe_enabled_flag = 'Y'

Line 2304: FROM mtl_system_items m, mtl_item_revisions mir

2300: AND r.owner_organization_id <> rpl.organization_id
2301: AND rpl.organization_id = o.organization_id
2302: AND r.recipe_status < 1000
2303: AND NOT EXISTS (SELECT 1
2304: FROM mtl_system_items m, mtl_item_revisions mir
2305: WHERE m.inventory_item_id = p_inventory_item_id
2306: AND mir.revision = p_revision
2307: AND m.inventory_item_id = mir.inventory_item_id
2308: AND m.recipe_enabled_flag = 'Y'

Line 2337: FROM mtl_system_items m, mtl_item_revisions mir

2333: and o.organization_id = rvr.organization_id
2334: AND r.recipe_status < 1000
2335: AND rvr.validity_rule_status < 1000
2336: AND NOT EXISTS (SELECT 1
2337: FROM mtl_system_items m, mtl_item_revisions mir
2338: WHERE m.inventory_item_id = p_inventory_item_id
2339: AND mir.revision = p_revision
2340: AND m.inventory_item_id = mir.inventory_item_id
2341: AND m.recipe_enabled_flag = 'Y'