APPS.INVIDIT3 dependencies on MTL_LOT_NUMBERS

Line 537: from mtl_lot_numbers

533: if opm_enabled_org ='Y' then -- to check the OPM_ENABLED_ORGS
534:
535: select count(1)
536: into lots_org_count
537: from mtl_lot_numbers
538: where inventory_item_id = p_item_id and
539: organization_id = p_org_id and
540: rownum = 1;
541:

Line 545: from mtl_lot_numbers mln

541:
542: if (lots_org_count <> 1) then
543: select count(1)
544: into lots_master_count
545: from mtl_lot_numbers mln
546: where inventory_item_id = p_item_id
547: and exists (select 1
548: from mtl_parameters
549: where master_organization_id = p_master_org