DBA Data[Home] [Help]

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on MTL_SUPPLY

Line 313: from mtl_supply

309:
310: if (l_org_count <> 1) then -- Added for bug-8460461 Starts here
311: select count(1)
312: into l_org_count
313: from mtl_supply
314: where item_id = p_item_id
315: and to_organization_id =p_org_id
316: and rownum =1 ;
317: end if; -- Added for bug-#8460461 ends here

Line 427: from mtl_supply

423: from mtl_parameters
424: where master_organization_id = l_master_org)
425: loop
426: select count(1) into l_master_count
427: from mtl_supply
428: where item_id = p_item_id
429: and to_organization_id = i.organization_id
430: and rownum =1 ;
431:

Line 439: from mtl_supply

435: end loop;
436: */
437: begin
438: select count(1) into l_master_count
439: from mtl_supply
440: join mtl_parameters mp on to_organization_id = organization_id
441: where item_id = p_item_id
442: and mp.master_organization_id = l_master_org
443: group by to_organization_id