DBA Data[Home] [Help]

APPS.WMS_WIP_INTEGRATION dependencies on MTL_GEN_OBJECT_ID_S

Line 1498: select mtl_gen_object_id_s.nextval into l_object_id from dual;

1494: where serial_number = p_serial_number
1495: and inventory_item_id = l_item_id;
1496:
1497: if( l_object_id is null ) then
1498: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1499: end if;
1500:
1501: UPDATE mtl_serial_numbers
1502: SET

Line 1627: select mtl_gen_object_id_s.nextval into l_object_id from dual;

1623:
1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1625:
1626: -- Lot number does not exist
1627: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1628:
1629: INSERT INTO mtl_lot_numbers
1630: (INVENTORY_ITEM_ID
1631: ,ORGANIZATION_ID