APPS.GMD_COMMON_VAL dependencies on MTL_ITEM_REVISIONS

Line 2297: FROM mtl_system_items m, mtl_item_revisions mir

2293: WHERE formula_id =p_formula_id
2294: AND fm.owner_organization_id = o.organization_id
2295: AND formula_status < 1000
2296: AND NOT EXISTS (SELECT 1
2297: FROM mtl_system_items m, mtl_item_revisions mir
2298: WHERE m.inventory_item_id = p_inventory_item_id
2299: AND mir.revision = p_revision
2300: AND m.inventory_item_id = mir.inventory_item_id
2301: AND m.recipe_enabled_flag = 'Y'

Line 2328: FROM mtl_system_items m, mtl_item_revisions mir

2324: WHERE formula_id = p_formula_id
2325: AND r.owner_organization_id = o.organization_id
2326: AND recipe_status < 1000
2327: AND NOT EXISTS (SELECT 1
2328: FROM mtl_system_items m, mtl_item_revisions mir
2329: WHERE m.inventory_item_id = p_inventory_item_id
2330: AND mir.revision = p_revision
2331: AND m.inventory_item_id = mir.inventory_item_id
2332: AND m.recipe_enabled_flag = 'Y'

Line 2362: FROM mtl_system_items m, mtl_item_revisions mir

2358: AND r.owner_organization_id <> rpl.organization_id
2359: AND rpl.organization_id = o.organization_id
2360: AND r.recipe_status < 1000
2361: AND NOT EXISTS (SELECT 1
2362: FROM mtl_system_items m, mtl_item_revisions mir
2363: WHERE m.inventory_item_id = p_inventory_item_id
2364: AND mir.revision = p_revision
2365: AND m.inventory_item_id = mir.inventory_item_id
2366: AND m.recipe_enabled_flag = 'Y'

Line 2395: FROM mtl_system_items m, mtl_item_revisions mir

2391: and o.organization_id = rvr.organization_id
2392: AND r.recipe_status < 1000
2393: AND rvr.validity_rule_status < 1000
2394: AND NOT EXISTS (SELECT 1
2395: FROM mtl_system_items m, mtl_item_revisions mir
2396: WHERE m.inventory_item_id = p_inventory_item_id
2397: AND mir.revision = p_revision
2398: AND m.inventory_item_id = mir.inventory_item_id
2399: AND m.recipe_enabled_flag = 'Y'