DBA Data[Home] [Help]

APPS.INVIDIT3 dependencies on MTL_LOT_NUMBERS

Line 504: from mtl_lot_numbers

500: --Start Bug 3713912 we have to check if lots have been defined.
501: --If lots are defined the all lot dependent fields are non updateable.
502: select count(1)
503: into lots_org_count
504: from mtl_lot_numbers
505: where inventory_item_id = p_item_id and
506: organization_id = p_org_id and
507: rownum = 1;
508:

Line 512: from mtl_lot_numbers mln

508:
509: if (lots_org_count <> 1) then
510: select count(1)
511: into lots_master_count
512: from mtl_lot_numbers mln
513: where inventory_item_id = p_item_id
514: and exists (select 1
515: from mtl_parameters
516: where master_organization_id = p_master_org