DBA Data[Home] [Help]

APPS.WIP_UTILITIES dependencies on MTL_LOT_NUMBERS

Line 641: FROM mtl_lot_numbers mln

637: INTO l_require_lot_attr
638: FROM dual
639: WHERE NOT EXISTS -- new lot
640: (SELECT 'X'
641: FROM mtl_lot_numbers mln
642: WHERE mln.organization_id = p_org_id
643: AND mln.inventory_item_id = p_item_id
644: AND mln.lot_number = p_lot_number);
645:

Line 679: FROM mtl_lot_numbers mln

675: WHERE msi.inventory_item_id = p_item_id
676: AND msi.organization_id = p_org_id
677: AND NOT EXISTS -- new lot
678: (SELECT 'X'
679: FROM mtl_lot_numbers mln
680: WHERE mln.organization_id = p_org_id
681: AND mln.inventory_item_id = p_item_id
682: AND mln.lot_number = p_lot_number);
683: