APPS.GMD_COMMON_VAL dependencies on MTL_SYSTEM_ITEMS

Line 2285: FROM mtl_system_items m

2281: WHERE formula_id =p_formula_id
2282: AND fm.owner_organization_id = o.organization_id
2283: AND formula_status < 1000
2284: AND NOT EXISTS (SELECT 1
2285: FROM mtl_system_items m
2286: WHERE inventory_item_id = p_inventory_item_id
2287: AND recipe_enabled_flag = 'Y'
2288: AND m.organization_id = fm.owner_organization_id);
2289:

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

2312: WHERE formula_id = p_formula_id
2313: AND r.owner_organization_id = o.organization_id
2314: AND recipe_status < 1000
2315: AND NOT EXISTS (SELECT 1
2316: FROM mtl_system_items m
2317: WHERE inventory_item_id = p_inventory_item_id
2318: AND recipe_enabled_flag = 'Y'
2319: AND m.organization_id = r.owner_organization_id);
2320: -- Bug 5237351 added

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

2343: AND r.owner_organization_id <> rpl.organization_id
2344: AND rpl.organization_id = o.organization_id
2345: AND r.recipe_status < 1000
2346: AND NOT EXISTS (SELECT 1
2347: FROM mtl_system_items m
2348: WHERE inventory_item_id = p_inventory_item_id
2349: AND recipe_enabled_flag = 'Y'
2350: AND m.organization_id = rpl.organization_id);
2351:

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

2377: AND rvr.organization_id <> r.owner_organization_id
2378: AND r.recipe_status < 1000
2379: AND rvr.validity_rule_status < 1000
2380: AND NOT EXISTS (SELECT 1
2381: FROM mtl_system_items m
2382: WHERE inventory_item_id = p_inventory_item_id
2383: AND recipe_enabled_flag = 'Y'
2384: AND m.organization_id = rvr.organization_id);
2385: -- Bug 5237351 added

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'

Line 2406: from mtl_system_items_b

2402: );
2403: -- Bug 5237351 added
2404: CURSOR Cur_item_rev_ctl(v_item_id NUMBER) IS
2405: select revision_qty_control_code
2406: from mtl_system_items_b
2407: where inventory_item_id = v_item_id;
2408:
2409: l_rev_ctl number; -- Bug 5237351 added
2410: l_org_id number;