DBA Data[Home] [Help]

APPS.WIP_UTILITIES dependencies on MTL_LOT_NUMBERS

Line 699: FROM mtl_lot_numbers mln

695: INTO l_require_lot_attr
696: FROM dual
697: WHERE NOT EXISTS -- new lot
698: (SELECT 'X'
699: FROM mtl_lot_numbers mln
700: WHERE mln.organization_id = p_org_id
701: AND mln.inventory_item_id = p_item_id
702: AND mln.lot_number = p_lot_number);
703:

Line 737: FROM mtl_lot_numbers mln

733: WHERE msi.inventory_item_id = p_item_id
734: AND msi.organization_id = p_org_id
735: AND NOT EXISTS -- new lot
736: (SELECT 'X'
737: FROM mtl_lot_numbers mln
738: WHERE mln.organization_id = p_org_id
739: AND mln.inventory_item_id = p_item_id
740: AND mln.lot_number = p_lot_number);
741: