APPS.GMD_COMMON_VAL dependencies on MTL_SYSTEM_ITEMS

Line 2227: FROM mtl_system_items m

2223: WHERE formula_id =p_formula_id
2224: AND fm.owner_organization_id = o.organization_id
2225: AND formula_status < 1000
2226: AND NOT EXISTS (SELECT 1
2227: FROM mtl_system_items m
2228: WHERE inventory_item_id = p_inventory_item_id
2229: AND recipe_enabled_flag = 'Y'
2230: AND m.organization_id = fm.owner_organization_id);
2231:

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 2258: FROM mtl_system_items m

2254: WHERE formula_id = p_formula_id
2255: AND r.owner_organization_id = o.organization_id
2256: AND recipe_status < 1000
2257: AND NOT EXISTS (SELECT 1
2258: FROM mtl_system_items m
2259: WHERE inventory_item_id = p_inventory_item_id
2260: AND recipe_enabled_flag = 'Y'
2261: AND m.organization_id = r.owner_organization_id);
2262: -- Bug 5237351 added

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 2289: FROM mtl_system_items m

2285: AND r.owner_organization_id <> rpl.organization_id
2286: AND rpl.organization_id = o.organization_id
2287: AND r.recipe_status < 1000
2288: AND NOT EXISTS (SELECT 1
2289: FROM mtl_system_items m
2290: WHERE inventory_item_id = p_inventory_item_id
2291: AND recipe_enabled_flag = 'Y'
2292: AND m.organization_id = rpl.organization_id);
2293:

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 2323: FROM mtl_system_items m

2319: AND rvr.organization_id <> r.owner_organization_id
2320: AND r.recipe_status < 1000
2321: AND rvr.validity_rule_status < 1000
2322: AND NOT EXISTS (SELECT 1
2323: FROM mtl_system_items m
2324: WHERE inventory_item_id = p_inventory_item_id
2325: AND recipe_enabled_flag = 'Y'
2326: AND m.organization_id = rvr.organization_id);
2327: -- Bug 5237351 added

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'

Line 2348: from mtl_system_items_b

2344: );
2345: -- Bug 5237351 added
2346: CURSOR Cur_item_rev_ctl(v_item_id NUMBER) IS
2347: select revision_qty_control_code
2348: from mtl_system_items_b
2349: where inventory_item_id = v_item_id;
2350:
2351: l_rev_ctl number; -- Bug 5237351 added
2352: l_org_id number;