APPS.INV_LOT_SEL_ATTR dependencies on MTL_SYSTEM_ITEMS_B

Line 2245: FROM mtl_system_items_b

2241: IF (p_lot_generation = 2 AND p_lot_uniqueness = 1) THEN
2242:
2243: SELECT 'N' BULK COLLECT
2244: INTO loc_tab
2245: FROM mtl_system_items_b
2246: WHERE auto_lot_alpha_prefix = p_lot_prefix
2247: AND lot_control_code = 2
2248: FOR UPDATE NOWAIT;
2249:

Line 2256: FROM mtl_system_items_b

2252: ELSIF(p_lot_generation = 2 AND p_lot_uniqueness <> 1) THEN
2253:
2254: SELECT 'N'
2255: INTO l_already_locked
2256: FROM mtl_system_items_b
2257: WHERE organization_id = p_org_id
2258: AND inventory_item_id = p_inventory_item_id
2259: FOR UPDATE NOWAIT;
2260: